Using a DSN-Less Connection with ODBC Authentication

You can create a Site with a DSN-less connection to your authentication database. If you have several simultaneous database connections, a DSN-less connection may be slightly faster than a DSN connection.

To create a site with a DSN-less connection

1. In Secure FTP Server Administrator, connect to the server, then click the Server tab.

2. On the main menu, click Configuration, then click Create New Site.

3. Give the site a name, choose the IP address and Port.

4. In the Authentication method list, choose ODBC Authentication.

5. Click Advanced. The Authentication Provider Options appear.

6. Provide the connection string, then click OK.
   You must know the correct driver to use with your database. Create a connection string using the examples below. The connection string includes the name of the driver you need for your database, the location of your database, the name of your database, and, if necessary, a user name and password to access the database.

7. Click Next to continue with your Site creation.

For local databases the connection string must include:

• Provider [Provider=]

• Driver [DRIVER=]

• Database path and name, including the file extension [Dbq=]

• Username [Uid] and Password [Pwd] are required only if the database is password protected

For remote databases your connection string must include:

• Driver [DRIVER=]

• Server [SERVER]

• Database [DATABASE]

• Username [UID]

• Password [PWD]

If you are pointing to an Access 2000 database on the local machine named Example that was in the xyz sub-folder of your c drive the connection string is:

Provider=MSDASQL;Driver={Microsoft Access Driver(*.mdb)}Dbq=c:/xyz/Example.mdb;Uid=;Pwd=;

If you have a remote MYSQL database named Example  your connection string is:

Provider=MSDASQL;DRIVER={MySQL ODBC 3.51 Driver};SERVER=10.10.10.1;DATABASE=Example;UID=myusername;PWD=mypassword;