Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to open local SQL Server database
Message
From
16/01/2006 16:51:01
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
16/01/2006 16:02:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01087065
Message ID:
01087348
Views:
12
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform