Hi all,
how do we verify that we are able to connect to all the databases that are setup in particular job, means in the source and the target odbc stages.
thnx in advance.
to check whether specified database is working...
Moderators: chulett, rschirm, roy
Ho to check the database conenction
Hi chullet,
its not actually a general question. see if i give dsn, username and password. instead of seeing the View data from a database stage.. is there any other option, just i want to verify the give dsn and the username password is working properly for the database stages...
thnx in advance
its not actually a general question. see if i give dsn, username and password. instead of seeing the View data from a database stage.. is there any other option, just i want to verify the give dsn and the username password is working properly for the database stages...
thnx in advance
to check whether specified database is working...
thnx chulett its working fine.
Rajiv,
Craig was talking in general as well as about your case in particular; you can do a VALIDATE run to see if your database connectivity and other job attributes are runnable or you can do a view data. Other ways of checking your DSN,UserId & Password are more convoluted.
If you wish to do this from a sequence it is quite easy, call up a dummy job that connects to the the database and use the return code to see if your Db is available.
Craig was talking in general as well as about your case in particular; you can do a VALIDATE run to see if your database connectivity and other job attributes are runnable or you can do a view data. Other ways of checking your DSN,UserId & Password are more convoluted.
If you wish to do this from a sequence it is quite easy, call up a dummy job that connects to the the database and use the return code to see if your Db is available.