[unixODBC-support] fetch data from ODBC application, put it into MySQL... how do I start?
nick at lurcher.org
Fri Dec 19 15:06:58 GMT 2008
Tomasz Chmielewski wrote:
> Nick Gorham schrieb:
>> Tomasz Chmielewski wrote:
>>> I have an application (including its own database) which is
>>> "ODBC-capable", running on a Linux machine.
>>> I would like to connect to this application from a Linux machine via
>>> ODBC, fetch all data, and place it into a MySQL database.
>>> I'm new to ODBC... could you point me to some documentation on
>>> setting up such a configuration?
>> Well, you need to setup a ODBC data source for the application,
> So, where can I read about setting it up?
>> then either write some simple code to transfer the data over, or look
>> at using a DTS type app to do it for you.
> grep -ri DTS unixODBC-2.2.14/doc/*
> As I said, I'm new to ODBC, any friendly documentation will be
> appreciated ;)
OK, there are some same coding pages on the site, but first its a case
of getting your "ODBC-capable" database to have a working ODBC
connection. To do that you will need to find a ODBC driver for the
application, or its backend database. Without knowing what that is I
can't go any further yet.
More information about the unixODBC-support