Windows 7 Forums


Windows 7: IIS7, ASP and access db's

05 Mar 2009   #1

Windows 7
 
 
IIS7, ASP and access db's

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" -->
<% // ASP JavaScript
var WA_Auth_Separator = "|§|";
function WA_AuthenticateUser(WA_Auth_Parameter){
var UserAuthenticated = false;

var WA_Auth_loginSQL = "SELECT " + WA_Auth_Parameter.sessionColumns.join(',') + " FROM " + WA_Auth_Parameter.tableName + " WHERE ";
var WA_Auth_login_cmd;
WA_Auth_login_cmd = Server.CreateObject("ADODB.Command");
WA_Auth_login_cmd.ActiveConnection = WA_Auth_Parameter.connection;

the database connection string is:

<%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
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?

My System SpecsSystem Spec

Reply

 IIS7, ASP and access db's problems?



Thread Tools



Similar help and support threads for: IIS7, ASP and access db's
Thread Forum
Host a Website - IIS7.5 Tutorials
How to Setup a web site with iis7 Network & Sharing
IIS7 404.0 Error on Facebook Browsers & Mail
phpBB + MySQL + IIS7?? Network & Sharing
IIS7 Failing BSOD Help and Support


All times are GMT -5. The time now is 05:54 AM.



Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd