Connecting an ASP project through AcuXDBC

0 Likes

This article describes how to use AcuXDBC to connect a string from an ASP project.

Problem:

Using AcuXDBC to connect a string from an ASP project sometimes generates the following error message: "Microsoft OLE DB Provider for ODBC Drivers error '80004005'[TOD][ODBC Driver]VISION: 'GENESIS_HOME' environment variable not found."

Resolution:

The key points to success in this process are the following:


  1. The installer sets the GENESIS_HOME variable in the USER environment, not the SYSTEM; you need to manually set GENESIS_HOME as a SYSTEM variable (copy it from the USER variable).
  2. Create a System DSN, using the AcuXDBC driver; name it “MY_DSN," and leave all options at their default settings, including configuration files set to “acuxdbc.cfg.”
  3. Create a virtual directory within IIS, leaving all defaults except "Execute Permissions:"; set this to "Scripts only".

    In that directory, copy your ASP page, which must include, among all other ASP information, the following line:

    adoCon.Open "DSN=MY_DSN".
  4. Reboot the server.
  5. Open a browser (on a different machine) and enter the URL for the ASP page.

Incident Number: 2284189

Old KB# 14472
Comment List
Related
Recommended