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","<PATH to the dsnFile;uid=<DB username>;pwd=<DB
password>",,,)
Example for Windows
revOpenDatabase("odbc","filedsn=\Users\matthias\ODBC\test2.dsn;uid=matthias;pwd=test123",,,)
@Panos Thanks again.
Matthias Rebbe
free tools for Livecoders:
https://instamaker.dermattes.de
https://winsignhelper.dermattes.de
> Am 27.10.2018 um 18:53 schrieb Matthias Rebbe via use-livecode
> <use-livecode@lists.runrev.com>:
>
> I´ve filed a bug now. #21658
> <https://quality.livecode.com/show_bug.cgi?id=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 schrieb Matthias Rebbe via use-livecode
>> <use-livecode@lists.runrev.com>:
>>
>> 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 schrieb Bob Sneidar via use-livecode
>>> <use-livecode@lists.runrev.com>:
>>>
>>> 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 a reply is helpful and click Accept the
>>> solution when you think you're good with it.
>>>
>>>
>>>
>>>> On Oct 25, 2018, at 15:04 , Matthias Rebbe via use-livecode
>>>> <use-livecode@lists.runrev.com> wrote:
>>>>
>>>> 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 "e before tAccessDBFilename, as it
>>>> seems that was missing in your example.
>>>> Still getting the buffer error
>>>>
>>>> [Microsoft][ODBC Driver Manager] Ungültige Zeichenfolgen- oder Pufferlänge
>>>> In English something like this: Invalid string or buffer length
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Matthias
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
