We help IT Professionals succeed at work.

ODBC connection problem?

jdato
jdato asked
on
Medium Priority
341 Views
Last Modified: 2012-05-04
I have SQL7 on Windows 98. I am trying to take a Window NT workstation and using ODBC try to have that user connect to the database on the 98 machine. I have other workstations that are connected to that database without any problems. I have gone through to make sure the everything is the same on every machine as far as ODBC goes. I get an error while going through the ODBC setup>:
"Connection failed: SQLSTATE 'HYT00' SQLSERVER ERROR: 0 [microsoft][odbc sql server driver] timeout expired"
What is my problem?
Comment
Watch Question

Can you ping the server?
Are you using the correct protocol (tcp/ip, named pipes ...)

Author

Commented:
Yes I can ping the server and it shows up on the network and I am able to access the shared files from that server.  All protocols are set up the same with every workstation, only the one station will not connect.

Commented:
I believe ODBC is a non-proprietary software, and for that I don't see the need for this problem. Try running ODBC test in Network Administration on win98 operating system to establish connection within its self first before going NT. See if this works.

Otherwise, See if you have set your windows 98 PC to run as a server.

Author

Commented:
the 98 PC is set to run as a server and I have 4 other computers logged into this server. 3 of which are 98 and the other is NT. The fifth computer is also an NT server which will not connect to the database.

Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
Commented:
Question has been closed as per recommendation

JGould-EE Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.