Lubos Kresta


Hi,

I'm working on an OLE DB provider. This provider is supposed to retrieve data from managed application running in background. The data retrieval is handled by C# component communicating with source application via remoting, the data are then exposed via component's COM interface. OLE DB provider itself instantiates the communication component.

Now, the problem: this worked ok in SQL server 2000, but it doesn't seem to work in SQL server express edition. Concretely, the communication component fails to get created (CoCreateInstance ends with 'class not registered') and SQL server logs this:

2007-08-24 14:48:49.42 spid51 Error: 6511, Severity: 16, State: 20.
2007-08-24 14:48:49.42 spid51 Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131022. You may fix the problem and try again later.

I've googled a bit and found out someone else getting this message, and he was told something like 'trying to load CLR in some cases is disabled in newer (>2000) versions of SQL server'.

Now, I have very little knowledge of SQL server, CLR integration etc., so I'm not sure whether this applies to my case as well, but I think so - that problematic COM object is C#-based.

I'd be glad for any hints, ideas how to solve this issue, I just need the OLE DB provider to be able to access that managed application.

Thanks,

L.



Re: An error when instantiating C#-based COM object in OLE DB provider linked to SQL server express

Mike Wachal - MSFT


Not finding much on this one, a couple suggestios worth checking at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1015696&SiteID=1.

Mike