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

coldfusion will not connect to an access database

i get this error..i am running mx on win xp

[]java.sql.SQLException: No datasource named BlueprintDatabase is configured in jrun-resources.xml
The root cause was that: java.sql.SQLException: No datasource named BlueprintDatabase is configured in jrun-resources.xml
0
finnstone
Asked:
finnstone
1 Solution
 
finnstoneAuthor Commented:
i should add that it works for odbc datasources just not access ones and that i have the access ones already set up as odbc sockets in my datasource manager in control panel.

this is weird. it stoppe working after i downloaded sp8 for ms access jet engine.
0
 
Renante EnteraSenior PHP DeveloperCommented:
You will have to recreate your odbc socket using your ms access database.

Then add again the datasource on your ColdFusion MX Administrator specifying the odbc socket you created as your Database.  Be sure that your datasource name should be BlueprintDatabase since that is what you are using.

Goodluck!
eNTRANCE2002 :-)
0
 
anandkpCommented:
Try deleting ur DSN in CFAdmin & recreate it !
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
proceptCommented:
Hi,

the SP may have changed he dirvers.... try re-creating an ODBC data source for that Access DB and then try againto connect through CF.

BTW. If you have the option of directly connecting to it with CF MX (no ODBC), I would recommend doing just that, will be much faster.

Chris
0
 
finnstoneAuthor Commented:
i solved it myself but see the answe is here too
0
 
Renante EnteraSenior PHP DeveloperCommented:
I am glad that you have resolve it by yourself.  Actually, I have encountered the same problem that's why I posted it immediately for your reference.

By the way, thanks for the points and A.

Regards !
eNTRANCE2002 :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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