You are right Gary.. The error gone after we restart the web server.. but it 

come back again now? can anyone help us? sometimes after refreshing the page 

for few time it seems to be ok but the error come back again when viewing it 

for the second time

thanks!hope to hear good news from u guys



>From: "Gary Hartge" <ghartge@u...>

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

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

>Subject: [asp_database_setup] Re: Unspecified error...Help please

>Date: Wed, 18 Jul 2001 19:24:57

>

>I have the same problem and I am only linking to two tables an an Access

>database. I have noticed that if I reboot my web server the error goes

>away until I add some code and make a mistake or two. I have a windows

>2000 server.

>Of course this does not help either one of us since it does not address

>why this happens in the first place. Just a note to let you know you are

>not alone! Can anyone help with this issue/problem??

>

>Thanks,

>Gary

>

>

> > Yes.. i'm using MS Access.. but i do close the connection , could it be

> > because i have too many files linking each other? but that's waht i need

>to

> > do, any idea how can i solve this.. the program will be ok ih i keep

>trying

> > refresh the page for several time after a while

> > thanks!

> > regards!

> >

> > >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!

> > >

> > >

> > >

>

You really need to remember that access was designed as a low-volume system.

When you start doing intense things with it- start tying in multiple

connections- Access just won't handle the work.



Have you installed the latest office service pack? It could be a known issue

that has been fixed. 



How are you making your data connections? Are you making it application

scoped? Session Scoped? On Each Page? Are you setting your RS to nothing

*BEFORE* closing the connection?





Hal Levy

StarMedia Network, Inc.

Intranet Development Manager 



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

> From: COCO LUA SUAT CHOO [mailto:cocolua@h...]

> Sent: Thursday, July 19, 2001 5:34 AM

> To: ASP Database Setup

> Subject: [asp_database_setup] Re: Unspecified error.. Still can't be

> solved... help please

> 

> 

> You are right Gary.. The error gone after we restart the web 

> server.. but it 

> come back again now? can anyone help us? sometimes after 

> refreshing the page 

> for few time it seems to be ok but the error come back again 

> when viewing it 

> for the second time

> thanks!hope to hear good news from u guys

> 

> >From: "Gary Hartge" <ghartge@u...>

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

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

> >Subject: [asp_database_setup] Re: Unspecified error...Help please

> >Date: Wed, 18 Jul 2001 19:24:57

> >

> >I have the same problem and I am only linking to two tables 

> an an Access

> >database. I have noticed that if I reboot my web server the 

> error goes

> >away until I add some code and make a mistake or two. I have 

> a windows

> >2000 server.

> >Of course this does not help either one of us since it does 

> not address

> >why this happens in the first place. Just a note to let you 

> know you are

> >not alone! Can anyone help with this issue/problem??

> >

> >Thanks,

> >Gary

> >

> >

> > > Yes.. i'm using MS Access.. but i do close the connection 

> , could it be

> > > because i have too many files linking each other? but 

> that's waht i need

> >to

> > > do, any idea how can i solve this.. the program will be 

> ok ih i keep

> >trying

> > > refresh the page for several time after a while

> > > thanks!

> > > regards!

> > >

> > > >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!

> > > >

> > > >

> > > >

> >

I do not make my connection in any appliaction or session.. and i close the 

connection too. should it be close the connection for the recordset first 

before set it to nothing or vice versa

thanks!



>From: Hal Levy <hal.levy@s...>

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

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

>Subject: [asp_database_setup] Re: Unspecified error.. Still can't be s     

>olved... help please

>Date: Thu, 19 Jul 2001 08:05:32 -0400

>

>You really need to remember that access was designed as a low-volume 

>system.

>When you start doing intense things with it- start tying in multiple

>connections- Access just won't handle the work.

>

>Have you installed the latest office service pack? It could be a known 

>issue

>that has been fixed.

>

>How are you making your data connections? Are you making it application

>scoped? Session Scoped? On Each Page? Are you setting your RS to nothing

>*BEFORE* closing the connection?

>

>

>Hal Levy

>StarMedia Network, Inc.

>Intranet Development Manager