Solved

coldfusion will not connect to an access database

Posted on 2003-11-03
6
318 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
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…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

777 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