how to register an assembly that uses ADODB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DMurray - 19 Dec 2007 19:11 GMT

Hello,

I have an assembly that references a COM DLL that uses ADODB. It runs
properly when run from a regular .Net program, but I need it to run from SQL
Server 2005.
When I try to register the assembly it gets an error because it cannot find
adodb.dll. When I try to register adodb.dll in the Microsoft.Net folder, I
get an error telling me that adodb.dll was created using an older version of
.Net, and it has not been tested in the SQL Server version of the CLR.

Can I use an assembly that uses traditional ADO withing SQL Server 2005?

Thanks,
Dave

Reply to this Message

Brian Muth - 19 Dec 2007 22:00 GMT

> Hello,
>
[quoted text clipped - 7 lines]
>
> Can I use an assembly that uses traditional ADO withing SQL Server 2005?

adodb is unmanaged code. I'm not a SQL Server 2005 expert, but I believe that SQL Server 2005 will complain if you try to call a
.NET object that in turn calls unmanaged code.

We worked around this by changing our .NET object to an Enterprise Component. Because it runs in a COM+ environment in a separate
process, we have no problems calling the .NET object from SQL Server.

You may want to confirm this in one of the SQL Server discussion groups.

Brian

Reply to this Message

Phil Wilson - 21 Dec 2007 22:06 GMT

The answer might be no..
http://support.microsoft.com/kb/318559

Signature

Phil Wilson
[MVP Windows Installer]

> Hello,
>
[quoted text clipped - 14 lines]
> Thanks,
> Dave

Reply to this Message

how to register an assembly that uses ADODB

Free Magazines