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

Matthias Rebbe matthias_livecode_150811 at
Thu Oct 25 18:04:52 EDT 2018

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



Matthias Rebbe

free tools for Livecoders:

> Am 25.10.2018 um 21:47 schrieb Mark Wieder via use-livecode <use-livecode at>:
> 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
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the use-livecode mailing list