dbTalk Databases Forums  

Access .NET Library from DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Access .NET Library from DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Des Norton
 
Posts: n/a

Default Access .NET Library from DTS - 10-20-2005 , 07:32 AM






Hi NG

We have a VB6 ActiveX DLL which we use from an ActiveX script in a DLL
Set Obj = CreateObject("Library.Class")
Obj.DoSomething
Set Obj = Nothing


We now have a new .Net Library that we would like to access in the same
manner.

Unfortunately we get an "ActiveX component can't create object" Error.


Any ideas would be greatly appreciated.

Regards

Des Norton



Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Access .NET Library from DTS - 10-20-2005 , 08:02 AM






Have you created a COM Callable Wrapper (CCW)?

COM Callable Wrapper
(http://msdn.microsoft.com/library/de...rdwrappers.asp)

How to call a Visual Basic .NET assembly from Visual Basic 6.0 and how to
call a call Visual Basic COM component from Visual Basic .NET
(http://support.microsoft.com/default...en-us;817248#6)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com



"Des Norton" <desREMOVEnortonUPPERCASE (AT) gmail (DOT) com> wrote

Quote:
Hi NG

We have a VB6 ActiveX DLL which we use from an ActiveX script in a DLL
Set Obj = CreateObject("Library.Class")
Obj.DoSomething
Set Obj = Nothing


We now have a new .Net Library that we would like to access in the same
manner.

Unfortunately we get an "ActiveX component can't create object" Error.


Any ideas would be greatly appreciated.

Regards

Des Norton





Reply With Quote
  #3  
Old   
Des Norton
 
Posts: n/a

Default Re: Access .NET Library from DTS - 10-20-2005 , 09:41 AM



Thanks Darren


We did not create a CCW.


Regards
Des Norton

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:
Have you created a COM Callable Wrapper (CCW)?

COM Callable Wrapper
(http://msdn.microsoft.com/library/de...rdwrappers.asp)

How to call a Visual Basic .NET assembly from Visual Basic 6.0 and how to
call a call Visual Basic COM component from Visual Basic .NET
(http://support.microsoft.com/default...en-us;817248#6)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com



"Des Norton" <desREMOVEnortonUPPERCASE (AT) gmail (DOT) com> wrote in message
news:e2RwHLX1FHA.1256 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi NG

We have a VB6 ActiveX DLL which we use from an ActiveX script in a DLL
Set Obj = CreateObject("Library.Class")
Obj.DoSomething
Set Obj = Nothing


We now have a new .Net Library that we would like to access in the same
manner.

Unfortunately we get an "ActiveX component can't create object" Error.


Any ideas would be greatly appreciated.

Regards

Des Norton







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.