Attempt to use provider from web server or other server fails

An attempt to use OLE DB Provider from the web server or from a process that runs as a distinct user fails. The typical error message that is displayed is ADO cannot find the provider.

Possible cause

OLE DB Provider is set up only for the current user.

Resolution

Perform the following steps in order:

  1. Verify that you can connect to the HCL Informix® data source from an application such as Microsoft™ Visual Basic 6 or Microsoft Query Demo.
  2. Make sure that INFORMIXDIR\bin is in the system path (as opposed to the user path).
  3. Run INFORMIXDIR\bin\regcopy.exe and reboot.

Also, make sure that the user has the necessary permissions to access the database, and verify that the data source has been specified correctly.