>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
Check, If the m/c on your n/w , on which you are trying to run the ODBC Application is having the drivers. (SQL ODBC drivers). They come along with VFP.
also check if the Datasource is created in your new machine. To check this, check in ODBC32 in control panel.
I worked a lot on Client server with VFP. I used, Oracle server. Some times I connect to SQL server also. From your error message, it is clear that, the problem is with your ODBC driver. Either it is not installed or the DataSource is is not created.
Reply to me if you got any further problems.
--Satya
spvedulla@hotmail.com