sql server connect: I just added an xpclient to our network. There is a Win
2000 server running win 2000 sql server on the network.
All client machines access the server for database
access, to a Visual Foxpro Application. When i try to
connect to the application i keep getting the following
error:
Unable to login sql server, SQL State:0100, SQL server
error:53. [MS][ODBC SQL SERVER DRIVER][DBNETLIB]
Connection open (Connect()).
Connection failed, SQL State:08001, SQL Server error:17.
[MS][ODBC SQL SERVER DRIVER][DBNETLIB]SQL does not exist
or access denied.

The problem is with Name Resolution to the server.

SQL server
error:53. [MS][ODBC SQL SERVER DRIVER][DBNETLIB]
Connection open (Connect()).

Error 53 tells me this is a netbios name resolution issue.

Check to see if you client can ping the server by netbios name .
or run the following test.

net view \\servername

Work with your network staff to resolve this.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.