Norbert: your answer was very clear. I have no doubt know it. I really appreciate your explanation.
Thanks a lot. Mariano On Wed, May 27, 2009 at 6:51 AM, OpenDBX devel list < libopendbx-devel@lists.sourceforge.net> wrote: > > > With that driver I can access to ALL of the databases (mysql, postgresql, > > etc) ? But I also have a odbc driver per backend. For example, MySQL has > > its own ODBC library. PostgreSQL has another. So, which is the > difference? > > Which one should I use ? > > The ODBC concept is similar to the concept of OpenDBX: You have the library > providing the interface (odbc32.dll and libopendbx-1.dll) and backends for > the > specific databases. Using OpenDBX you need e.g. libopendbx-1.dll and > libmysqlbackend-1.dll to access a MySQL database through the OpenDBX > interface. If you are coding against the ODBC interface directly, you need > e.g. the odbc32.dll and the myodbc.dll to access the same MySQL database. > > The OpenDBX odbc backend is a bridge for accessing databases that are not > directly supported by OpenDBX yet. Therefore, the following chain of > libraries > is used: > > libopendbx-1.dll -> libodbcbackend-1.dll -> odbc32.dll -> myodbc.dll -> > mysql.dll > > If the database is supported natively by OpenDBX, the chain of libraries is > shorter and the performance higher: > > libopendbx-1.dll -> libmysqlbackend-1.dll -> mysql.dll > > To summarize: > If you want to use the odbc backend for connecting to a database, you need > the > common odbc32.dll as well as the database specific ODBC driver (e.g. > myodbc.dll). > > > Suppose I should use the backend in particular library. For example the > > postgresql ODBC library. So, when I compile openDBX with ODBC I do > > something like this: > > > > CPPFLAGS="-IC:/postgres/include" LDFLAGS="-LC:/postgres/lib" ./configure > > --disable-utils --disable > > -nls --with-backends="odbc" > > > > But if I do this, and then I want to use ANOTHER database trought ODBC, > > suppose MySQL, I should recompile openDBX. > > No, you don't need the PostgreSQL includes and libraries when compiling the > odbc backend for OpenDBX, only the ODBC includes and libraries. Which > driver > (e.g. myodbc.dll) ODBC uses afterwards can be configured later on in the > ODBC > configuration. It will be dynamically loaded just like the backends of > OpenDBX. > > > Norbert > -- > OpenPGP public key > http://www.linuxnetworks.de/norbert.pubkey.asc > > > > > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. > Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp as they present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > _______________________________________________ > libopendbx-devel mailing list > libopendbx-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/libopendbx-devel > http://www.linuxnetworks.de/doc/index.php/OpenDBX > >
------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp as they present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
