| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Unix to SQLServer flow connect issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| slonkoski |
 Posted: Tue Mar 17, 2009 7:15 am Post subject: Unix to SQLServer flow connect issue |
 |
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
Hi, I'm trying to get a flow to connect to a SQLServer DB from a Linux broker, I tested the connection via Windows odbc so I know the names/ports/uid/pw are correct, but when I plug the data into odbc64.ini and run mqsisetdbparms the flow still can't connect. I get errors like
[IBM][ODBC SQL Server Driver][libssclient23]General network error. Check your network documentation.'
[IBM][ODBC SQL Server Driver][libssclient23]ConnectionOpen (Name or service not known()).
Child SQL exception
[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed'
this is my odbc64.ini config, I'm wondering if the \ in the server address is an issue?
# UNIX to SQLServer stanza
[AMSDev]
Driver=/opt/ibm/mqsi/6.1/ODBC64/V5.3/lib/UKmsss23.so
Description=DataDirect 5.3 64bit SQL Server Wire Protocol
Address=SQLDAMS\CI1252AID,2382
AnsiNPW=Yes
Database=db
QuotedId=No
ColumnSizeAsCharacter=1
Anyone have a good example of odbc64.ini for a unix>SQLServer connection?
The flow has the queue open for input, everything appears to be configured properly, but it fails. Thanks! |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Mar 17, 2009 8:59 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| What happens when you try to "telnet SQLDAMS\CI1252AID 2383" from the linux box? |
|
| Back to top |
|
|
| slonkoski |
| Posted: Tue Mar 17, 2009 9:14 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
| Hmm, I get 'Name or service not known', should I be able to connect to the instance name? I have just about 0 SQLServer knowledge so forgove any ignorant questions. I have DB2 and Oracle connections working just fine form the same broker, just stumped on SQLServer. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Mar 17, 2009 9:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Right, I think you need to put the hostname in the Address, not the instance name.
Or some other syntax, perhaps, like hostname/instance name.
The difficulty with testing it via Windows ODBC is that WINS resolution is going to resolve SQLDAMS to the correct address, and you may need something different for DNS on Linux... |
|
| Back to top |
|
|
| slonkoski |
| Posted: Tue Mar 17, 2009 11:27 am Post subject: |
|
|
Acolyte
Joined: 18 Mar 2005
Posts: 52
|
Looks like I got it working. the info center doc (and installed WMB) has this sample:
;# 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 Server Name>,<Your SQLServer Port Number>
AnsiNPW=Yes
Database=db
QuotedId=No
ColumnSizeAsCharacter=1
I put the DB name in for [SQLSERVERDB], I put the server name in for <Your SQLServer Server Name>, I put instance the port in for <Your SQLServer Port Number>, BUT, I also put the DB name in for 'Database=', which isn't high-lights, italics, orcalled out in any way. I raised a PMR to validate my guess, but my cistomer is happy!. Thank you Jeff  |
|
| 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
|
|
|
|
