Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trying to open local SQL Server database
Message
 
 
À
16/01/2006 03:05:10
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:
01087100
Vues:
14
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform