Accessing DBase

[leenad]

I have done all the required DSN setup. But when I do a query, I encounter the
following error:

The Microsoft Jet database engine could not find the object 'Tr20040101'.
Make sure the object exists and that you spell its name and the path name
correctly.

Anyone has any ideas?

Thanks.

[Dan Bracuk]

Do you have a table in your db with that name?

[leenad]

Hi,

The tables do exist. The list of tables I have is as below:
Tr20040101.DBF
Tr20040102.DBF and so on...

Thanks.

[leenad]

Any solution for this problem? Any one?

[speedpedal]

leenad,

If you are still having problems with this, use another JDBC driver instead of
ODBC. The error that you are getting when using the ODBC socket is the ODBC
driver itself. Dbase was supported in CF5, but not in MX, although, you can
still make the connection via ODBC.

To make the long story short, here is a link to the JDBC Driver for an Xbase
DB system (dBASE)

[url]http://www.downloadjunction.com/product/software/59911/[/url]

Instruction on how to use this is included in the ZIP file.

Hope this helps.

[leenad]

I have installed the recommended driver for testing but I still get the same error. Any clues?

[Mike L]

We got the connection working using an ODBC Socket connected to a Windows
System DSN (DBase Driver). Is there any value to using this HXTT driver instead?

Also, where is the best place to put the JAR file on a CFMX7 installation?

Note: It is critical that your DBF is 8.3 compliant or the ODBC connection
will not work.