Problems with database connection using ASP Script

[KevinC]

I Get following error::

ADODB.Recordset error '800a0e7d'

The connection cannot be used to perform this operation. It is either
closed or invalid in this context.

/guestbook/guestbook.asp, line 7

I'm not really a ASP-programmer, so if anyone could it would much
appreciated..

My Code:

<%
dim Conn, StrConn

Set Conn = Server.CreateObject("ADODB.Connection")

StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\INETPUB\WWWROOT\VARIETY\www\futurispower play\guestbook\db\powerplay.mdb;"
&_
"User ID=;" &_
"Password=;"




'Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
' "Data Source=C:\INETPUB\WWWROOT\VARIETY\www\futurispower play\guestbook\db\powerplay.mdb;"
&_
' "User Id=;" &_
' "Password=;"
%>

Thanx in advance;

KC

[dany]

> ADODB.Recordset error '800a0e7d'

>
> The connection cannot be used to perform this operation. It is either
> closed or invalid in this context.
>

[url]http://www.aspfaq.com/show.asp?id=2285[/url]

d.