>>>>>>hi
>>>>>>
>>>>>>i'm trying to connect to sql server via ODBC. when connecting by
>>>>>>spx/ipx it's work fine. But now i'm trying to connect via tcp/ip but
>>>>>>the ODBC return a error "Server not found".
>>>>>>
>>>>>>the sql server is configured for tcp/ip on port 1433. here is the odbc configuration .
>>>>>>
>>>>>>server = myserver
>>>>>>network address: = 999.999.99.99
>>>>>>network library: = Default
>>>>>
>>>>>For tcp/ip, at least for Oracle, SQL*Net is required on the client and the server. Do you know if this is true for SQL server, or if some equivalent is necessary? There is usually a "listener" on the server side, and the client side has software to install as well.
>>>>
>>>>sql server doesn't require this. the port number sounds right. make sure the server name and network address are correct.
>>>
>>>Also, make sure that TCP/IP Sockets is set as your default net library in the Client Confiuration Utility.
>>
>>thanks to all , it's working.
>
>What did you do?
sql server client utility was not on tcp/ip sockets ! thas was the problem.
and in the ODBC configuration i had to set the network libray to "dbmssocn.dll"
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only