Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • 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 EnteraCommented:
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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 EnteraCommented:
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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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