Jump to content

Afdal

Members
  • Posts

    5
  • Joined

  • Last visited

Everything posted by Afdal

  1. I figured it out. I will post the solution here for others to benefit from. Problem: Access 2007 is 32 bit and Windows 10 is 64 bit (& IIS is also 64 bit). They have turned off 32 bit in IIS. That is why the above code didn't work. Solution: Enable 32-bit in [Application Pool]. Open InetMgr.exe Follow step 1 to 5 in attached snapshot, for all of the Application Pools (unless you know which one is it, then enable 32-bit for that one only).
  2. Can some one tell me which database/ ASP can work on my computer? I am willing to upgrade/ download. What is it that I am missing from my computer? Why the ASP is not compiling/ running?
  3. I have tried so many different versions. I am not sure which one is the right one.
  4. Yes, both ASP and ISAPI Extensions are installed. FYI: Access database is 2007, on Windows 10 Home (64bit). I also installed AccessDatabaseEngine.exe from Microsoft website. I assumed it would help run 32bit MS Access on 64bit system. I also changed the Debugging Property [Send Errors To Browser] to True in InetMgr. And, now the error message makes a little more sense. Error message is: ADODB.Connection error '800a0e7a' Provider cannot be found This is the 3 lines of code I am trying to running: <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "C:/inetpub/wwwroot/mysite/myAccessDB.accdb" %>
  5. Code from W2Schools works in 'Show Example' but not on my Windows 10 or Windows 7 computer. Ref: https://www.w3schools.com/asp/ado_connect.asp Simple ASP stuff works. Only when I make a call to connect to the database, I get the following error message: An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error. Please help.
×
×
  • Create New...