Search

GlobalSCAPE Knowledge Base

Updating a Secure FTP Server v.3.x ODBC database to work with EFT v6 or v7

Karla Marsh
EFT

THE INFORMATION IN THIS ARTICLE APPLIES TO:

  • Secure FTP Server v3.x
  • EFT v6 and later
  • EFT v7 and later

Refer to https://kb.globalscape.com/KnowledgebaseArticle10666.aspx for details of migrating a Secure FTP Server 3.3.10 configuration to a new server running EFT v6, which includes all Event Rules, user accounts, keys, and so on.

DISCUSSION

To update a Secure FTP Server 3 ODBC user database to work with EFT Server 6 and 7, you will need to add the SETTINGSLEVEL field to the FTPSERVER_USERS table, as described below.

  1. In the EFT administration interface, on the Site's General tab, locate the ODBC user database name.
  2. Open SQL Server Management Studio (or Oracle equivalent).
  3. Log into the SQL Server Management Studio using an account that is at least a DB Owner for the ODBC user account database (for Oracle, use schema owner).
  4. Do one of the following:
    • For a SQL, in SQL Server Management Studio, execute the following commands upgrade the database:
    • USE [ODBC database name]

      GO

      ALTER TABLE FTPSERVER_USERS

      ADD SETTINGSLEVEL VARCHAR(200) NULL

      GO

    • For Oracle, execute the following commands in the Oracle database console against the ODBC user database:
    • ALTER TABLE FTPSERVER_USERS

      ADD SETTINGSLEVEL VARCHAR2(200);

Details
Last Modified: 8 Years Ago
Last Modified By: kmarsh
Type: HOWTO
Rated 5 stars based on 2 votes.
Article has been viewed 29K times.
Options
Also In This Category
Tags