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
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