Search

GlobalSCAPE Knowledge Base

Cannot complete EFT Insight installation; unable to connect to ODBC database

Karla Marsh
EFT Insight

THE INFORMATION IN THIS ARTICLE APPLIES TO:

  • EFT Insight, all versions

SYMPTOM

Cannot complete EFT Insight installation, because it is unable to connect to the ODBC database.

RESOLUTION

EFT Insight requires a connection to the EFT database to acquire data. If the database is not available, it will not complete installation. 

You can work around this issue in one of two ways:

  • In the Server > Logs tab, in the Authentication area, with SQL Server selected, provide the username and password to connect to the database.
  • In the Server > Logs tab, in the Authentication area, select Window authentication

When using an ODBC database in EFT, the ODBC string must be in both the Database host address field, and the uid and pwd fields in the connection string.

e.g.: DRIVER=SQL Server Native Client 11.0; DATABASE=EFTDB; SERVER=192.168.102.145\OURTESTSQL; uid=Bob123; pwd=Test123!

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