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