Unanswered: Connecting using Frontpage connection string
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)
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 objconn: objconn=Application("database1_ConnectionString")