Visual Query cannot execute query to dBase


Win9x

Microsoft ODBC dBase driver

There was persistent error "Invalid..." when try execute SQL query using Microsoft ODBC driver to dBase table named "xxstat_w.dbf". The queries to other tables work OK. Problem causes underscore in file name. (but filename "xxstat_w.dbf" is OK). Renaming to "xxstat-w.dbf" and problem is gone.

I’ve seen this error quite

I’ve seen this error quite a lot during my time there fighting hackers. But sometimes I forget and have to remind myself how to fix it, the SQL querys using Microsoft ODBC are so unreliable.wedding invitations

Try execute SQL query using

Try execute SQL query using Microsoft ODBC driver to dBase table named "xxstat_w.dbf". The queries to other tables work OK. Problem causes underscore in file name. (but filename "xxstat_w.dbf" is OK). Renaming to "xxstat-w.dbf" and problem is gone.Thanks for sharing.
Regards,
bell - Apex Professionals LLC