Configuring an External User Database
When you configure an external user database using these directions, WS_FTP Server creates an ODBC database that holds tables configured with the correct fields. Those fields are identified in the Table Name section of this chapter. After the database is created and the ODBC system data source name is established in the ODBC Source Administration tool (Found in your Windows Control Panel), you can use that database to store your user authentication information and user properties. This information can still be managed through the WS_FTP Server Manager, including adding and deleting users.
- If you are creating a new host, follow the directions in "Setting Up FTP Hosts". While in the New Host wizard, select the External User Database option and click Configure. If you are setting the user database for an existing host, click the Set User DB button in the host properties pane after the host has been created.
- The External User Database dialog box appears.
- Enter the correct information in all of the boxes.
- External Database Implementation DLL. Enter the full path to the odbcuser.dll installed on your local server.
- ODBC System Data Source Name. Enter the source name created using the ODBC Source Administration tool described above.
- If the database requires you to log in using a username and password, place the following after the data source name. ;UID=<username>;PWD=<password>
- Example: If you were using the source name WS_FTP and the username and password of AUGUSTA and GEORGIA, the correct format of the ODBC System Data Source Name box would be:
- WS_FTP;UID=AUGUSTA;PWD=GEORGIA
- Table Name. Enter the name of the database table that was created with the correct standard fields.
- In order for WS_FTP server to use an external database, the information tables will be created with the following fields in the following format. The names are case sensitive.
| Name |
Type |
| USERID |
VARCHAR |
| PASSWORD |
VARCHAR |
| FULLNAME |
VARCHAR |
| FTPMAXSPACE |
INTEGER |
| FTPMAXFILES |
INTEGER |
| FTPFLAGS |
INTEGER |
- Click OK to continue creating the host.
