SQL Server NativClient

[formi]

Hi

you proposed me to set

Code: Select all

SpecificOptions.Values['OLEDBProvider'] := 'prNativeClient';

to use NativClient instead of OLE DB. I implemented this in the "OnBeforeConnection"-method of tUniConnection. Sometimes I get the error "OLE DB error occurred. Code 80004005h." No I'm not shure if it works really with NativClient. Is there a possibility to check this? (I have also different problems with Blob-Fields and hope this would be solved with NativeClient). Thanks, Peter

[azyk]

When SpecificOptions.Values['OLEDBProvider'] is set to prNativeClient, you can be sure that you are working with the SQL Native Client provider. If the provider is not installed, you will get a corresponding exception.
UniDAC works with the SQL Native Client provider via the OLE DB interface, therefore you will get an OLE DB error.