Click here to Skip to main content
15,901,001 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Code project readers i would like your kind attention towards my one of the problem:

1. I have a Visual Foxpro application, in which i am accessing a remote SQL Server's Stored Procedure. Everything is working fine when I am installing the SQL Express 2008 in my Client Machine along with the FoxPro Application.

2. But when I am not installing the SQL Server On client Machine along with the visual FroxPro Application then I am getting a error " SQL Connect Error", Cannot Make Connection.

3. Is their any way that i don't have to install the whole SQL Express on client machine and i can only install the required libraries.


1 solution

(Wow... an old-unanswered thread. Hope this would help anyone come across here)

1 & 2) I guess your problem is SQL Server's ODBC native client driver. SQL Server 2008 comes SQL Native Client 10.0 (unfortunately Microsoft doesn't provide stand alone installer for that). I see lots of VFP apps that 'hard code' the driver name inside the program and there's no way to change it (other than recompile the apps). By installing SQL Server, you install the ODBC driver, and that explains why the application run. Without SQL Server, the driver is not exist and that's why you got the error.

3) Try to install SQL Server Native Client 10.0 driver. You will need to 'trick' SQL Server installer a bit though. Information to do that is in[^]

Hope this helps
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900