Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to open local SQL Server database
Message
 
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:
01087320
Views:
10
>>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;")
>>
>
>But, how are you defining the database you want to access?
O Sorry, I could not include it
m1 = SQLSTRINGCONNECT("DRIVER=SQL Native Client;SERVER=BORIS1\SQLEXPRESS;Trusted_Connection=Yes;APP=Microsoft Visual FoxPro;WSID=BORIS1;Database=Task")
The same is with
m1 = SQLSTRINGCONNECT("DRIVER=SQL Server;SERVER=BORIS1\SQLEXPRESS;Trusted_Connection=Yes;APP=Microsoft Visual FoxPro;WSID=BORIS1;Database=Task")
I just test it and have no problems with connection.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform