Access 2010 with Classic ASP connection failed

[ramjee]

I am trying to connect Access 2010 with Classic ASP. I am getting following error. I have already installed MS Access driver. Here is my code

' 2010 ACCDB
strConn="Provider=Microsoft.Jet.OLEDB.12.0;Data Source=c:\inetpub\wwwroot\msaccess2010.accdb;Persi st Security Info=False;"
'Create the object
Set objConn = server.CreateObject("ADODB.Connection")
'Open the connection to the database
objConn.ConnectionString = strConn
objConn.Open
It is showing error


ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/Updates/classicASP.asp, line 112

[pbaldy]

An accdb would use Ace, not Jet:

https://www.connectionstrings.com