Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to open local SQL Server database
Message
From
16/01/2006 17:58:22
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
16/01/2006 16:57:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01087065
Message ID:
01087367
Views:
15
>>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.
>
>Even by doing this, it doesn't work.
>
>
>lcSQLString=[DRIVER=SQL Server;SERVER=.\SQLEXPRESS;Database=Master;Trusted_Connection=True;]
>lnSQLHandle=SQLSTRINGCONNECT(lcSQLString)
>? SQLEXEC(lnSQLHandle,'USE Test')
>
>
>lnSQLHandle has a value. But, executing SQLExec() on it, generates a -1.

Did you try the "server=(local)"?

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