MS SQL Server ODBC

Author

Timeout

Sql Fren

2005-04-01, 7:01 am

Hi

I am having a problem with a SQL2000 client. When I try to create a ODBC
driver to my server, it show the message:

conection failed
sqlstate : hyt00
sql server error : 0

The network connection is OK, and it only occurs with this machine.
And before that it was actually working fine.

Have tried to restart machine,reinstalled MDAC..all not working.

any ideas?

Thanks zillion!!

Bei Zhu [MSFT]

2005-04-01, 8:01 pm

From what you described, I would suggest you to double check with the
connection string, also the status of the server you try to connect. Make
sure both server and client have good network connection.

"Sql Fren" <SqlFren@discussions.microsoft.com> wrote in message
news:9B39EC00-9C32-4178-A2F7- 45E838D31105@microso
ft.com...
> Hi
>
> I am having a problem with a SQL2000 client. When I try to create a ODBC
> driver to my server, it show the message:
>
> conection failed
> sqlstate : hyt00
> sql server error : 0
>
> The network connection is OK, and it only occurs with this machine.
> And before that it was actually working fine.
>
> Have tried to restart machine,reinstalled MDAC..all not working.
>
> any ideas?
>
> Thanks zillion!!
>

Toni Myyryläinen

2005-04-14, 7:23 am

Hi,

I'm having a similar problem while connecting to SQL Server 2000 database on
Windows 2003 server. I'm trying to define a system dsn from ODBC Data Source
Administrator and I get an error message which says:

Title: Microsoft SQL Server Login
Connection failed:
SQLState: 'HYT00'
SQL Server error: 0
[Microsoft][ODBC SQL Server Driver] timeout expired

The client machine is Windows NT 4 Server with MDAC 2.6 RTM. SQL Server
driver version is 2000.80.194.00 (sqlsv32.dll) and I'm using SQL Server
authentication through TCP/IP library and port number is 1433.

I've also checked the SQL box that it's using TCP/IP library with port 1433.

-Toni

Sponsored Links