| Re: IDL Dataminer and MySQL problem [message #49872 is a reply to message #49823] |
Sat, 19 August 2006 13:58   |
Marshall Perrin
Messages: 44 Registered: December 2005
|
Member |
|
|
codepod@gmail.com <codepod@gmail.com> wrote:
> I suspect the issue is the ODBC technology IDL uses. If I remember
> correctly, the ODBC supplier ITT uses for the dataminer module only
> allows the use of its drivers on UNIX/Linux platforms. On Windows you
> can use any vendor's drivers.
>
> Unfortunately, MySQL support for Linux isn't provided currently by IDL.
> Some people have been successful using JDBC via the Java Export Bridge,
> but at this point Dataminer on Linux isn't going to provide a solution
> for MySQL.
>
> The selection of this vendor and its policies are historical. When the
> dataminer was developed 11 years ago, ODBC only existed natively on
> Windows and a 3rd party was required to support ODBC on different
> platforms. Today, ODBC system support is native on Windows, Mac and
> Linux, but for now IDL is still using the vendor supplied system.
Depending on how flexible your code is, I may have a solution for you.
There's a series of pure IDL routines that access a MySQL database on
Mac OS by opening a pipe to the command line MySQL application and
passing text back and forth, from the Buie IDL library by Mark Buie et
al. I've been using it for some time now with great success on Mac OS,
and it should work just as well on Linux.
The interface isn't quite as polished as the Dataminer, but it works
cross-platform and the price is right. :-)
http://www.lowell.edu/users/buie/idl/idl.html
- Marshall
|
|
|
|