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

[Mark Wieder]

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