I'm trying to connect to an Access database and retrieve data. I'm getting the folloring error message:

ADODB.Recordset error '800a0e7d'

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

/legco/script/common.inc, line 52

The code used is as follows:
sRSSource will input a SQL

Function GetRecordset(sRSSource)
    Dim objRSGetRecordset

    Set objRSGetRecordset = Server.CreateObject("ADODB.RecordSet")
'' objRSGetRecordset.Open sRSSource, cnn, adOpenStatic, adLockOptimistic
    objRSGetRecordset.Open sRSSource, cnn, adOpenStatic, adLockReadOnly

    Set GetRecordset = objRSGetRecordset

    'objRSGetRecordset.Close
    Set objRSGetRecordset = Nothing
End Function

Any help or suggestion is much appreciated!

thanks...

Raymond

solution here
http://p2p.wrox.com/topic.asp?TOPIC_ID=1858

surendran
(Anything is Possible)

There are two reasons for this error.

1- Sql query contain an invalid database column name.
2- System can not read from connection variable.

Do Following:
Check your sql query and if there is a complex query try checking it by temrorary replacing it with a simple one i.e "SELECT * FROM tblRecords"

If you still get the same problem then

Write following after Function GetRecordset(sRSSource) statement and execute the page again.
response.write(cnn)
response.end

If page does not display anything then check you connection variable i.e 'cnn'. You probably need to define 'cnn' variable before database connection string i.e 'dim cnn'