ODBC connection

[Steven]

Hi everyone

I installed the MS SQL server 7.0 on a Windows NT 4.0 SP 4 server. The network runs with TCP/IP.
I want to connect the SQL server by a ODBC-connection. Only a connection on the server (local) was successful.

The odbcping-utility reports following:
COULD NOT CONNECT TO SQL SERVER

SQLState: 08001 Native Error: 6
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNMPNTW]Selected SQL server not found.

SQLState: 01000 Native Error: 53
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile()).

Do I forget to install a SQL server component? Or a network service?

Thank you for your help.

Greetings
Steven

[Anthony B. Kenitzki]

What are the properties of your ODBC data source?

You need an ODBC DSN to connect, run odbcad32 on the machine you are trying to connect with, and create one if you dont have one setup already. If you have one then post the parameters for us.

Anthony B. Kenitzki

------------
Steven at 6/10/99 11:20:53 AM

Hi everyone

I installed the MS SQL server 7.0 on a Windows NT 4.0 SP 4 server. The network runs with TCP/IP.
I want to connect the SQL server by a ODBC-connection. Only a connection on the server (local) was successful.

The odbcping-utility reports following:
COULD NOT CONNECT TO SQL SERVER

SQLState: 08001 Native Error: 6
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNMPNTW]Selected SQL server not found.

SQLState: 01000 Native Error: 53
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile()).

Do I forget to install a SQL server component? Or a network service?

Thank you for your help.

Greetings
Steven

[Steven]

I found the problem: A connection through a named pipe doesn't work...
If I change the client network library to TCP/IP, then the connection works.

What are the conditions for using the named pipe?

Greetings
Steven


------------
Anthony B. Kenitzki at 6/10/99 5:41:55 PM


What are the properties of your ODBC data source?

You need an ODBC DSN to connect, run odbcad32 on the machine you are trying to connect with, and create one if you dont have one setup already. If you have one then post the parameters for us.

Anthony B. Kenitzki

[Ray Miao]

Use named pipes if you can pass nt authentication on sql server.


------------
Steven at 6/11/99 6:59:53 AM

I found the problem: A connection through a named pipe doesn't work...
If I change the client network library to TCP/IP, then the connection works.

What are the conditions for using the named pipe?

Greetings
Steven


------------
Anthony B. Kenitzki at 6/10/99 5:41:55 PM


What are the properties of your ODBC data source?

You need an ODBC DSN to connect, run odbcad32 on the machine you are trying to connect with, and create one if you dont have one setup already. If you have one then post the parameters for us.

Anthony B. Kenitzki