Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Provider error '80004005' Unspecified error


Message #1 by "Wayne" <wbadcock@h...> on Tue, 8 Oct 2002 19:48:19
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

  Return to Index