Re: Apartment model OLEDB Provider

qman (qman@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> I've written an apartment model OLEDB provider that works fine with SQL
> 2000 but doesn't work at all with SQL2005. I get the error Server: Msg
> 7302, Level 16, State 1 Could not create an instance of OLE DB provider
> ...
>
> Was there something that changed in SQL 2005 to prevent apartment model
> providers ?

I seem to recall having seen something about only in-process providers
being supported in SQL 2005.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: ado vs oledb
    ... Most mainstream SQL databases have "native" .NET providers using managed ... attempting to use a generic OLEDB provider--if you care about performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OdbcConnection - parameter problem
    ... With the OLE DB providers you need to build a matching Parameters ... Hitchhiker's Guide to Visual Studio and SQL Server ... protected DbProviderFactory provider; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.net hosting?
    ... manager access to the SQL databases - you must go through their interface. ... problem for writing in database on web. ... writing data back to database. ... The one I have seen are poor and also alot of providers ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ADSI
    ... providers for the integration with web application, ... "Joe Kaplan" wrote: ... used in SQL. ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SqlDbType error message
    ... You should remove reference to System.Data.Common.dll as its functionality ... SQL Mobile providers. ... Files\Microsoft Visual Studio ...
    (microsoft.public.dotnet.framework.compactframework)