is anyone able to use fileDSN for ODBC connections in LC?
Mark Wieder
ahsoftware at sonic.net
Tue Oct 30 13:05:14 EDT 2018
On 10/30/18 5:52 AM, Matthias Rebbe via use-livecode wrote:
> Hi all,
>
> it seems that my syntax was not correct. LC first confirmed that my syntax looked correct,
> but Panos found out that it didn´t.
>
> The correct syntax for fileDSN is
> revOpenDatabase("odbc","<PATH to the dsnFile;uid=<DB username>;pwd=<DB password>",,,)
> Example for Windows
> revOpenDatabase("odbc","filedsn=\Users\matthias\ODBC\test2.dsn;uid=matthias;pwd=test123",,,)
Panos also filed a dictionary fix for this syntax.
https://github.com/livecode/livecode/pull/6767/commits/6644e7ced22f8bb623d9f63a42ddf8a1c15d84b9
--
Mark Wieder
ahsoftware at gmail.com
More information about the use-livecode
mailing list