>>I am having tough time figuring how to connect to a .DBF/.DBT file via ODBC driver. This is an example of the syntax I tried which give me an error. What am I missing?
>>
>>
>>pnConnect = SQLSTRINGCONNECT(Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;)
>>
>>
>>Thank you in advance for any help
>
>The last ODBC driver for VFP was for VFP6 SP5. If your tables are created with latter versions you must use VFP OLEDB or you could try:
>
http://www.codebase.com/products/sql/odbc/?pid=google-api-odbc_fox_a1>(I didn't)
The .dbf/.dbt tables were created by some older version of non-xBase application. Thank you for the link to codebase.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham