Hi guys! Access WWG forums work perfect, tried to install trial version of SQL server on my pc, it made it go funny (my os is a bit old), removed it, now i cant create an ADODB connection to an access database, is there any way to fix this without installing PWS over?
ASP scripts come up with this error
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
With this code (red is error line)
Set adoCon = Server.CreateObject("ADODB.Connection")
strDbPathAndName = Server.MapPath("data/wwForum.mdb")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName
adoCon.connectionstring = strCon
Set rsCommon = Server.CreateObject("ADODB.Recordset")
adoCon.Open
Thanks for any help!