Hello,
We are connecting to SQL server DB for the first time from ODBC connector stage.The Admin says he established the connection to connect to SQL server as we provided him the Server's IP address, port number and DB name.
I can connect to the same DB from an external client but when connecting from ODBC connector giving the DSN name created and username/password it says "Failed to receive the response from the handler: request timed out". any issue with in DS ?
Please suggest my next steps
Thanks!
SQL server connection issue from ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
SQL server connection issue from ODBC
Regards,
Kenny
Kenny
Go to the 32-bit ODBC definition that the admin created and try the "test" button. If that works then the ODBC connection would seem to be correctly set up and should work in DataStage. If the "Test" doesn't work then the Admin needs to fix that. Note that the ODBC driver is 32-Bit and that system DSNs need to be used.
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am