I am looking for some information on connecting a VFP app to an SQL Server Database. I have a test VFP form that I ran on the SQL server and it connects, querys, and updates the tables using remote views very well. The problem is accessing that server on the network using the same app on a different machine. When trying to connect through the connection designer using the SQL Driver Datasourse I get the following :

Connection
SQL State : '01000'
SQL Server error : 53
[Microsoft][ODBC SQL Server Driver][dbnpntw]ConnectionOpen(CreateFile()).
Connection Failed
SQL State : "08001"
SQL Server Error : 6
[Microsoft][ODBC SQL Server Driver][dbnpntw]ConnectionOpen(Specified SQL Server not found.)

Could someone give some insight as to what components have to be in place to make this connection.

Thanks

Scott k