Connection String Problem

[amrinder]

Hello All,

I am extracting data from multiple database servers so I have created 3 connection strings using ODBC to SQL Server. But when I reload the application first table is fetched then connection is established using 2nd connection string but I get an error saying "Invalid Object Name" or sometimes Login also fails for 2nd string.

Earlier it was working but after the server migration, i am facing this problem. Kindly help on this.

Thanks,
Amrinder

[#2]

You can use multiple connects, but there is only one connection active at a time. A CONNECT statement will do a disconnect of any existing connect, or you can explicitly DISCONNECT. So something like this:

CONNECT DB1

SQL SELECT ..

CONNECT DB2

SQL SELECT

check if you could access the server locally via SQL Server.

[amrinder]

Rohan,

Thanks for the reply. I am able to access SQL server and I am using the same method:

CONNECT DB1

SQL SELECT ...

CONNECT DB2

SQL SELECT

But when it comes to Connect DB2 it throws the error of login fail.