| Author |
 Topic  |
|
|
snaayk
Senior Member
USA
1061 Posts |
 Posted - 16 April 2002 : 11:34:44
|
Any ideas on this..
I look at a page that runs a stored proc. The info displays fine. But, if I refresh I get this:
Provider error '80004005'
Unspecified error
/tony/head1.asp, line 38
Line 38 being the execution.
Now, if I wait a few minutes I can pull it again without a problem, unless I refresh right away.
I thought this might have something to do with an open connection, but I have this at the end:
rsrev.Close
rs.Close
Set rsrev = Nothing
Set rs = Nothing
con.Close
Set con = Nothing
The server is a win2k adv server.
No url its on an intranet.
Any ideas??..
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 April 2002 : 11:40:10
|
Weird indeed, Tony. What type of DB driver are you using, ODBC or OLEDB?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 16 April 2002 : 11:56:25
|
ODBC
with access97. We are suppose to get 2000 here this month, but until then 97 it is.
....wait....
I just switched to an oledb driver and it has been fixed....apparently.
Yeah, I can refresh as many times as I want with no problems. ****, that driver sucked!
Thanks again, Rui
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 April 2002 : 12:00:19
|
quote:
Yeah, I can refresh as many times as I want with no problems. ****, that driver sucked!
That's what I thought that might be the cause.
quote:
Thanks again, Rui
No problem. You are welcome  .
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 16 April 2002 12:01:20 |
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 16 April 2002 : 12:04:17
|
OT: Hey, ruirib. Looks like we're being flooded with weird database errors lately. Hmmmm...
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 April 2002 : 12:38:45
|
quote:
OT: Hey, ruirib. Looks like we're being flooded with weird database errors lately. Hmmmm...
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
Most of them seem to be due to ODBC drivers. I forgot to ask about your own drivers. What are you using?
I'd recommend the use of OLEDB drivers whenever possible.
A while ago I helped someone with a forum that was taking around 16 secs to generate default.asp and 23 to generate active topics (with SQL server). Switching to an OLEDB driver brought those times down to less than a sec for default.asp and 1.6 secs to active topics! Can you believe the difference?!
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 April 2002 : 20:30:15
|
quote:
quote:
OT: Hey, ruirib. Looks like we're being flooded with weird database errors lately. Hmmmm...
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
Most of them seem to be due to ODBC drivers. I forgot to ask about your own drivers. What are you using?
I'd recommend the use of OLEDB drivers whenever possible.
A while ago I helped someone with a forum that was taking around 16 secs to generate default.asp and 23 to generate active topics (with SQL server). Switching to an OLEDB driver brought those times down to less than a sec for default.asp and 1.6 secs to active topics! Can you believe the difference?!
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
I agree about using oledb whenever possible.
ruirib, you did a great job on the other problem too (actually, this applies to all the problems you help with) 
======
Doug G
====== |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 April 2002 : 22:52:02
|
quote:
I agree about using oledb whenever possible.
ruirib, you did a great job on the other problem too (actually, this applies to all the problems you help with)
======
Doug G
======
Doug, what can I say? Thanks, I really appreciate that  .
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 29 April 2002 : 04:30:02
|
quote:
Most of them seem to be due to ODBC drivers. I forgot to ask about your own drivers. What are you using?
I'd recommend the use of OLEDB drivers whenever possible
I wasn't able to reply to this. Sorry ruirib. Anyway, we've been talking about it in the other thread.
quote:
A while ago I helped someone with a forum that was taking around 16 secs to generate default.asp and 23 to generate active topics (with SQL server). Switching to an OLEDB driver brought those times down to less than a sec for default.asp and 1.6 secs to active topics! Can you believe the difference?!
Wow! that's really great!
Could it be that the OLEDB drivers are optimized for SQL Server and other db platforms that even using OLEDB still won't solve problems in Access MDBs?
My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 April 2002 : 04:50:20
|
quote:
Could it be that the OLEDB drivers are optimized for SQL Server and other db platforms that even using OLEDB still won't solve problems in Access MDBs?
Chiz,
I really can't tell. What I can tell is that when you use ODBC you still use OLEDB also (in that case OLEDB for ODBC), which explains why OLEDB is usually faster than ODBC, since you are removing a extra layer in DB access.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
| |
Topic |
|
Topic Locked
