Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax for opening .dbf via ODBC
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01366314
Message ID:
01366337
Vues:
12
>>A parameter to SQLSTRINGCONNECT() is a string
>>>
>>pnConnect = SQLSTRINGCONNECT("Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;")	
>>>
>
>The connection part works. But when I try to get the data (using SQLEXEC()) from .dbf I get the following error:
>
>
>Connectivity error: [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the
>object 'f_my_table'.  Make sure the object exists and that you spell its name and the path name correctly.
>
You've to provide SQLEXEC() with a statement to execute. Also try SQLTABLES() to get the list of available tables
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform