Provider error '80004005'

[JonR]

Does anyone know if this is a common error?

The complete error message is:

Provider error '80004005'
Unspecified error
/Flashpoint/programsearch.asp, line 19

Line 19 refers to: conn.open connstr,"",""

Can someone please tell me what this means?

Thanks,

(I'm a web designer implementing an ASP script - but not experienced at all w/ ASP.)

 

[link9]

Have you tried taking out those two empty strings there?

Maybe that would clear it up.

Otherwise, post the contents of your connstr variable (and how you built it up)...

 

[JonR]

Thanks for the quick reply, Link9.

Here's the script:

<%
if Request(&quot;activitytype&quot <> &quot;&quot; then
activitytype = Request(&quot;activitytype&quot
Session(&quot;Lastacttype&quot = activitytype
else
if Session(&quot;Lastacttype&quot <> &quot;&quot; then
activitytype = Session(&quot;Lastacttype&quot
end if
end if
' open connect to the database
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot
fname = server.mappath(&quot;fp1.mdb&quot
connstr = &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & fname
conn.open connstr,&quot;&quot;,&quot;&quot;
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot

' get select list with all activities in the database
sql = &quot;SELECT a.ActivityName, at.ActivityTypeID, at.ActivityTypeDescription &quot; &_
&quot;FROM Activities AS a, ActivityType AS at &quot; &_
&quot;WHERE at.ActivityTypeDescription = '&quot; & activitytype & &quot;'&quot; &_
&quot;AND at.ActivityTypeID = a.ActivityTypeID &quot; &_
&quot;ORDER BY ActivityName;&quot;
rs.open sql, conn, 3, 3
%>

Any insight you'd be able to provide would be appreciated.

Thanks again.

 

[link9]

Try this on --

strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
strconn=strconn & server.mappath(fp1.mdb) & ";"

conn.connectionString = strConn
conn.open

The above would replace --

fname = server.mappath("fp1.mdb")
connstr = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & fname
conn.open connstr,"",""

The oledb way to connect to an access database is preferred over the way you have... Actually, a DSN is the best way, but sometimes that's not possible for whatever reason.

Hope it helps!
Paul Prewett

 

[JonR]

Thanks again for your help, Paul. I appreciate it. Unfortunately it's still not working properly. May be something on my end. I'll try again on Monday.

Jon

 

[link9]

looks like I capitalized the strConn there, where it should have been all lowercase...

oops...