Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to SQL Server 2005 Express
Message
De
14/03/2005 14:50:41
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
00995558
Message ID:
00995665
Vues:
13
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform