ODBC Connections

[matthias_livecode_150811 at m-r-d.de]

Could you please explain what you mean with "access an ODBC connection remotely"?
Do you want to use an ODBC connection string instead of a DSN?


-
Matthias Rebbe
Life Is Too Short For Boring Code

> Am 18.03.2020 um 21:41 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
> 
> Hmmm your example works, so yes the dictionary is wrong (again). It states revOpenDatabase("odbc", hostAddress, databaseName, [userName],[passWord],[cursorType]). 
> 
> "hostAddress" should actually be "dsnName". Also the Disctionary example seems to indicate the userName and passWord arguments are optional but they are not. I get the same error using your corrected example sans the user/pass. 
> 
> One more question if I may, can I access an ODBC connection remotely? If so, how would I specifiy which actual server I want to connect to? 
> 
> Bob S
> 
> 
>> On Mar 17, 2020, at 16:00 , matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> 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)
> 
> 
> _______________________________________________
> 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