Maybe a little more useful as a complete function:
function dbConnectODBCByString pServer, pDatabase, pUser, pPasswd
switch the platform
case "MacOS"
get revOpenDatabase("ODBC","Driver={Actual SQLServer};Server=" &
pServer & ";Database=pDataBase;UID=" & pUser & ";PWD= & pPasswd & ";",,,)
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
Client11.0};SERVER=" & pServer & ";DATABASE=pDataBase;UID=" & pUser & ";PWD=" &
pPasswd & ";Trusted_Connection=No",,,)
break
case "SQL Server Native Client 10.0" is in tOdbcDrivers
get revOpenDatabase("ODBC","DRIVER={SQL Server Native
Client10.0};SERVER=" & pServer & ";DATABASE=pDataBase;UID=" & pUser & ";PWD=" &
pPasswd & ";Trusted_Connection=No",,,)
break
case "SQL Server" is in tOdbcDrivers
get revOpenDatabase("ODBC","DRIVER={SQLServer};SERVER=" &
pServer & ";DATABASE=pDataBase;UID=" & pUser & ";PWD=" & pPasswd &
";Trusted_Connection=No",,,)
break
end switch
break
end switch
return it
end dbConnectODBCByString
Bob S
> On Jul 3, 2019, at 08:22 , Dalton Calford via use-livecode
> <use-livecode@lists.runrev.com> wrote:
>
> Wonderful! Thanks Matthias!
>
> I can ensure the ODBC drivers are in, that is not an issue. Most of my
> testing will be for linux anyways.
>
> Best regards
>
> Dalton
>
>
> On Wed, 3 Jul 2019 at 11:09, Matthias Rebbe via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> 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
> _______________________________________________
> 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
_______________________________________________
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
