[unixODBC-support] fetch data from ODBC application, put it into MySQL... how do I start?

Nick Gorham nick at lurcher.org
Fri Dec 19 15:06:58 GMT 2008


Tomasz Chmielewski wrote:

> Nick Gorham schrieb:
>
>> Tomasz Chmielewski wrote:
>>
>>> Hi,
>>>
>>> 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.

-- 
Nick


More information about the unixODBC-support mailing list