Re: Help Needed Configuring ODBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Administrator (administrator_at_norepliesplease.com)
Date: 09/30/04

  • Next message: Richard Dale: "UNICODE MFC App Fails to load cursor lib. in VS.NET 2003" 
    Date: Thu, 30 Sep 2004 13:35:29 -0400

    Hello Fred,

    The only thing I can think is that firewall at your work is blocking 1433. The Connect() message means that a TCP/IP
    socket was not created. From your office's server machine go to http://aboutmyip.com and see if port is open.

    Fred Goldberg wrote:

    > In the Office we have a Win2000 Server running MS SQL Server 2000. I know
    > the servers external IP address (xxx.xxx.xxx.xxx) and we have a sub-domain
    > set up (subname.mycompserver.com). I have a login and password into the
    > server as well as the SQL login and password. The firewall is open on port
    > 1433. From my office PC, I can access SQL, using ODBC, with Access or my
    > Perl programs.
    >
    > At home, I'm running WinXP Pro. Although it shouldn't have been necessary,
    > I installed MS SQL Server client. I connect to the Internet using a Comcast
    > cable modem and do not have a static IP address. Whenever I try to set up
    > ODBC to access my office's SQL server using ODBC Data Source Administrator
    > / Add SQL Server, it fails with the following error message:
    >
    > Connection Failed
    > SQL State: '01000'
    > SQL Server Error: 10060
    > [Microsoft][ODBC Server Driver][TCP/IP Sockets]Connection Open (Connect())
    > Connection Failed:
    > SQL State: '08001'
    > SQL Server Error: 17
    > [Microsoft][ODBC Server Driver][TCP/IP Sockets]SQL Server does not exist or
    > access denied.
    >
    > Is it possible to establish this ODBC connection into SQL and, if so, what
    > am I doing wrong. Thanks.
    >
    > Fred

  • Next message: Richard Dale: "UNICODE MFC App Fails to load cursor lib. in VS.NET 2003"

    Relevant Pages

    • Re: newbie Frage zu Server-Explorer - Datenverbindungen
      ... "Microsoft SQL Server " an. ... Ich könnte den Firewall wohl ausschalten, da die Maschine via Proxi ins Netz geht. ... Ich versuche doch nur - lokal innerhalb meiner eigenen Machine - auf der ich als Admin arbeite - hinzubekommen, dass der Servername (oder meinetwegen auch lokal oder was angezeigt wird. ... Im SQL Server Configuration Manager habe ich Shared Memory, Named Pipes, UND TCP/IP Aktiviert. ...
      (microsoft.public.de.german.entwickler.dotnet.datenbank)
    • Re: Need ODBCDirect-ion
      ... through Jet before going to SQL via ODBC if it is designed well? ... database group asking this question). ... You need experience with sql server. ...
      (microsoft.public.access.modulesdaovba)
    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
      (microsoft.public.sqlserver.connect)
    • Re: ODBC connection works, but connection string doesnt
      ... I'm not trying to waste time - I do have a SQL Client string, ... I can't understand why ODBC will let me through. ... why are you wasting your time using ODBC to connect to SQL Server? ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: some thoughts on the Slammer fiasco
      ... it can break SQL server. ... the port its better to do it at the router level so the firewall can do the ... > WTF are you running a software firewall on an SQL box for. ... > firewall of your choice) block port X. ...
      (microsoft.public.sqlserver.security)