Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

ODBC error 1236 "Client unable to establish connection"

I have a server with only SS2K5 installed on.
I'm trying to connect via my program / isqlw (which I copied from a different SS2K server installation) and I get the following error:
"Client unable to establish connection"

I'm running on the same server, I enable the named pipe, tcp-ip protocols for this SS2K5. From SS2K5 tools I can login to the instance.

Any idea?

Thanks,
Uri

[400 byte] By [UriMargalit] at [2008-2-4]
«« Meta Data Management / Dependancy Analysis
»» VS 2005 express: ".NET Framework Data Provider for ODBC" does not show up in Choose/Ch
# 1
How does you application specify the server name in the connection string? Did you restart the server after enabling the protocols?

Thanks, Debra

DebraDove at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 2

The instance is named instance, the application specify the full instance name, such as: I4SQL-YUKON\I4SQL_YUKON.

I restarted the server after enabling the protocols, but still haev errors.

I looked the the event viewer and see the following error:

The Tabular Data Stream (TDS) version 0x72020002 of the client library used to open the connection is unsupported or unknown. The connection has been closed. [CLIENT: <local machine>]

Thanks,
Uri
UriMargalit at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 3

Which version of yukon server are you running? The message indicates the TDS version 7202, which is an intermediate version during development cycle, is no longer supported by yukon server.

But if you are using SS2K isqlw tool, it should use MDAC odbc driver sqlsrv32.dll, which should use TDS version 71 and earlier?

NengwuZhu at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 4
I'm using the June CTP.

My program is linked with ODBC drivers for OLE for SQL Server with SS2K server.

Should I relink my program using some other libraries for connecting to SS2K5? Or this error is because I never installed MDAC, nor SS2K on this server?

Thanks again,
Uri

UriMargalit at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified