>>>>>>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"
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement