ODBC Unix connectivity
Posted: Wed Nov 20, 2002 9:13 pm
Hi All
I am configuring ODBC to acces SQL Server Data from different server. It shows the DSN name but finally gives the following error message.
"
DSR.MetaGeta(GET.TABLES)(SQLConnect('dmssqlserver','ers2admin')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified"
The change i made in the files are as follows:
uvodbc.config
DBMSTYPE = ODBC
network = TCP/IP
service = SQLServer
host = 165.238.87.33
odbc.ini
[dmssqlserver]
Driver=/data/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Database=ERS
LogonID=ers
Password=ers
Address=165.238.87.33,1433
QuotedId=No
AnsiNPW=No
Is there anything I should do to make it work
Thanks
Rasi
I am configuring ODBC to acces SQL Server Data from different server. It shows the DSN name but finally gives the following error message.
"
DSR.MetaGeta(GET.TABLES)(SQLConnect('dmssqlserver','ers2admin')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified"
The change i made in the files are as follows:
uvodbc.config
DBMSTYPE = ODBC
network = TCP/IP
service = SQLServer
host = 165.238.87.33
odbc.ini
[dmssqlserver]
Driver=/data/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Database=ERS
LogonID=ers
Password=ers
Address=165.238.87.33,1433
QuotedId=No
AnsiNPW=No
Is there anything I should do to make it work
Thanks
Rasi