| Author |
 Topic  |
|
kolucoms6
Average Member
845 Posts |
 Posted - 24 March 2007 : 05:37:05
|
Everytime I download a copy of MS-Acces database as a backup, I get this error after downloading...
Provider error '80004005'
Unspecified error
/forum/inc_header.asp, line 111
|
Edited by - kolucoms6 on 24 March 2007 05:39:31 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 06:08:38
|
Somewhat strange part is sometime Its works and sometimes it doesnt...
Code from config.asp :
Session.LCID = 1033 '## Do Not Edit
Response.Buffer = true
Dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix, strFilterTablePrefix '## Do Not Edit
Dim counter, ConnErrorNumber, ConnErrorDesc, blnSetup '## Do Not Edit
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("abc.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/abc.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\abc.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("forum/abc.mdb") '## MS Access 97 using virtual path
strConnString = "DBQ=" & Server.MapPath("abc") & ";Driver={Microsoft Access Driver (*.mdb)}"
There has been a problem...
Your strDBType is not set, please edit your config.asp
to reflect your database type.
|
Edited by - kolucoms6 on 24 March 2007 06:21:11 |
 |
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 06:58:26
|
My connection string is
strConnString = "DBQ=" & Server.MapPath("abc.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}"
I also entered
my_Conn.Open strConnString
Response.write "my_Conn state is " & my_Conn.state
But cant see the state displayed.
Here is the URL :
http://www.ulcindia.com/forum |
Edited by - kolucoms6 on 24 March 2007 07:07:32 |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 07:09:56
|
Currently its :
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
|
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 07:15:31
|
Let me try this :
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("abc.mdb") '## MS Access 2000 using virtual path |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 07:17:11
|
Great...Its working...But to be very honest ,earlier below line was working perfectly..:
strConnString = "DBQ=" & Server.MapPath("abc.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}" |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 07:44:48
|
I am still keep on getting below error :(But NOT always)
Provider error '80004005'
Unspecified error
/forum/inc_header.asp, line 111 |
Edited by - kolucoms6 on 24 March 2007 09:39:13 |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 09:40:36
|
| My forum seems to very fluctuating and unreliable.. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 24 March 2007 : 10:25:11
|
| Just out of curiosity, have you done a compact and repair on the Access database? Also, it could be more of a server-related issue... since IS moved a few apps to a different server, we haven't had the problems with Access like we used to. (the extra gig of RAM probably helped too) |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 24 March 2007 : 11:15:44
|
No..I didnt do any compact and repair.
|
|
|
|
Topic |
|
Topic Locked
