We have an sql server as database for a source system.The data connection has been setup for the same.While i am able to connect it through toad but when trying to connect in datastage through import wizard, i am getting timed out error.so can anyone let me know what is the exact problem
cheers,
Sagar
ODBC connection not able to connect in datastage
Moderators: chulett, rschirm, roy
-
SagarMelam
- Participant
- Posts: 26
- Joined: Mon Apr 21, 2008 4:03 am
- Location: Amalapuram
Have you checked your .odbc.ini and uvodbc.config files are setup correctly on your server??
You can use the DS_CONNECT command from a universe command prompt within your project directory to confirm if you have setup your config correctly. I.E. locate directory where project is on file system, and cd to that location, check uvodbc.config entry in this location for an entry to your database, as setup in '.odbc.ini', enter 'uvsh', and you should go into Universe command line, then enter 'DS_CONNECT 'DBNAME', and provide credentials. This will ensure connectivity from DS Engine, not from your client through Toad. Post back results if you are still having problems.
You can use the DS_CONNECT command from a universe command prompt within your project directory to confirm if you have setup your config correctly. I.E. locate directory where project is on file system, and cd to that location, check uvodbc.config entry in this location for an entry to your database, as setup in '.odbc.ini', enter 'uvsh', and you should go into Universe command line, then enter 'DS_CONNECT 'DBNAME', and provide credentials. This will ensure connectivity from DS Engine, not from your client through Toad. Post back results if you are still having problems.
Regards
Chris Fuller
"Reality is what refuses to go away when you stop believing in it"
Chris Fuller
"Reality is what refuses to go away when you stop believing in it"