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
Help Reqd: Unable to load data into the target table
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes sir. The database server is available.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? ...
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
Kiran