Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to SQL Server 2005 Express
Message
From
14/03/2005 14:50:41
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00995558
Message ID:
00995665
Views:
14
This message has been marked as a message which has helped to the initial question of the thread.
Hi Mark,

I have been testing MSDE and recently installed SQL Express on the same local machine (Server JUANC), after trying some things, the Connection String from VFP is like this:
lc="Driver=sql native client;server=juanc\sqlexpress;uid=sa;pwd=MyPwd"
? SQLSTRINGCONNECT(lc)
Regards,



>I have downloaded and installed SQL Server 2005 Express beta and the Express Manager onto my laptop. I used the Express Manager to run the scripts that created the Pubs and Northwind databases. All of this is running, and I can query these databases via the XM. I accepted the default instance name of SQLEXPRESS during the installation, but the problem is I can not get VFP9 to connect to this server. Has anyone been able to do so using the Data Explorer Task Pane and/or SQLSTRINGCONNECT? If so, what's the magic key? TIA!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform