Hi all,

I'm trying to connect to a access DB using the Access connection String. I have followed a tutorial and can connect to the database. The thing is when i set the recordset it and try and display data it bring up a error.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\test2\fpdb\database1.mdb (this is me testing connection)

---error part---
Microsoft VBScript runtime error '800a01a8'

Object required: 'Provider=Microsoft.J'

/test2/new2.asp, line 18


I know i have connected to the DB as i can response.write the connection and it displays the connection. I just ju st cant show resluts.
Can anyone help?

here is my code:

Dim rs
Dim objconn: objconn=Application("database1_ConnectionString")

response.write(objconn)


set rs = objconn.execute("SELECT * FROM RESULTS")

dim name

name = rs("Name")

response.write(Name)
/code

THanks in advance Sanson