[Gambas-user] Connection via ODBC

PICCORO McKAY Lenz mckaygerhard at gmail.com
Mon Oct 19 23:47:15 CEST 2020

hi guys.. ODBC components seems still have problems and seems is not
concerned here..

i worked so much under odbc not with "mysql"school one! i work with DB2,
Firebase, Sybase.. under gambas.. and found many problems.. already

in my contribution i made the property documentation:
to code you must use http://gambaswiki.org/wiki/howto/odbcdatabase

many queries does not work property and does not returns the right
resultset and you must find work around.. of course not all are culprit of
gambas.. ODBC unix layer are pretty basic so but other things are
incomplete or changed since gambas 3.9 .. in gambas 3.4 and 3.7 ODBC layer
works perfectly!

El lun., 19 de oct. de 2020 a la(s) 16:57, Gianluigi (bagonergi at gmail.com)

> Il giorno lun 19 ott 2020 alle ore 20:10 First Last <d4t4full at gmail.com>
> ha scritto:
>> Gianluigi et al,
>> With the usual *I need to connect to database XXX using ODBC* claim, I
>> think a couple of clarifications are needed.
>> 1- Important: The Gambas ODBC interface targets unixODBC, not iODBC
>> (actually I did not test against iODBC myself; it may or may not work).
>> 2- ODBC is not a database driver per-sé; instead, it is a *Driver
>> Manager*.
>> You do not connect to a *FooBar* database with ODBC, you connect to a
>> *FooBar* database with a *FooBar ODBC Driver*, managed by ODBC.
>> That is why all connection strings have at the very least a
>> *Driver={FooBar}* parameter; it tells ODBC which actual low-level,
>> ODBC-compliant driver to use.
>> In turn, the Gambas application uses the standardized database-interface
>> offered by ODBC to send/receive queries/data to/from the actual database.
>> ODBC is, then, some kind of "middle man" standing between the actual
>> low-level connectivity driver and your application, "filing the burrs"
>> between them.
>> The advantage is simple yet powerful: Your application can connect to a
>> DB2, MySQL, MSSQL or any other database that provides an ODBC-compliant
>> driver, and you do (almost-)nothing at the application level to issue
>> queries and get results back. You want to change DB2 for MySQL? Change the
>> connstring, and you're mostly done... Well, yes, subtle differences between
>> vendor database features may call for some kind of code adjusting, but it
>> is usually minimal... or that's at least the goal.
>> Regards,
>> zxMarce.
> Dear zxMarce,
> I renew my thanks for your willingness, all very useful informations...
> Regards
> Gianluigi
> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20201019/eef8e413/attachment-0001.htm>

More information about the User mailing list