ODBC Connections

[matthias_livecode_150811 at m-r-d.de]

i would say the description in the dictionary is wrong and therefore your script. ;)

I am using it as follows

put revopendatabase("ODBC",DsnName,Databasename,Username,Password)

My call to MSSQL is as follows

put revopendatabase("ODBC",DsnName,,Username,Password)

Username and Password is optional, if defined in the DSN.

I do not add the DB name, because the database name is already defined in the DSN, while username and passwors isn´t for security reaons..


-
Matthias Rebbe
Life Is Too Short For Boring Code


> Am 17.03.2020 um 23:22 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
> 
> that's put revOpenDatabase("odbc","192.168.1.207","formsgen") into tDBID;put tDBID
> 
> 
>> On Mar 17, 2020, at 15:20 , Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> put:
>> 
>> revOpenDatabase("odbc","192.168.1.207","formsgen") into tDBID;put tDBID
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode