>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
When the workstation can't see the SQLServer on the network, this usually has to do with the network dlls. Get the SQLServer CD and run setup on the client machine(s). Install the client utilities. This will put all the proper network dlls on the machine. Then use the SQL Client Configuration Utility to set the network library.
HTH
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
