Yes... but i do close the connection at end of the file.. any idea how?





>From: "Ken Schaefer" <ken@a...>

>Reply-To: "ASP Database Setup" <asp_database_setup@p...>

>To: "ASP Database Setup" <asp_database_setup@p...>

>Subject: [asp_database_setup] Re: Unspecified error

>Date: Thu, 28 Jun 2001 13:39:36 +1000

>

>Probably too many open connections - are you using Access/Jet?

>

>Cheers

>Ken

>

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>----- Original Message -----

>From: "COCO LUA SUAT CHOO" <cocolua@h...>

>To: "ASP Database Setup" <asp_database_setup@p...>

>Sent: Tuesday, June 26, 2001 8:21 PM

>Subject: [asp_database_setup] Unspecified error

>

>

>: I have the follwoing error when i try to open my asp file

>:

>: Provider error '80004005'

>:

>: Unspecified error

>:

>: /Department/HRA/HRAUpDB.asp, line 30

>:

>: The code for the line is

>: objConn.Open "DSN=HRAWebDB"

>:

>: however the problem does not seem to happend to every program... can

>anyone

>: tell me what's the problem with my code? thanks!

>

>

>