Adding a MS Access datasource in CFMX getting java.sql.SQLException: SQLException occurred in JDBCPool
Posted on 2003-03-12
I've had this problem before and solved it. Somehow the solution became as illusive as my last hard drive.
Every time I try and connect to an Access ODBC DSN I get:
Connection verification failed for data source: Arbor
java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info
If I try to go with CFMX's native Access driver I get the same thing.
Things I've tried.
Assigning the login for CFMX's services to administrator rather than local system account (I had to do that for SQL server at work). Reassigning them back to local system account.
Assigning users and passwords to everything involved (all admin privs), and then no longer using them.
System Win XP Pro sp1. Access 2002 (this is one difference, before it was Access 2000).
MDAC is up to date.
I've even considered throwing the pc out the window. '
The most irritating thing is that before the hard drive failed I had it set up fine. What I seem to remember doing is reassigning the login for the CF services to the administrator, not the local system services. Creating a system DSN pointing to the access db (the access db had no password). The through CF Admin using odbc sockets pointing to that dsn.