Well, at least I think the problem is in an xproc. I have a stored procedure that uses 3 xprocs (sp_OACreate, sp_OAMethod and sp_OADestroy). And those xprocs use some DLLs to create Serial numbers given keygen data. On my production server, everything works fine, unfortunately I did not build the machine and anybody that might have had a hand with it is long gone and when I backup and restore to a test db, the SN creation schema does not work, giving me the following error:
And I have exhausted my thoughts on solving this dilemma, so I come to you tremendous folks to see if you can help me with some insight or direction to figure out where this problem might be coming in. Oh, and the DLLs that the xprocs call are not ones that need to be registered, they just need to be in the path, but I am unclear WHERE that would be since it is a sproc calling an xproc calling a DLL. I currently have the DLLS in c:\windows\system32.
Thanks,
Willie
Code:
OLE Automation Error Information
HRESULT: 0x800401F3
Source: ODSOLE Extended Procedure
Description: Invalid class string
error! 1
Stored Procedure: onyx.dbo.sp_Generate_Random_AlphaNumeric_SerialNumbers
Return Code = 0And I have exhausted my thoughts on solving this dilemma, so I come to you tremendous folks to see if you can help me with some insight or direction to figure out where this problem might be coming in. Oh, and the DLLs that the xprocs call are not ones that need to be registered, they just need to be in the path, but I am unclear WHERE that would be since it is a sproc calling an xproc calling a DLL. I currently have the DLLS in c:\windows\system32.
Thanks,
Willie