Page 1 of 1

Importing Table Definitions from a remote source/target

Posted: Thu May 10, 2007 1:04 am
by cosec
Hi,

First case:

I have been trying to import the table definitions of a source database and I am not able to connect to the database.
I use the " plug in meta - deta" option

I get an error saying "unable to connect to server - XXXX"

second case:
I am able to connect to tthe target but I get an error saying unable to retrieve table list..is it because there are no tables in the target as yet ?


It would be great if someone can give me some insight in to solving this issue

Posted: Thu May 10, 2007 1:12 am
by rafik2k
Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?

Posted: Thu May 10, 2007 1:23 am
by cosec
Trying to connect to a DB2 Source. The Target is also DB2
rafik2k wrote:Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?

Posted: Thu May 10, 2007 1:31 am
by cosec
hi Rafik thanks.

Its a db2 database. how do i create the dsn ?
rafik2k wrote:Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?

Posted: Thu May 10, 2007 2:20 am
by rafik2k
Better involve DBA to create dsn for you.
You need to create dsn in server where DatStage resides.

For windows environment you can create system dsn using Data Sources(ODBC) under control panel.

Search web for more information.

Posted: Thu May 10, 2007 2:26 am
by cosec
Thanks
rafik2k wrote:Better involve DBA to create dsn for you.
You need to create dsn in server where DatStage resides.

For windows environment you can create system dsn using Data Sources(ODBC) under control panel.

Search web for more information.

Posted: Thu May 10, 2007 4:27 pm
by ray.wurlod
Check also that the DB2 instance has been started. You can also get "failed to connect" errors if it has not been started.