Connecting an ASP project through AcuXDBC

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