ODBC Connections

[Bob Sneidar]

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)