Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax for opening .dbf via ODBC
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01366314
Message ID:
01366337
Views:
11
>>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform