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