Menu

Search

GlobalSCAPE Knowledge Base


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


kmarsh
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!


Also In This Category


On a scale of 1-5, please rate the helpfulness of this article


Not Helpful
Very Helpful
Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Comments require login or registration.

Details
Last Modified: Last Week
Last Modified By: kmarsh
Type: HOWTO
Article not rated yet.
Article has been viewed 165 times.
Options
Find Similar