how to register an assembly that uses ADODB

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

"DMurray" <DMurray (AT) discussions (DOT) microsoft.com> wrote

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?

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

The answer might be no..
http://support.microsoft.com/kb/318559
--
Phil Wilson
[MVP Windows Installer]

"DMurray" <DMurray (AT) discussions (DOT) microsoft.com> wrote

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