I am trying to connect to MS SQL server database using ODBC connector . I am getting error like invalid data source name .
I am using the same data source name , user id & password in ODBC enterprise & DRS stages . Those stages are working fine . But , ODBC connector is giving the issue .
Please suggest .
Thank
ODBC Connector Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are all the connection properties set up correctly in your ODBC Connector stage? What error message is generated? Can you Test the connection from within the ODBC Connector stage? Can you View Data?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.