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

2013-06-22 Thread Marcos Douglas
On Sat, Jun 22, 2013 at 10:39 AM, Ludo Brands wrote: > On 06/22/2013 03:20 PM, Marcos Douglas wrote: >> On Sat, Jun 22, 2013 at 4:35 AM, Ludo Brands wrote: >>> 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 a

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

2013-06-22 Thread Michael Van Canneyt
On Sat, 22 Jun 2013, Ludo Brands wrote: On 06/22/2013 03:20 PM, Marcos Douglas wrote: On Sat, Jun 22, 2013 at 4:35 AM, Ludo Brands wrote: 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 pa

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

2013-06-22 Thread Ludo Brands
On 06/22/2013 03:20 PM, Marcos Douglas wrote: > On Sat, Jun 22, 2013 at 4:35 AM, Ludo Brands wrote: >> 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 co

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

2013-06-22 Thread Marcos Douglas
On Sat, Jun 22, 2013 at 4:35 AM, Ludo Brands wrote: > On 06/21/2013 09:12 PM, Marcos Douglas wrote: >> On Fri, Jun 21, 2013 at 4:08 PM, Marcos Douglas wrote: >>> On Fri, Jun 21, 2013 at 3:59 PM, Ludo Brands wrote: Ah, just found out that DBSETAPP is wrongly defined for FreeTDS. It shou

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

2013-06-22 Thread Ludo Brands
On 06/21/2013 09:12 PM, Marcos Douglas wrote: > On Fri, Jun 21, 2013 at 4:08 PM, Marcos Douglas wrote: >> On Fri, Jun 21, 2013 at 3:59 PM, Ludo Brands 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

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

2013-06-21 Thread Marcos Douglas
On Fri, Jun 21, 2013 at 4:08 PM, Marcos Douglas wrote: > On Fri, Jun 21, 2013 at 3:59 PM, Ludo Brands 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 u

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

2013-06-21 Thread Marcos Douglas
On Fri, Jun 21, 2013 at 3:59 PM, Ludo Brands 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 mssqlcon

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

2013-06-21 Thread Ludo Brands
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); >

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

2013-06-21 Thread Marcos Douglas
On Fri, Jun 21, 2013 at 2:25 PM, Ludo Brands wrote: > On 06/21/2013 04:14 PM, Marcos Douglas wrote: >> On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas wrote: >>> Hi, >>> >>> Is possible to use "instance name" in host connection like bellow? >>> server001\instanceABC >>> >>> I'm using FPC 2.6.2 >

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

2013-06-21 Thread Ludo Brands
On 06/21/2013 04:14 PM, Marcos Douglas wrote: > On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas wrote: >> Hi, >> >> Is possible to use "instance name" in host connection like bellow? >> server001\instanceABC >> >> I'm using FPC 2.6.2 >> >> Thanks, >> Marcos Douglas > > The error is: > Error 2000

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

2013-06-21 Thread Marcos Douglas
On Fri, Jun 21, 2013 at 11:16 AM, Michael Van Canneyt wrote: > > > On Fri, 21 Jun 2013, Marcos Douglas wrote: > >> On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas wrote: >>> >>> Hi, >>> >>> Is possible to use "instance name" in host connection like bellow? >>> server001\instanceABC >>> >>> I'm u

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

2013-06-21 Thread Michael Van Canneyt
On Fri, 21 Jun 2013, Marcos Douglas wrote: On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas wrote: Hi, Is possible to use "instance name" in host connection like bellow? server001\instanceABC I'm using FPC 2.6.2 Thanks, Marcos Douglas The error is: Error 20002 Adaptive Server connection

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

2013-06-21 Thread Marcos Douglas
On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas wrote: > Hi, > > Is possible to use "instance name" in host connection like bellow? > server001\instanceABC > > I'm using FPC 2.6.2 > > Thanks, > Marcos Douglas The error is: Error 20002 Adaptive Server connection failed I found some links, but I