Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trying to open local SQL Server database
Message
De
16/01/2006 16:51:01
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
16/01/2006 16:02:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01087065
Message ID:
01087348
Vues:
13
>>Here the connection string I used on my Home computer for SQL Server 2005:
>>
>>m1 = SQLSTRINGCONNECT("DRIVER=SQL Native Client;SERVER=BORIS1\SQLEXPRESS;Trusted_Connection=Yes;APP=Microsoft Visual FoxPro;WSID=BORIS1;")
>>
BTW, my setting for server (local MSDE) is "SERVER=(local)". I know you've fixed this part already, but it may help someone else.

>But, how are you defining the database you want to access?

Two ways - one is DATABASE=UP241 (or whatever the DB name is). The other way is DATABASE=MASTER, and then issue the USE YOURDB as the first command after connection, and check the result.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform