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
SQL server connection problem
Moderators: chulett, rschirm, roy
Based on what you supplied, the names do not match and the error suggests as much.
There is a pdf ..../Ascential/DataStage/branded_odbc/books/books.pdf that can help with this configuration and testing the connection with ../bin/example.
I would also double check the port. It may not be the default 1433.
There is a pdf ..../Ascential/DataStage/branded_odbc/books/books.pdf that can help with this configuration and testing the connection with ../bin/example.
I would also double check the port. It may not be the default 1433.
-
- Participant
- Posts: 2
- Joined: Sat Mar 11, 2006 5:26 pm