| Author |
Message
|
| rsapare |
 Posted: Fri May 08, 2015 5:09 am Post subject: SQL Driver UKsql26.so |
 |
|
Newbie
Joined: 08 May 2015
Posts: 7
|
Hello All,
I am working on the WMB8.0 and need to connect to SQL server 2008 using UKsql26.so driver, as it is the solution for the problem i am facing currently in odbc connection.
Could you anyone let me know, how can we download this UKsql26.so driver.
Thanks in advance.
Cheers,
Sapare |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri May 08, 2015 5:17 am Post subject: Re: SQL Driver UKsql26.so |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rsapare wrote: |
| it is the solution for the problem i am facing currently in odbc connection. |
What problem? How do you know this is the solution, and does whoever told you this is the solution know where the driver is? What version of WMBv8? Does this new driver come with a more recent WMB Fix Pack than you have loaded? Is this driver on the Microsoft web site somewhere?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rsapare |
| Posted: Mon May 11, 2015 2:33 am Post subject: |
|
|
Newbie
Joined: 08 May 2015
Posts: 7
|
Hello Vitor,
Thanks for your message.
We are working on oracle to sql server database migration.
Broker is installed in unix machine.
We tried to change the odbc configuration to connect to new sql server 2008 .
Although we are able to connect to SQL server through legacy driver UKmsss26.so,some of the queries were throwing the following error
BIP2322E: Database error: SQL State ''HY000''; Native Error Code '0'; Error Text ''[unixODBC][IBM][ODBC SQL Server Legacy Driver]Connection is busy with results for another hstmt''. : /build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp: 3437: ImbOdbcStatement::checkRcInner:  /text>
So we thought of using SQL native client.But we found UKsqls26.so SQL native cleint is missing in the drivers list present in following location /opt/wmb80/ODBC/V7.0/lib
So is it possible to install this driver externally ? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon May 11, 2015 3:04 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| rsapare wrote: |
We are working on oracle to sql server database migration.
|
Good (IMHO)
| rsapare wrote: |
.
Although we are able to connect to SQL server through legacy driver UKmsss26.so,some of the queries were throwing the following error
BIP2322E: Database error: SQL State ''HY000''; Native Error Code '0'; Error Text ''[unixODBC][IBM][ODBC SQL Server Legacy Driver]Connection is busy with results for another hstmt''. : /build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp: 3437: ImbOdbcStatement::checkRcInner: /text>
|
Ever thought of raising a PMR with IBM to get official resolution?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| rsapare |
| Posted: Mon May 11, 2015 3:38 am Post subject: Regarding PMR |
|
|
Newbie
Joined: 08 May 2015
Posts: 7
|
Hello Jedi Knight,
Thanks for your reply.
We have raised a PMR with IBM in the first stage, when I had encountered this issue with SQL server 2005 and they came up telling that the support for SQL server 2005 has been ended.
So I am now trying it with SQL server 2008. We are yet to raise a PMR again for this.
Just thought here to give a try and find my luck.
Cheers,
Sapare |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon May 11, 2015 4:33 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You might have to get the drivers from Microsoft.
Worth a double-check through the v8 documentation on configuring odbc datasources on unix. |
|
| Back to top |
|
|
|
|
