SQL Server connections
Posted: Tue May 31, 2005 5:24 am
Hi all,
I am currently hitting an error in the DataStage Manager > Import > Table Definitions > ODBC Table Definitions >
DSR.MetaGeta(GET.TABLES)(SQLConnect('MYS_SIEBEL_DB','MIFactBase')): BCI Error:
SQLSTATE=IM003,CODE=0,[DataStage][SQL Client]An unknown DBMS type has been specified
SQLSTATE=IM997,CODE=0,[DataStage][SQL Client]An illegal configuration option was found
Below are the .odbc.ini file that is configured:-
[KOREA_DB]
Driver=/u01/app/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=DB_MI_TEST
LogonID=pcakorea
Password=pcakorea
Address=128.231.160.65,1433
QuotedId=Yes
AnsiNPW=Yes
[MYS_SIEBEL_DB]
Driver=/u01/app/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=ESG_MLY_PS01
LogonID=MIFactBase
Password=abcd1234
Address=18.37.20.20,1433
QuotedId=Yes
AnsiNPW=Yes
The connection to the KOREA_DB works perfectly fine. Why does MYS_SIEBEL_DB encounters an error? Please help!!
I am currently hitting an error in the DataStage Manager > Import > Table Definitions > ODBC Table Definitions >
DSR.MetaGeta(GET.TABLES)(SQLConnect('MYS_SIEBEL_DB','MIFactBase')): BCI Error:
SQLSTATE=IM003,CODE=0,[DataStage][SQL Client]An unknown DBMS type has been specified
SQLSTATE=IM997,CODE=0,[DataStage][SQL Client]An illegal configuration option was found
Below are the .odbc.ini file that is configured:-
[KOREA_DB]
Driver=/u01/app/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=DB_MI_TEST
LogonID=pcakorea
Password=pcakorea
Address=128.231.160.65,1433
QuotedId=Yes
AnsiNPW=Yes
[MYS_SIEBEL_DB]
Driver=/u01/app/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=ESG_MLY_PS01
LogonID=MIFactBase
Password=abcd1234
Address=18.37.20.20,1433
QuotedId=Yes
AnsiNPW=Yes
The connection to the KOREA_DB works perfectly fine. Why does MYS_SIEBEL_DB encounters an error? Please help!!