asked on

Connectivity issues

When I try to connect to a remote databse server through an ODBC connection, the connection times out.
If I try to connect to the particular server via Remote Desktop, any subsequent ODBC connection works.

Any idea's?

ASKER CERTIFIED SOLUTION

SunBow

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

scrathcyboy

This is in the server setup. First, you havent got the ODBC connection setup right on the server, is there a login/PW applied when needs to be entered? If so, maybe get rid of it, ODBC doesnt need that, since the connect is done in code. Also the ODBC drivers need to be on the PC making the connection. Check both these.

As for connecting via remote desktop, the reason this works is that the connection is "local" to the ODBC at that point, not REMOTE. So your ODBC database is not setup right for remote connects to the database.

giltjr

Could clear something up? You state that you can connect to the remote database server after you connect using Remote Desktop. Are you running the program on your PC or on the PC you just remote desktoped to?

If you are running the program from the system you just remote desktop'ed do, then scratchyboy is correct. You are connecting from the local machine to the local machine.

Try connecting from your PC, then do a netstat -an and check what the status of the connetion is, look for the database servers IP address. What is the status?