is anyone able to use fileDSN for ODBC connections in LC?
ahsoftware at sonic.net
Thu Oct 25 15:47:09 EDT 2018
On 10/24/2018 11:09 AM, Matthias Rebbe via use-livecode wrote:
> 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
ahsoftware at gmail.com
More information about the use-livecode