Click here to Skip to main content
11,500,106 members (58,046 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
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.

Regards
ProgChd
Posted 19-Apr-12 1:57am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

(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 http://technet.microsoft.com/en-us/library/ms131321%28v=sql.105%29[^]

Hope this helps
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 345
1 Maciej Los 290
2 DamithSL 230
3 Peter Leow 181
4 OriginalGriff 167
0 Sergey Alexandrovich Kryukov 335
1 Maciej Los 290
2 DamithSL 220
3 Peter Leow 181
4 OriginalGriff 167


Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 1 Sep 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100