Link to home
Start Free TrialLog in
Avatar of aoibheil
aoibheilFlag for United States of America

asked on

Adding a MS Access datasource in CFMX getting java.sql.SQLException: SQLException occurred in JDBCPool

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.  

Help please!
Avatar of aoibheil
aoibheil
Flag of United States of America image

ASKER

Sometimes posing a question can help you solve it.  Got it fixed.
u cld ask the site moderator to remove the question & refund ur q's points !

K'Rgds
Anand
Thanks Anard, I'll do that!
ASKER CERTIFIED SOLUTION
Avatar of SpideyMod
SpideyMod

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial