Hello, I was wondering if there were any IIS7 guru's out there?
I am developing an exsiting website that is up and running that uses access databases. I developed it on XP and have upgraded my pc to vista64 and now windows 7. I downloaded the working site to wwwroot\testsite\ followed the tutorials on the microsoft website for setting up IIS7. I had the site viewing and accessing the data in the database, but something was not quite right so. i deleted the virtual directories and website in IIS7 and started again. Now of course!, when i try and sign on to the website locally localhost/testsite the index.asp page views nicely, but the page that should display after you sign on is comming up with the folowing error:
ADODB.Command error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/testsite/Helper_JS.asp, line 15
the start fo Helper_JS.asp is:
<!-- #include file="HelperGroupsRulesJS.asp" -->
<!-- #include file="Mail_JS.asp" -->
var WA_Auth_Separator = "|§|";
var UserAuthenticated = false;
var WA_Auth_loginSQL = "SELECT " + WA_Auth_Parameter.sessionColumns.join(',') + " FROM " + WA_Auth_Parameter.tableName + " WHERE ";
WA_Auth_login_cmd = Server.CreateObject("ADODB.Command");
WA_Auth_login_cmd.ActiveConnection = WA_Auth_Parameter.connection;
the database connection string is:
var MM_conninaura_STRING = "provider=microsoft.Jet.OLEDB.4.0;data source=G:\\inetpub\\wwwroot\\testsite\\db2\\testDB.mdb;"
However i know the connection string works as you can connect to the databse in dreamweaver 8 and view the tables, but when you view the files in the browser and add records or search records you get the error. I have checked each jet engine dll files and they are all present and correct. I have also registered using regsvr32 most of the dll files. I am not sure why it worked and then stopped working! I am at a loss now, any ideas?