>Hi again,
>
>Created a program on my develop machine. Access to the SQL server is not a problem on this machine. However, When I use the setup program and move the compiled program to another machine it doesnt work. I went into the ODBC program, created the connection exactly as its done on my development machine, (Both machines are on the same network), however it can never find the server...any ideas on what to check?
>
>Thanks again...
>
>Gary

Here's an extract from the ODBC SQL Server Setup Help file that might help you. It refers to the Network Library field in the ODBC SQL Server Setup screen.

****************************************************************************
Network Library

The name of the SQL Server Net-Library DLL that the SQL Server driver uses to communicate with the network software. If the value of this option is (Default) the SQL Server driver uses the client computer's default Net-Library, which is specified in the Default Network box in the Net-Library tab of the SQL Server Client Configuration Utility.

If you create a data source using a Network Library other than (Default) and optionally a Network Address, ODBC SQL Server Setup will create a server name entry that you can see in the Advanced tab in the SQL Server Client Configuration Utility. These server name entries can also be used by DB-Library applications.
****************************************************************************

Maybe the Net-Library DLL isn't present on the problem machine? Just a thought!

Gary