Connectivity issues

Posted on 2006-05-11
Last Modified: 2013-11-21
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?
Question by:ExtremeFitness
    LVL 24

    Accepted Solution

    Not really (ideas). Best guess is that the server needs a patch or upgrade. The only difference I can think of off hand, is the authentication levels and processes, where the RD connection processed the authentication needed to loosen something on the server to run. A simlar thing could have happened on the workstation. You can try running proggies like NetStat, and watching TaskManager to see what shows up different during the process getting successful connection.
    LVL 44

    Expert Comment

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

    Expert Comment

    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?

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Lets look at the default installation and configuration of FreeProxy 4.10 REQUIREMENTS 1. FreeProxy 4.10 Application - Can be downloaded here ( 2. Ensure that you disable the windows fi…
    #Citrix #Citrix Netscaler #HTTP Compression #Load Balance
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now