CF8 and Database Connectivity issue

I recently setup my XP professional with IIS and Coldfusion 8. Everything appears to be working fine, until I try to add an access database. I am getting the following error when I submit the database, any ideas as to what is happening?



* Connection verification failed for data source: tracking
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

You're entering the wrong path or file name for the database file in the DSN creation form.

Thanks for your reply.

I just resolved the issue. Apparently, CF8 does not work with ACCESS 2007. I had to save the file as an earlier version.

Rick

Must be a JDBC or ODBC issue since the type is so new. You could try setting it up using the Access Unicode JDBC driver. You can also set up an ODBC datasource in Windows and then connect to it from CF using the ODBC Bridge.

However, unless this is a really simple test application, I'd look at using a real database such as MySQL, Postgre, or MSSQL Server.

HI