Skip to main content
S
slidingriyuprotocol
Participant
August 5, 2009
Question

Timed out trying to establish connection error

  • August 5, 2009
  • 2 replies
  • 4703 views

We are using ColdFusion 8, this error has been plaging us since we added many datasources. Read up about it online and even changed JVM versions, from 1.6 to 1.5, to no avail. Any suggestions?

Thank you. 

This topic has been closed for replies.

2 replies

A
Adam Cameron.
Inspiring
September 5, 2009

this error has been plaging us since we added many datasources.

Are the DSNs pointing to the same MDB file?  Access is a single-user DB system, so only one connection can connect to it at a time.

--

Adam

A
Anonymous
August 6, 2009

When you say timeout are you referring to adding in the CF admin?

Do the DSNs work at all after this?

Have you check the database permissions for the user the DSN is for?

Is it just timing out adding the DSN?  How many DSNs?

Byron Mann

mannb@hostmysite.com

byronosity@gmail.com

Software Architect

hosting.com | hostmysite.com

http://www.hostmysite.com/?utm_source=bb

S
slidingriyuprotocolAuthor
Participant
August 6, 2009

As far as I know there is no problem with accessing pages. It is only the databases that seemingly cannot be accessed or added or anything, which results in a timeout error. This problem is intermittent and goes away by itself after awhile. By the way, we are using Microsoft Access databases. I don't think it's a permissions issue because if it was, the user wouldn't even be able to access the databases.

A
Anonymous
August 6, 2009

I would look to anything that is running at the time this happens.  It could be a large update on the database that is causing a lock and forcing other threads to wait and timeout.

You can enable logging of long running pages in CF admin that might help narrow things down.  You can also log all database request in the DSN under the advanced settings.  These might help track things down.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices