Re: ODBC Connections

2020-03-18 Thread Bob Sneidar via use-livecode
Sorry I looked it up ODBC connections are intended to be local to the device they are configured on. I cannot access an ODBC connection on a different computer than I am trying to connect from. That's okay, I was thinking about making an ODBC agent that works using sockets. That would allow my t

Re: ODBC Connections

2020-03-18 Thread matthias rebbe via use-livecode
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 > : > > Hmmm your example works, so

Re: ODBC Connections

2020-03-18 Thread Bob Sneidar via use-livecode
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

Re: ODBC Connections

2020-03-17 Thread matthias rebbe via use-livecode
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 optio

Re: ODBC Connections

2020-03-17 Thread Bob Sneidar via use-livecode
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 > wrote: > > put: > > revOpenDatabase("odbc","192.168.1.207","formsgen") into tDBID;put tDBID ___ use-li