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

Posted on 2003-03-12
Medium Priority
Last Modified: 2013-12-24
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!
Question by:aoibheil
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Author Comment

ID: 8124396
Sometimes posing a question can help you solve it.  Got it fixed.
LVL 17

Expert Comment

ID: 8126329
u cld ask the site moderator to remove the question & refund ur q's points !


Author Comment

ID: 8127370
Thanks Anard, I'll do that!

Accepted Solution

SpideyMod earned 0 total points
ID: 8130657
PAQ'd and points refunded.

Community Support Moderator @Experts Exchange

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question