Community

Could not export to ODBC Compatible database

Avatar
Written by Sara
  • 2

Hi,

When we do export to an ODBC Compatible database, we get an error as :DBNETLIB Connection error. SSL Security error,

We are using FC12 R3 version. It is working fine in the old version FC12 R1 with same settings.

What can be the reason? Do anyone came across this?

 

 

Please see above screenshots.

Appreciate help.

Thanks,

Sara

 

 

 

Was this article helpful?

0 out of 0 found this helpful

Comments

2 comments

Sort by Date Votes
  • Avatar
    Scott Chau

    You're using the wrong DB drivers.  Per the help file, 

    For SQL 2012 SP4, 2014 SP2, 2016 SP2, 2017 database:

    1.Provider - OLE DB Provider for ODBC Drivers;

    Note: Selecting "OLE DB Provider for SQL Server" may cause problems when working with certain data types and long fields.

    2.Driver - SQL Server.

    For Access 2003, 2007, 2010 database:

    1.Provider - OLE DB Provider for ODBC Drivers;

    2.Driver - Microsoft Access Driver (Driver do Microsoft Access or Microsoft Access-Treiber).

    Note: To connect the 64-bit version of FlexiCapture to the Access database, you will need to install the 64-bit version of the Access Database Engine x64 driver.

    For Oracle 10g, 11g, 12c database:

    1.Provider - Oracle Provider for OLE DB;

    2.Selecting the driver is not required.
    For details see Exporting to an Oracle database.

    The provider and the driver must be available on the computer where export is performed.

     

    Basically look for the driver that mention ODBC
    0
  • Avatar
    Sara

    Thanks Scott.I downloaded the driver and seems its working.

    Sara

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post