Re: ODBC Connections



You should get an error if SQL Server isn't listening on
1433. Or you should blank screen with the title of the
window changing to Telnet <Your Server> if you have
successfully established a telnet connection on that port.
It just sounds like you are connecting.

-Sue

On Fri, 12 May 2006 07:22:02 -0700, Simon
<Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I`m probably being a sponge but I don`t seem to get anything using that
command from any of the PC`s.

"AAO" wrote:

did you try 'telnet YourDBServerIP 1433'?

"Simon" wrote:

I have a network with 6 machines sitting on it.

All PC`s are configued in the same way. 5 of the machines connect to a SQL
server via ODBC with no problems.

The sixth PC however does not connect to the server giving the following :-

Connection Failed
SQL State '01000;
SQL Server Error: 11001
TCP/IP Sockets Connection Open
GetHosting Name

General network error.


I`m connecting via aTCP/IP on port 1433.


Does anyone have any idea why I am encountering these problems ?


.



Relevant Pages

  • Re: IP Blocker in SBS2003 exchange
    ... > What I was trying to explain in the telnet section was that I realise ... > the server is listening for connections on ports 110 and 25. ... > but he can connect to port 110. ... > well as another wireless broadband connection. ...
    (microsoft.public.windows.server.sbs)
  • RE: Your message did not reach some or all of the intended recipie
    ... In your details you are saying to type the following command ... > SMTP telnet session. ... When the issue happens again, in the Exchange Server, please telnet ... > times to close the connection to the server and leave the Telnet session ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharing Internet access with a XP box.
    ... > connects to the Internet via a dial-up ISDN connection. ... > run a telnet client on the XP machine and connect to it from the BSD ... supported on FreeBSD and you have to jump through a couple of hoops to ... or, more generically, a server. ...
    (freebsd-newbies)
  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)

Loading