Access Error - Updated from 5 to MX 7

[disch]

I recently upgraded from Coldfusion5 to MX7 and changed one of my datasources
from an Access db to a MySQL one. I'm using the same datasource name as in my
coding previosly with Access.

I'm getting " Error Executing Database Query". Here is my code for that line:

<cfquery name="list_persons" datasource="person_db" username="username"
password="password">

Any help appreciated

[disch]

ok, I figured part of it out... I added 'dbname="person_db"' and downloaded and
installed a jdbc driver because I'm using mysql 4.0.23.

Now i get the error " The system has attempted to use an undefined value,
which usually indicates a programming error, either in your code or some system
code."

My line is =>
<cfquery name="list_persons" datasource="person_db" dbname="person_db"
username="" password="">