Re: ODBC Connections

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 all

Re: ODBC Connections

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

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

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

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

ODBC Connections

Hi all. I'm struggling to connect to an ODBC System DSN. I use the command put: revOpenDatabase("odbc","192.168.1.207","formsgen") into tDBID;put tDBID tDBID is empty. I know the DSN works because the test button if the ODBC Data Source Administrator returns OK! What am I missing? Bob S

Re: is anyone able to use fileDSN for ODBC connections in LC?

On 10/30/18 5:52 AM, Matthias Rebbe via use-livecode wrote: Hi all, it seems that my syntax was not correct. LC first confirmed that my syntax looked correct, but Panos found out that it didn´t. The correct syntax for fileDSN is revOpenDatabase("odbc",";pwd=",,,) Example for Windows revOpenDat

Re: is anyone able to use fileDSN for ODBC connections in LC?

Hi all, it seems that my syntax was not correct. LC first confirmed that my syntax looked correct, but Panos found out that it didn´t. The correct syntax for fileDSN is revOpenDatabase("odbc",";pwd=",,,) Example for Windows revOpenDatabase("odbc","filedsn=\Users\matthias\ODBC\test2.dsn;uid=matth

Re: is anyone able to use fileDSN for ODBC connections in LC?

I´ve filed a bug now. #21658 If anyone has additional comments please add them to the bug. Regards, Matthias Rebbe free tools for Livecoders: https://instamaker.dermattes.de https://winsignhelper.dermattes.de > Am 26.10.2018 um 00:33 schri

Re: is anyone able to use fileDSN for ODBC connections in LC?

As the same ODBC driver (Windows 10 SQL Server) works w/o a problem when using a user or system DSN connection, the driver should not be the problem. Regards, Matthias Rebbe free tools for Livecoders: https://instamaker.dermattes.de https://winsignhelper.dermattes.de > Am 26.10.2018 um 00:21

Re: is anyone able to use fileDSN for ODBC connections in LC?

Re: [resolved] Microsoft - Driver Manager ODBC - Invalid string or buffer length Hi, Are you using 64 bit sql server 2014? Please take a look at an article about:http://stackoverflow.com/questions/26745417/invalid-string-or-buffer-length. Best regards Sabrina -- Don't forget to give kudos when

Re: is anyone able to use fileDSN for ODBC connections in LC?

livecode > : > > On 10/24/2018 11:09 AM, Matthias Rebbe via use-livecode wrote: >> Hi, >> i am not able to use fileDSN for ODBC connections to a SQL server in LC >> Windows. Under Mac i did not test it already. >> With fileDSN you define all the odbc settings/para

Re: is anyone able to use fileDSN for ODBC connections in LC?

That cannot be right. The result would be something like, DBQ=myFileName;" Eh? Bob S > On Oct 25, 2018, at 12:47 , Mark Wieder via use-livecode > wrote: > > put "DBQ=" & tAccessDBFilename & ";" & quote into tAccessPathname ___ use-livecode mail

Re: is anyone able to use fileDSN for ODBC connections in LC?

On 10/24/2018 11:09 AM, Matthias Rebbe via use-livecode wrote: Hi, i am not able to use fileDSN for ODBC connections to a SQL server in LC Windows. Under Mac i did not test it already. With fileDSN you define all the odbc settings/parameters in a file with the suffix .dsn. When connecting

is anyone able to use fileDSN for ODBC connections in LC?

Hi, i am not able to use fileDSN for ODBC connections to a SQL server in LC Windows. Under Mac i did not test it already. With fileDSN you define all the odbc settings/parameters in a file with the suffix .dsn. When connecting using ODBC you can then use that dsn file. No need to setup an ODBC