SDAC and Vista (OLEDB error 80070005)

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
illyap
Posts: 2
Joined: Fri 14 Mar 2008 14:58

SDAC and Vista (OLEDB error 80070005)

Post by illyap » Fri 14 Mar 2008 15:05

I'm using RAD studio 2007 and SDAC (4.35.0.14)
when I try ISAPI DLL on windows Vista and IIS7 I get error "OLE DB error occured. Code 80070005h" The ISAPI dll works fine on windows XP.

Can anybody help me?

Illya

illyap
Posts: 2
Joined: Fri 14 Mar 2008 14:58

Post by illyap » Fri 14 Mar 2008 16:22

The subsequent tests show that it is a provider problem.
The application works fine with options.provider=prSQL but it does not work with options.provider=prNativeClient or prAuto.
why doesn't Windows Vista allow to use NativeClient provider (SQLNCLI.1)? Should I install any additional libraries to make nativeClient work? Or is it Vista security issue? According to tests the SQLOLEDB provider slower than SQLNCLI, isn't it?

thanks

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 17 Mar 2008 09:45

There is no need to install anything else except SQL Server Native Client itself.
Do you have the same version of SQL Server Native Client on XP and Vista?
Try to determine, in what situation this problem occurs, and reproduce this problem in a usual Win32 application. You can send us this application at sdac*crlab*com.

Post Reply