Sunday, October 28, 2018

Using ODBC with classic ASP in IIS

I have a website developed in classic ASP with ADO. Basically, the IIS in Windows 10 (64 Bits) still supports running ASP. You will able to run ASP pages after installing the IIS with ASP enabled.


Go to Control Panel > Program > Programs and Features > Turn Windows Features on or of > Internet Information Service > World Wide Web Services > ASP



It is now all set for ASP pages.

However, there is still one more thing to do for running a ASP page with ODBC connection. 

Working with 64-bit Systems

Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:
  1. On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
  2. In the Connections pane, click Application Pools.
  3. Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
  4. In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
  5. Click OK to close the Advanced Settings dialog.


It is all done.








Applying SMA10/20, SMA20/50 as trading signals

This is the comparison for results before and after applying SMA10/20 and SMA20/50 in the stock trader. Background Trading 3 stock ma...