IIB v9 ODBC Configuration Error while setting up and validating SQLServer database.<\/p>\n
Following error messages are displayed while validating the SQLServer database,<\/p>\n
BIP2393E: Database error: ODBC return code ‘-1’ from data source<\/p>\n
BIP2322E: Database error: SQL State ”01000”; Native Error Code ‘0’;<\/p>\n
Resolution<\/span><\/p>\n While using SQLSERVER Database make sure that you are giving proper .so file path and this has to be right one other wise above mentioned error will be displayed. SQL Server driver UKsqls26.so<\/span> was introduced with IBM Integration Bus<\/span> V9.0.0.3. If you are at an earlier version than V9.0.0.3, SQL Server driver UKmsss26.so<\/span> should be used.<\/p>\n So the path used in the ODBC.ini file should be as below,<\/p>\n IIB v9.0.0.2 and v9.0.0.1 use: <Your Broker install directory>\/ODBC\/V7.0\/lib\/UKmsss26.so<\/p>\n Above IIB v9.0.0.3 use: <Your Broker install directory>\/ODBC\/V7.0\/lib\/UKsqls26.so<\/p>\n So the ODBC.ini file will be update as below (assuming v9.0.0.3),<\/p>\n ;# UNIX to SQLServer stanza <\/p>\n Please note that an alternative way is mentioned to locate server using a named instance. We can either use<\/p>\n 1. <Your SQLServer Machine Name>,<Your SQLServer Port Number><\/p>\n or<\/p>\n 2. <Your SQLServer Machine Name>\\<Your SQLServer Instance Name><\/p>\n If 1 fails please use 2 for connecting to the SQLServer instance.<\/p>\n <\/p>\n IBM Integration Bus Command to validate the Database is,<\/p>\n mqsicvp <brokername> -n <DB name><\/p>\n
\n[SQLSERVERDB]
\nDriver=<Your Broker install directory>\/ODBC\/V7.0\/lib\/UKsqls26.so
\nDescription=DataDirect 7.1 ODBC SQL Server Wire Protocol
\nAddress=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
\n;# Alternative way to locate server using a named instance
\n;# Address=<Your SQLServer Machine Name>\\<Your SQLServer Instance Name>
\nAnsiNPW=Yes
\nDatabase=<Your Database Name>
\nQuotedId=No
\nColumnSizeAsCharacter=1<\/p>\n