| Author |
Message
|
| zpat |
 Posted: Fri Jul 30, 2010 1:51 am Post subject: Access SQL Server from WMB 6.1 on AIX |
 |
|
Jedi Council
Joined: 19 May 2001
Posts: 5867
Location: UK
|
WMB 6.1.0.5
AIX 5.3
We are trying to access SQL server (2005). I have configured the 64 bit ODBC data sources exactly as per the manual.
The manual does not state the port, we believe the default is 1433.
We get this error - but we can connect from a Windows broker.
Any ideas?
| Quote: |
(0x01000000:Element):Exception = (
(0x03000000:Attribute):ExceptionType = 'DatabaseException' (CHARACTER)
(0x03000000:Attribute):ErrorNumber = 2393 (INTEGER)
(0x03000000:Attribute):SeverityLevel = 3 (INTEGER)
(0x03000000:Attribute):ErrorSource = '' (CHARACTER)
(0x03000000:Attribute):DiagnosticMessage = 'Root SQL exception' (CHARACTER)
(0x03000000:Attribute):CauseOfException = '( -1, BANCS2 )' (CHARACTER)
)
(0x01000000:Element):Exception = (
(0x03000000:Attribute):ExceptionType = 'DatabaseException' (CHARACTER)
(0x03000000:Attribute):ErrorNumber = 2322 (INTEGER)
(0x03000000:Attribute):SeverityLevel = 3 (INTEGER)
(0x03000000:Attribute):ErrorSource = '' (CHARACTER)
(0x03000000:Attribute):DiagnosticMessage = 'Child SQL exception' (CHARACTER)
(0x03000000:Attribute):CauseOfException = '( IM006, 0, [DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed )' (CHARACTER)
|
|
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Jul 30, 2010 2:00 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Can you show the relevant stanza from the odbc.ini?
Is it a 64-bit EG? |
|
| Back to top |
|
|
| zpat |
| Posted: Fri Jul 30, 2010 2:05 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5867
Location: UK
|
BANCS2=DataDirect 5.3 64bit SQL Server Wire Protocol
| Quote: |
[BANCS2]
Driver=/opt/IBM/mqsi/6.1/ODBC64/V5.3/lib/UKmsss23.so
Description=DataDirect 5.3 64bit SQL Server Wire
Protocol Address=xxxxxxx.xxx.com,1433
Database=RightFax
AnsiNPW=Yes
QuotedId=No
ColumnSizeAsCharacter=1 |
Yes, it is a 64 bit EG. |
|
| Back to top |
|
|
| zpat |
| Posted: Fri Jul 30, 2010 3:00 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5867
Location: UK
|
Whoops - cut and paste error, should be
| Quote: |
[BANCS2]
Driver=/opt/IBM/mqsi/6.1/ODBC64/V5.3/lib/UKmsss23.so
Description=DataDirect 5.3 64bit SQL Server Wire Protocol
Address=xxxxxxx.xxx.com,1433
Database=RightFax
AnsiNPW=Yes
QuotedId=No
ColumnSizeAsCharacter=1 |
That should work! |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 30, 2010 4:48 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
... that looks okay.
Dotting the i's and crossing the t's, you can telnet to the port # from the AIX host? You've verified with the SQLServer admin that it is port 1433? You verified the mqsisetdbparms user credentials?
Are there errors thrown when the EG starts up? |
|
| Back to top |
|
|
| zpat |
| Posted: Fri Jul 30, 2010 4:55 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5867
Location: UK
|
| I had the cut and paste error on the actual config. I think it's working now. |
|
| Back to top |
|
|
|
|
