Thursday, March 9, 2017

Running classic asp on Windows 10 64 bit

In the latest version of Windows 10 Pro 64 bit, following has to be done:-

1.Go to Control Panel - Programs and Features - Turn Windows features on or off.

2.Select Iinternet Information services;World wide web services->and click on ASP & click OK
ok! worked

error message: error-800a0e7a-provider-cannot-be-found-it-may-not-be-properly-installed
for running classic asp with connect to access database  on 64 bit computer running windows 10, do these changes:

Check the site's Application Pool in IIS -->Application Pools->Default App pool (rt click)->  Advanced Settings :

1) Managed Pipeline Mode : Classic
2) Advanced / Enable 32-Bit Applications: True

USE SYSTEM DSN 32 BIT FOR ACCESS DATABASE
create 32 bit  system DSN, by going to  control panel -> administrative tools->ODBC Data sources 32 bit and creating the DSN.
That worked!

OLE DB connection in which code is written as
MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\mysite\cd-cat\database\cd_data.mdb;Persist Security Info=False"

requires the OLEDB provider to be installed

I got this error:-
Microsoft Office Access Database Engine error '80004005'
Could not find installable ISAM
This can be solved by following https://support.microsoft.com/en-in/help/209805/you-receive-a-could-not-find-installable-isam-error-message-or-some-fi

However, decided to use only DSN connection