Issue with Coldfusion and Databases

Posted on 2003-03-06
Medium Priority
Last Modified: 2013-12-24
I'm most familiar with ASP. I've learned a bit of Coldfusion in the past two weeks. Please forgive me if I sound ignorant.

The problem we're having: I two a Databases, each with a System DSN pointing to them on our web server.

One is an Access database.

The other is a pure SQL database.

I'm have code that accesses one database or the other based on certain criteria.

Due to my lack of knowledge, I'm mixing ASP and Coldfusion pages.

CreatePDF.cfm redirects to CreateParam.asp which redirects to MergePDF.asp which redirects to Email.cfm.

Once it's decided which database will be used, each page will try to open that database when it opens... it does it's thing... then redirects to the next page.

Problem being... Once I leave the first CFM page (CreatePDF.cfm) my first ASP page (CreateParam.asp) is unable to open the database. CreatePDF.cfm is basically holding the database hostage.

What can I do?

I've found code for DSN-less connections and in the code they can explicitly CLOSE the database, as I am used to in ASP, but it only works with CFServer 5. I can't code it that way with that kind of restriction.

I need to be able to close the Access and the SQL databases after ColdFusion is done with them so that the next page can open it.
Question by:xulaando
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

Accepted Solution

Malpheus earned 160 total points
ID: 8082551
Try going into the settings for your access database DSN in cold fusion administrator. Click the 'cf settings...' button and uncheck the box labeled 'Maintain database connections'.

Author Comment

ID: 8083068
That was exactly what I was looking for! I had a feeling it would be something to that effect!

I did also have rights problems. Since ColdFusion apparently doesn't care about the Windows 2000 security so much, it didn't need the Internet Guest account to have rights to the database. Once we gave the Internet Guest account rights and took out the 'Maintain database connections' it worked fine!


Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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…
Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
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