[Gambas-user] odbc dsn-less support or "connection strings" and documentation status?

[ML]

Piccoro,

Using ODBC via ConnectionString needs only the Connection.Type (so that
gambas knows it should use the ODBC component) and Connection.Host (for
the connection data) properties correctly set.

The component will, first and foremost, scan the .Host property looking
for semicolons (";"). If it finds at least one, it will assume the
property holds a ConnStr.
If there are no semicolons, it will connect as it always did, with a
DSN. Otherwise, it will use the ConnStr in .Host to call ODBC's
SQLDriverConnect() function.
But when the component calls that ODBC function, no other (gambas)
component properties are used, and thus are ignored. It is assumed that
all necessary data to connect is present in the ConnStr.

If the component fails to connect when other (gambas) component
properties are set, it could be something I did no foresee. Please
elaborate and I'll try to see if I can fix it.

zxMarce

On 23/05/17 14:01, PICCORO McKAY Lenz wrote:
> well in my svn version of 3.9 are working.. but i dont know if are available in 3.9.0 officially
> also noted that code must configure only host and type, if any other are configured connection will fail
> Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
>
> 2017-05-23 12:55 GMT-04:00 PICCORO McKAY Lenz <mckaygerhard at ...626...>:
>> the odbc gambas connection supports DSN-less mode? i mean, all the settings into the gambas code, no need of ini files i remenber that this are, since Gambas 3.8.1, IIRC, gb.db.odbc was made to support the so-called "Connection Strings".
>> i can update the documentation but i wish to know if are available in gambas 3.9.0 at leas http://gambaswiki.org/wiki/doc/odbc for the missing image cache i can sustituye and upload newer or made a text only
>> Lenz McKAY Gerardo (PICCORO)
>> http://qgqlochekone.blogspot.com