Re: Working with databases without ODBC [message #32431] |
Wed, 09 October 2002 04:01 |
Randall Skelton
Messages: 169 Registered: October 2000
|
Senior Member |
|
|
Hi Evgeny,
> Has anyone ever worked in IDL with databases without using ODBC ?
Yes.
> The database I'm interested in is MySQL.
You really didn't provide enough information in your post. What operating
system(s) are you trying to use? If you don't want to use ODBC, then what
interface to MySQL would you prefer to use? Are you simply looking for an
alternative to the IDL dataminer? How much time are you willing to
invest? How familiar are you with the MySQL C-API (http://www.mysql.com/doc/en/C.html)?
I interface directly with remote and/or local PostgreSQL databases from
unix-based machines using the standard C-library interface to PostgreSQL
(libpq). I am sure MySQL presents a similar interface so if you are
fluent in C you can write wrapper routines for the MySQL C-interface and
package these as an IDL DLM. See Ronn Kling's 'IDL and C' book for and
explanation of how to write a DLM. Alternatively, you could write
C wrappers for any of the other standard database interfaces (ODBC, JDBC,
etc...) and make an IDL DLM... this is effectively what the IDL dataminer
does.
Cheers,
Randall
|
|
|