Trying a simple faq database in access and the ASP pages reading it come
up with second time of viewing or refresh:
Provider error '80004005'
Unspecified error
Have tried two different codes to connect to database
--Code 1---
Set conn = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp
& "DBQ=e:\wwwroot\itservices\database\database.mdb;uid=;pw=;"
conn.Open DSNtemp
--end---
---Code 2---
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=e:\wwwroot\itservices\database\database.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnect
---end---
Can not find much on the web about error. Have updated JET 4.0SP3 and MDAC
2.7
Just in case, here's my query string too...
Dim VAR_TopicID
VAR_TopicID = Request.QueryString("chapter")
if VAR_TopicID = "" Then
Response.Redirect "../../help_index.htm"
End If
strSQLQuery = "SELECT * FROM Help WHERE Topic = '" & VAR_TopicID & "'
ORDER BY Title ASC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strSQLQuery, conn, 3, 3
Don't know much in ASP, so any help with this error would be appreciated.
TA