TUniConnection - SQL Server, direct with instance name

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
chkaufmann
Posts: 82
Joined: Sat 01 Jul 2006 11:42

TUniConnection - SQL Server, direct with instance name

Post by chkaufmann » Wed 02 Jun 2021 06:58

Hi,

normally I don't change the provider property and have no native client installed.

For backups I create a copy of my connection with:

Code: Select all

    FUniConnection.DefaultTransaction.IsolationLevel := ilSnapshot;
    FUniConnection.DefaultTransaction.ReadOnly       := True;
    FUniConnection.SpecificOptions.Values['Provider']:= 'prDirect';
This works fine except for one customer, who defines a specific instance:

Code: Select all

    FUniConnection.Server   := 'CLWSTSPR30\LOGO';
I cannot test this on my local installation, so my question: Is it possible, that using this syntax for the Server property does not work in direct mode for SQL Server?

Regards
Christian

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: TUniConnection - SQL Server, direct with instance name

Post by Stellar » Tue 29 Jun 2021 14:14

The Direct mode doesn't support this syntax. What error message are you getting?
In order for us to be able to give a more concrete answer, please specify the exact error message.

Post Reply