How to Set ODBC Access to an Externally Accessible FTP Server

The ODBC option allows you to specify a database as a source of user information, which can be Oracle, SQL Server, Microsoft Access, or even a plain text file. You must set up a link between the ODBC data source and the database so that RemotelyAnywhere can access the database.

  1. Access the server preferences in Server Functions > FTP Configuration.
  2. Click the name of the server you want to edit.
  3. At the bottom of the page, click ODBC and change the settings.
    Option Description
    Data source name The name of the database.
    Login name The user's login name. This is a mandatory field.
    Password The user's password. This is a mandatory field.
    Connect timeout The timeout after which the ODBC database connection terminates.
    homedir The user's home directory, which can be an absolute path (such as z:\ftp\users\~john) or it can be relative to the server root (such as /users/~john). Users have full access to their home directory, but have neither read nor write permissions outside of it. This is a mandatory field.
    quota The quota field will not let the user store more data in his home directory and its subdirectories than the number of bytes specified here. This is an optional field.
    downstream Restricts download speed This is an optional field.
    upstream Restricts upload speed. This is an optional field.
    disabled When it is non-zero, the user is disabled and cannot log in. This is an optional field.
    maxconns Specifies the maximum simultaneous connections to this FTP server for a user. This is an optional field.
    maxconnsperip Specifies the maximum simultaneous connections per unique IP address for a user. This is an optional field.
    welcome Contains a custom welcome message for the user. This is an optional field.
  4. Click Apply.

When you have your database and ODBC data source ready, we advise you to test it by querying it with a tool that supports ODBC queries, such as a spreadsheet program.

Note: You must have all user information available in one database table.