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

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

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

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?

Thanks Mark, isn´t the DBQ parameter used when you want to access a file based Database like Access .mdb files? I tried it anyway, but added a before tAccessDBFilename, as it seems that was missing in your example. Still getting the buffer error [Microsoft][ODBC Driver Manager] Ungültige

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

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