Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to open local SQL Server database
Message
 
 
To
16/01/2006 03:05:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01087065
Message ID:
01087100
Views:
15
The connection string you're using doesn't look like valid ODBC connection string. Use ODBC manager to create File DSN, open it in any text editor and copy connection string from there.

>I am trying to open a local SQL Server database. From the VS 2005 interface, the connection string gives this:
>
>
>Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Visual Studio Projects\Test\Test.mdf";Integrated Security=True;User Instance=True
>
>
>So, from VFP, I do this:
>
>
>lcSQLString=[Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Visual Studio Projects\Test\Test.mdf";Integrated Security=True;User Instance=True]
>lnSqlHandle = SQLSTRINGCONNECT(lcSQLString)
>
>
>But, as soon as I execute the SQLSTRINGCONNECT line, I have this Select Data Source window which is appearing. How can I succeed to open this connection?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform