Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to SQL Server 2005 Express
Message
 
 
À
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:
00995697
Vues:
19
I finally did get the ODBC connection to work. My biggest problem was with the Data Explorer Task Pane. I had to add an ADO connection instead of a SQL Server or SQL Database connection.

>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!
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform