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
Solved

coldfusion will not connect to an access database

Posted on 2003-11-03
6
319 Views
Last Modified: 2013-12-24
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
Comment
Question by:finnstone
6 Comments
 

Author Comment

by:finnstone
ID: 9674797
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
 
LVL 14

Accepted Solution

by:
Renante Entera earned 500 total points
ID: 9675095
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
 
LVL 17

Expert Comment

by:anandkp
ID: 9676174
Try deleting ur DSN in CFAdmin & recreate it !
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 4

Expert Comment

by:procept
ID: 9676712
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
 

Author Comment

by:finnstone
ID: 9679817
i solved it myself but see the answe is here too
0
 
LVL 14

Expert Comment

by:Renante Entera
ID: 9683344
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the best software for scanning a website and then create a website map? 2 117
ip / url redirect 13 73
Soundcloud.com 4 44
Code Manager | Snippits 2 36
Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

839 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