Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I did try that and it didn't work.
>
>When I turn off ODBC login prompts, I get tbe following error message:
>
>Connectivity Error: [Microsoft][ODBC Driver Manager]Data Source Name not found and no default driver specified.
>
>Does Foxpro's connection string support not include the OLEDB provider?
PMFJI,
From this connection string it looks like you want to use SQL Server authentication. Is the server set up for this?
Otherwise it may be that the connection does not have the right parameters. The easiest way to make sure that you are using the right parameters is by creating a .udl file, double-click on it, go through the prompts and test the connection. After verifying that the connection is good open the .udl file with a text editor and copy and paste the connection string on the last line to your program. HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement