English

Error: The connection property set was missing a required property or the property value was unrecognized. General function failure

Error Message

When registering a MySQL database with ArcGIS Server, the following error is encountered:

"The connection property set was missing a required property or the property value was unrecognized.�General function failure".

Cause

The 32-bit and 64-bit MySQL OLE drivers are not installed on the ArcGIS server machine.

Solution or Workaround

Configure a data source name for the 32-bit and 64-bit OLE drivers on the ArcGIS server machine and register the database with ArcGIS for Server.

  1. Configure the 64-bit driver. The 64-bit executable file 'Odbcad32.exe' should be located in the following folder:

    %systemdrive%\Windows\System32

  2. Configure the 32-bit driver. The 32-bit executable file 'Odbcad32.exe' should be located in the following folder:

    %systemdrive%\Windows\SysWoW64

  3. Run the 'Create OLE database connection' tool in ArcCatalog.
  4. Enter the User Name and Password.
  5. Check the 'Allow saving password' box (to save the password).
  6. Register the database with ArcGIS for Server.