DSXchange

Hi,

I am able to connect to my remote database server using ODBC.
I am successfully able to create type trees with this connection definition.

When I run my maps to load a flat file into the database, the map loads data into the tables for the first couple of times.

From the next run, I get a message saying target not available

What would be the possible issue?
I am wondering how I can debug this issue. Please help me.

Thanks in advance

Have you checked that the diagnosis is accurate - that is, the database server itself is actually unavailable, or has too many connections?

ray.wurlod wrote:Have you checked that the diagnosis is accurate - that is, the database server itself is actually unavailable, or has too many connections? ...

Yes sir. The database server is available.
As you said, may be there are too many connections to the remote machine.

I get the same error at times when I run my maps in my local machine too. Now, the database server is installed in my local machine; am trying to access the table in my local DB.

Thanks.
Kiran

The standard map log will be insufficient when dealing with DB errors. You'll want to follow Rep's advice and turn on the db trace '-t'. run the map and look for a dile extention of 'dbl' unless you override the trace file name.