General ODBC DB Connection

Highlighted
One Star

General ODBC DB Connection

I wish to use the General ODBC DB connection but this does not appear in the drop down list - so I need to install/configure some additional software. I am using TOS DI 6.0 under windows 8.1
One Star

Re: General ODBC DB Connection

Odbc is deprecated in 6.0 since java 8 not support it any more;
You can enable it by importing an odbc connection exported from 5.6 or earlier version.
Highlighted
One Star

Re: General ODBC DB Connection

Ok, I have installed TOS DI 5.6 and have created appropriate ODBC entries for Visual FoxPro tables (see snip1) but when I attempt to create a DB connection to FoxPro tables I get the error message "Connection Failure - Change database settings" (see snip2)
Please can you advise on my mistakes.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog