On 06/21/2013 04:14 PM, Marcos Douglas wrote:
> On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas <m...@delfire.net> 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
>
This should work. Can you connect with another client using the
instance? tsql?
I have encountered this problem with sql server when the SQL Server
Browser service is not started. The name is a bit confusing because it
is needed for clients to be able to contact with a named instance. If
this service is down, you can only connect with a port number. It
listens normally on port port 1434 and responds with the port number for
the instance.
Another option is to define the connection in freetds.conf. Something like
[myserver001]
host = server001
instance = instanceABC
tds version = 8.0
Don't specify a port when you specify an instance. They are mutually
exclusive.
Ludo
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
