Hi Dalton, yes it is. You can use SQL Connection strings for it. But in any case you´ll need to have ODBC drivers installed.
This here is an old script i used to query the installed Windows ODBC drivers and do the connection with Connection strings. It´s old and was registry check was used under Windows 32bit. But the Connectionstrings still should do with one exception. This does not work with new versions of LC on Mac. The latest Mac version which worked with SQL Connection strings was 6.7.11. Here´s the bug report from 2016 https://quality.livecode.com/show_bug.cgi?id=18151 <https://quality.livecode.com/show_bug.cgi?id=18151> And here´s the script -- connection strings Win/Mac with check which Windows SQL ODBC drivers are installed switch the platform case "MacOS" get revOpenDatabase("ODBC","Driver={Actual SQL Server};Server=192.168.1.250;Database=MyDatabaseName;UID=sa;PWD=MyDatabasePassword;",,,) break case "Win32" put listregistry("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\") into tOdbcDrivers switch case "SQL Server Native Client 11.0" is in tOdbcDrivers get revOpenDatabase("ODBC","DRIVER={SQL Server Native Client 11.0};SERVER=192.168.1.250;DATABASE=MyDatabaseName;UID=sa;PWD=MyDatabasePassword;Trusted_Connection=No",,,) break case "SQL Server Native Client 10.0" is in tOdbcDrivers get revOpenDatabase("ODBC","DRIVER={SQL Server Native Client 10.0};SERVER=192.168.1.250;DATABASE=MyDatabaseName;UID=sa;PWD=MyDatabasePassword;Trusted_Connection=No",,,) break case "SQL Server" is in tOdbcDrivers get revOpenDatabase("ODBC","DRIVER={SQL Server};SERVER=192.168.1.250;DATABASE=MyDatabaseName;UID=sa;PWD=MyDatabasePassword;Trusted_Connection=No",,,) break end switch break end switch Regards, Matthias Matthias Rebbe free tools for Livecoders: https://instamaker.dermattes.de <https://instamaker.dermattes.de/> https://winsignhelper.dermattes.de <https://winsignhelper.dermattes.de/> > Am 03.07.2019 um 16:42 schrieb Dalton Calford via use-livecode > <use-livecode@lists.runrev.com <mailto:use-livecode@lists.runrev.com>>: > > Is it possible to connect to a database without a predefined DSN using the > livecode database connector? > > best regards > > Dalton > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com <mailto: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 _______________________________________________ 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
