Problem in Creating a DSN for SQL Server 3

[Faheem786]

Hi there

I have the SQL Server running on a seperate Server. I would like to establish a conncetion to that using ODBC. My personal computer does not have the SQL server.

When I tried to create a system DSN I selected the SQL server as the data source. But I could not find the name of the SQL Server (which is running on the Server PC) under the drop down of "which server do you want to conncet to?". When I manually typed the name as \\server (which is the name of the sql server) it ends up with the following error.

*****************************************************
Conncetion Failed
Sql state :'01000'
Sql server error:11001
Microsoft [ODBC sql server driver][TCP/IP sockets]Conncetion open
[gethostbyname{}]
conncetion failed
Sql state :'08001'
Sql server error:11
Microsoft [ODBC sql server driver][TCP/IP sockets]General network error.
*****************************************************

Could you experts pls help me to find a way?.

Thanks in advance.
Faheem

 

[tlbroadbent]

Leave off the \\. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Faheem786]

Broadbent

Thanks for your answer. But still I get the same error. Also the name of the sql server on the network will be automatically displayed in the drop down under
"which server do you want to conncet to?". For me it's not displayed.
I think the problem may be because of the SQL Server driver. Could you pls tell me where could find the SQL server ODBC driver for windows 98?

Thanks
Faheem

 

[tlbroadbent]

Which version of SQL erver is running?
Which version of the ODBC driver is currently installed on the PC?
Are you sure the name you have for the Server is correct?
Is the SQL Server named the same as the NT server on which it runs?
Do you know the IP address of the NT server?
Is the NT Server setup up to run the TCP/IP net library?

Download the latest ODBC drivers from Microsoft at

http://www.microsoft.com/data/.

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[connectic]

1st
Verify that the SQL Server database service is running on the remote machine.


2nd
Verify the network library that your are using on the local PC match the configuration on the remote machine (that's running the SQL database).

Make some change in the "Sql Client Configuration Utility", if necessary.

3rd
When the "Create New Database Source to Sql" window asking you
"How should SQL server verify authenticity of the login ID?" be sure the answers that you provided match the
Installation parameters on the Server.

If you usually provide a LoginID (sa by default) and a Password ( " " blank by default) for login on your sql-server be sure you past these parameters correctly to the data source configuration wizard on your local PC.

 

[RajD]

If you are sure both the machines are on the same network ( I mean accessible) then use this

server_machine\sql_server_name

Ex: NY-IT-XXX\Jupitor2001

where NY-IT-XXX is the machine name and Jupitor2001 is the SQL-Server name.

Also check the port-id to which the SQL server is configured. It may not be the default 1433.

RajD