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';
Code: Select all
FUniConnection.Server := 'CLWSTSPR30\LOGO';
Regards
Christian