| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MSDE odbc Driver |
« View previous topic :: View next topic » |
| Author |
Message
|
| gag_nm |
 Posted: Tue Jan 01, 2013 8:30 pm Post subject: MSDE odbc Driver |
 |
|
Centurion
Joined: 16 Oct 2008
Posts: 102
|
Hi,
MSDE 2000 is running on Windows PC and Message Broker is running on AIX platform.
when i am trying to connect MSDE, i am receiving following error....
| Code: |
BIP2393E: Database error: ODBC return code '-1' from data source 'MONDB'. : AX021D.43603daf-2f01-0000-0080-d41b9130fa25: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 333: ImbOdbcHandle::checkRcInner: :
BIP2322E: Database error: SQL State '08001'; Native Error Code '11'; Error Text '[IBM][ODBC SQL Server Driver][libssclient23]General network error. Check your network documentation.'. : AX021D.43603daf-2f01-0000-0080-d41b9130fa25: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 453: ImbOdbcHandle::checkRcInner: :
BIP2322E: Database error: SQL State '01000'; Native Error Code '0'; Error Text '[IBM][ODBC SQL Server Driver][libssclient23]ConnectionOpen (Hostname and service name not provided or found()).'. : AX021D.43603daf-2f01-0000-0080-d41b9130fa25: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 453: ImbOdbcHandle::checkRcInner: :
BIP2322E: Database error: SQL State 'IM006'; Native Error Code '0'; Error Text '[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed'. : AX021D.43603daf-2f01-0000-0080-d41b9130fa25: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 453: ImbOdbcHandle::checkRcInner: : |
I have set configuration in ODBC64.ini file as mentioned below..
| Code: |
[MONDB]
Driver=/ibmapp/IBM/mqsi/6.1/ODBC64/V5.3/lib/UKmsss23.so
Description=DataDirect 5.3 64bit SQL Server Wire Protocol
Address=PCNAME\TESTMSDE,1433
AnsiNPW=Yes
Database=MonitorLizardDB
QuotedId=No
ColumnSizeAsCharacter=1
|
Mqsisetdbparams command as well executed....
please advise, how we can solve this issue |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Jan 02, 2013 12:01 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
At first glance
| Code: |
Address=PCNAME\TESTMSDE,1433
|
is wrong
possibly the '/' should be '\' as Unix uses '\' where windoes uses '/'
_________________
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 |
|
|
| gag_nm |
| Posted: Wed Jan 02, 2013 1:54 am Post subject: |
|
|
Centurion
Joined: 16 Oct 2008
Posts: 102
|
that is an Database instance name as per below URL
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fah14452_.htm
| Code: |
;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC64/V5.3/lib/UKmsss23.so
Description=DataDirect 5.3 64bit SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=[b]<Your SQLServer Machine Name>\<Your SQLServer Instance Name>[/b]
AnsiNPW=Yes
Database=db
QuotedId=No |
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jan 02, 2013 7:40 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You have combined both forms of Address.
Per the sample you have shown it should EITHER be
| Code: |
| Address=PCNAME\TESTMSDE |
OR
| Code: |
| Address=PCNAME,1433 |
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
