[fpc-pascal] Re: SQLdb: TMSSQLConnection: using Instance name in Host

[Marcos Douglas]

On Sat, Jun 22, 2013 at 4:35 AM, Ludo Brands <ludo.brands at free.fr> wrote:
> On 06/21/2013 09:12 PM, Marcos Douglas wrote:
>> On Fri, Jun 21, 2013 at 4:08 PM, Marcos Douglas <md at delfire.net> wrote:
>>> On Fri, Jun 21, 2013 at 3:59 PM, Ludo Brands <ludo.brands at free.fr> wrote:
>>>> Ah, just found out that DBSETAPP is wrongly defined for FreeTDS.
>>>> It should be 5 instead of 4 according to include/sybdb.h.
>>>> Try dbsetlname(FDBLogin, PChar('MyApp'), 5);
>>>
>>> Aff! I would post before you!  :)
>>>
>>> You're right I used DBSETID:
>>>   dbsetlname(FDBLogin, PChar('MyApp'), DBSETID);
>>>
>>> You think is better use 5 instead DBSETID? The source will change?
>>>
>>> Thank you very much!
>>
>> Ah, you want a patch? -- should check the Params if there is the
>> 'Application Name' parameter.
>>
>
> Can you confirm it works with dbsetlname(FDBLogin, PChar('MyApp'), 5) ?
> If that is the case I'll make a patch for dblib.pp and will add an
> application parameter to mssqlconn.

Yes, I confirm. The ApplicationName was shown in Profiler tool.

Marcos Douglas