ODBC User Database Configuration

How to get here

This page allows you to configure a host to use an external user database for authentication.

Before you can configure an external user database using this page, you must establish an ODBC system data source name through the Data Sources tool (found in the Windows Control Panel).

  • Plug-in name. This is the name of the user plug-in. This is provided as information only and cannot be edited.
  • Plug-in location. This is the location of the DLL file for the user plug-in. This is provided as information only and cannot be edited.
  • Plug-in description. This is a description of the plug-in that describes its function.This is provided as information only and cannot be edited.
  • ODBC User DLL. Enter the full path to where the file obdcuser.dll was installed on the server.
  • ODBC DSN. Enter the source name created in the ODBC Source Administration tool described above.
  • Table name. Enter the name of the database table that contains the correct fields. If you are using a Microsoft Access table with spaces in the name, you must enclose the table name in hard brackets; for example, [Table Name].
  • User ID and Password. If the database you are using requires authentication, enter a valid username and password.
    Note: If the table specified in Table name does not exist, the plug-in will create it. If the table exists, it must contain these fields: FULLNAME varchar(80)USERID varchar(80)PASSWORD varchar(30)
    Tip: You must grant the IUSR account (or the account which runs your web server) full control to the database file.If this is not done, you will not be able to modify users through the Web Admin.
    Note: If you are configuring an external database that uses Windows credentials for authentication, such as Microsoft SQL Server, you must enter the credentials in the host impersonation fields on the Host Details page even if the credentials are already specified in the DSN and on the User Database Configuration page.