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

[Ludo Brands]

On 06/21/2013 04:14 PM, Marcos Douglas wrote:
> On Fri, Jun 21, 2013 at 10:38 AM, Marcos Douglas <md at 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