How to establish connection in VB Script

[vaahini]

when creating a connection object in VBScript using following code
set conn=Server.Cre ateObject("ADOD B.Connection")
conn.provider=" Microsoft.Jet.O LEDB.4.0;"
conn.open server.mappath( "/db/database.mdb")
sql="select fname,lname from tblGuestBook"
set rs=Conn.Execute (sql)
I get error ActiveX component can't create object. should i add some reference if so where should i add as i am working in visual interdev... please reply me as soon as possible...

[KAMALAKAR]

you have to create recordset like

set rs = server.createob ject("adodb.rec ordset") and try it
I hope this will solve your problem