ODBC TimeOut Error

ODBC TimeOut Error

Post by TWFudWV » Sat, 10 Dec 2005 03:07:01


I not enable to create a User DSN to connect to my server. I am using TCP/IP
net lib, I have tried upgrading MDAC, I still am unable to get past the
screen where it asks for authentication method(SQL). It throws the the
following error: Connection Failed: SQLState: 'HYT00' SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired. I don't know if this is
an issue but the servers have gateways that are on different subnets. one is
on a 1.2.x subnet and the other is on a 1.2.y subnet. Would this contribute
to my problems thanks for any help .