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
