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.
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.
