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 "e 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@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 > ahsoftw...@gmail.com > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
