database execution

can not execute database connetion database

Page 1 of 1

3 Replies - 1201 Views - Last Post: 25 July 2009 - 09:08 PM Rate Topic: -----

#1 klaas1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 21-July 09

database execution

Posted 21 July 2009 - 01:59 AM

on a intermittent basis i'm getting the error that coldfusion can not execute the database connection,
while the dsn is correct and on the adminstrator the links are ok.
I'm using dreamweaver mx 2004 with coldfusion and the database is an access database
using the access database driver.
the server is running under windows 2000.

Is there anything i can do to solve this intermittent error.
Is This A Good Question/Topic? 0
  • +

Replies To: database execution

#2 xheartonfire43x  Icon User is offline

  • D.I.C Regular

Reputation: 46
  • View blog
  • Posts: 454
  • Joined: 22-December 08

Re: database execution

Posted 22 July 2009 - 09:02 AM

View Postklaas1, on 21 Jul, 2009 - 12:59 AM, said:

on a intermittent basis i'm getting the error that coldfusion can not execute the database connection,
while the dsn is correct and on the adminstrator the links are ok.
I'm using dreamweaver mx 2004 with coldfusion and the database is an access database
using the access database driver.
the server is running under windows 2000.

Is there anything i can do to solve this intermittent error.


Do you have the Access DB open when you are getting this error? If so then close it and the error will stop. If you are using it on a Development Platform I would recommend installing an express version of MS SQL server. It is free and works great for development.
Was This Post Helpful? 0
  • +
  • -

#3 klaas1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 21-July 09

Re: database execution

Posted 23 July 2009 - 06:56 AM

View Postxheartonfire43x, on 22 Jul, 2009 - 08:02 AM, said:

View Postklaas1, on 21 Jul, 2009 - 12:59 AM, said:

on a intermittent basis i'm getting the error that coldfusion can not execute the database connection,
while the dsn is correct and on the adminstrator the links are ok.
I'm using dreamweaver mx 2004 with coldfusion and the database is an access database
using the access database driver.
the server is running under windows 2000.

Is there anything i can do to solve this intermittent error.


Do you have the Access DB open when you are getting this error? If so then close it and the error will stop. If you are using it on a Development Platform I would recommend installing an express version of MS SQL server. It is free and works great for development.



I'm getting this error on the production server. not on the development server.
Was This Post Helpful? 0
  • +
  • -

#4 xheartonfire43x  Icon User is offline

  • D.I.C Regular

Reputation: 46
  • View blog
  • Posts: 454
  • Joined: 22-December 08

Re: database execution

Posted 25 July 2009 - 09:08 PM

View Postklaas1, on 23 Jul, 2009 - 05:56 AM, said:

View Postxheartonfire43x, on 22 Jul, 2009 - 08:02 AM, said:

View Postklaas1, on 21 Jul, 2009 - 12:59 AM, said:

on a intermittent basis i'm getting the error that coldfusion can not execute the database connection,
while the dsn is correct and on the adminstrator the links are ok.
I'm using dreamweaver mx 2004 with coldfusion and the database is an access database
using the access database driver.
the server is running under windows 2000.

Is there anything i can do to solve this intermittent error.


Do you have the Access DB open when you are getting this error? If so then close it and the error will stop. If you are using it on a Development Platform I would recommend installing an express version of MS SQL server. It is free and works great for development.



I'm getting this error on the production server. not on the development server.


Oh well then truthfully I would recomend using MySQL instead of Access. I have just always found Access to be much less reliable that and actual Database Engine. MySQL is free, and runs great.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1