is anyone able to use fileDSN for ODBC connections in LC?

[Matthias Rebbe]

Thanks Mark,

isn´t the DBQ parameter used when you want to access a file based Database like Access .mdb files?

I tried it anyway, but added a &quote before tAccessDBFilename, as it seems that was missing in your example.
Still getting the buffer error

[Microsoft][ODBC Driver Manager] Ungültige Zeichenfolgen- oder Pufferlänge
In English something like this: Invalid string or buffer length


Regards,

Matthias







Matthias Rebbe

free tools for Livecoders:
https://instamaker.dermattes.de
https://winsignhelper.dermattes.de

> Am 25.10.2018 um 21:47 schrieb Mark Wieder via use-livecode <use-livecode at lists.runrev.com>:
> 
> On 10/24/2018 11:09 AM, Matthias Rebbe via use-livecode wrote:
>> Hi,
>> i am not able to use fileDSN for ODBC connections to a SQL server in LC Windows. Under Mac i did not test it already.
>> With fileDSN you define all the odbc settings/parameters in a file with the suffix .dsn.
>> When connecting using ODBC you can then use that dsn file. No need to setup an ODBC configuration.
>> Is anyone using it with success?
> 
> IIRC fileDSNs have always been a pain in Rev/LC.
> But here's a hint from David Simpson from 2013 that might help:
> 
> put "DBQ=" & tAccessDBFilename & ";" & quote into tAccessPathname
> 
> put revOpenDatabase("ODBC", tAccessPathname, , tDestDBUsername, tDestDBPassword) into tDestinationDBConnection
> 
> -- 
> Mark Wieder
> ahsoftware at gmail.com
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode