ExtremeFitness
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?
If I try to connect to the particular server via Remote Desktop, any subsequent ODBC connection works.
Any idea's?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
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.