Have you heard of anyone having problems instantiating dlls coded in VB
via SP_OACreate inside SQL 7.
My compents were able to run on 6.5 which used the ODSOLE32.DLL. Now
7.0 uses the ODSOLE70.DLL. I can run my custom components on the same
server as 7.0 but only through a VB Automation Controller and Active X
Sript in a DTS Package. However, SP_OACreate will not instantiate my
custom com objects. I can instantiate DTS and DMO without a problem via
SP_OACreate on SQL 7. I am set up as System Administrator.
When I try to instiate the custom com objects I get the following
OLE Automation Error Information
Source: ODSOLE Extended Procedure
Description: Class not registered
How can the class not be registered if i can run my com object(s)
through VB and DTS Active X sripting on the same server?
Sent via Deja.com http://www.deja.com/
Before you buy.