Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.