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

ML d4t4full at ...626...
Tue May 23 20:04:37 CEST 2017


It should; as far as I know nobody sent any further patches to the ODBC
component other than me...

On 23/05/17 14:59, PICCORO McKAY Lenz wrote:
> hi Ml/zxMarce this feature are available officially in the normal 3.9.X
> release and up? i use the svn and i dont know if !
>
> Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
>
> 2017-05-23 13:56 GMT-04:00 ML <d4t4full at ...626...>:
>
>> 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
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user





More information about the User mailing list