• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

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!
0
aoibheil
Asked:
aoibheil
  • 2
1 Solution
 
aoibheilAuthor Commented:
Sometimes posing a question can help you solve it.  Got it fixed.
0
 
anandkpCommented:
u cld ask the site moderator to remove the question & refund ur q's points !

K'Rgds
Anand
0
 
aoibheilAuthor Commented:
Thanks Anard, I'll do that!
0
 
SpideyModCommented:
PAQ'd and points refunded.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now