>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.
Mark McCasland
Midlothian, TX USA