Devart Forums

Posted: **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

Posted: **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.

Devart Forums

TUniConnection - SQL Server, direct with instance name

TUniConnection - SQL Server, direct with instance name

Re: TUniConnection - SQL Server, direct with instance name