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

[Marcos Douglas]

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:
>> On 06/21/2013 08:01 PM, Marcos Douglas wrote:
>>
>>> Worked but I have another problem:
>>> To connect in DB of my client I need to pass the Application Name parameter.
>>> I tried to use Params property but didn't worked so, I changed the mssqlconn:
>>>
>>>   dbsetlname(FDBLogin, PChar('MyApp'), DBSETAPP);
>>>
>>> But didn't worked... Can you help me?
>>
>>
>> Params won't work. There are only a few keywords supported by sqldb.
>>
>> dbsetlname(FDBLogin, PChar('MyApp'), DBSETAPP); should work. Did you put
>> it before the call to dbopen?
>>
>> 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.

Marcos Douglas