SQL server connection problem
Posted: Wed Feb 22, 2006 12:19 pm
Hi
We have a AIX box with datastage installed on it. We have sqlserver on a windows system and would like to connect to this database to get data.
How will we define the odbc connection to get connected to sql server.
What files need to be edited to get this effect.
My .odbc.ini looks like this
[SQLServer]
Driver=/app/dstage/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=EDENDB
LogonID=cognos
Password=forperot
Address=192.168.200.20,1433
QuotedId=No
AnsiNPW=No
uvodbc.config
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<dsorcl>
DBMSTYPE = ODBC
<dsodbc>
DBMSTYPE = ODBC
<sqlserver>
DBMSTYPE = ODBC
When I do a view data there is a error saying that
Fatal Error: Could not connect to datasource[DataDirect][ODBC lib] Data source name not found and no default driver specified
Can you please help us troubleshoot this.
Thanks
Bob
We have a AIX box with datastage installed on it. We have sqlserver on a windows system and would like to connect to this database to get data.
How will we define the odbc connection to get connected to sql server.
What files need to be edited to get this effect.
My .odbc.ini looks like this
[SQLServer]
Driver=/app/dstage/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=EDENDB
LogonID=cognos
Password=forperot
Address=192.168.200.20,1433
QuotedId=No
AnsiNPW=No
uvodbc.config
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<dsorcl>
DBMSTYPE = ODBC
<dsodbc>
DBMSTYPE = ODBC
<sqlserver>
DBMSTYPE = ODBC
When I do a view data there is a error saying that
Fatal Error: Could not connect to datasource[DataDirect][ODBC lib] Data source name not found and no default driver specified
Can you please help us troubleshoot this.
Thanks
Bob