Hi All,
Another strange and one-off problem. I have an class library (written c#) having code for loading DTS pkg (saved on HDD as structured file) (from SQL 2000) and then executing it with a parameter of source text file name.
It works fine on development PC.
My destination app server or testers PCs doesn't have SQL server or any of its components installed. Hence, I referred a column from this site (http://www.sqldts.com/225.aspx) and I could build a setup program with all the required files and SQL DLLs. Now, when I run this setup on test server (Win 2K Server, no SQL component installed earlier) it is installed with no errors and runs fine. Same with one test PC. BUT, when I try to install it on our tester's PC it fails to register only 1 DLL from the SQL DLL set (axscphst.dll). The error I get is:
------------------------------------------------------------------------------------------------
Module <app path>\axscphst.dll failed to register.
HRESULT -2147024770. Contact your support personnel.
------------------------------------------------------------------------------------------------
If I continue installation, it continues with registering all other DLLs and finishes successfully.
Obviously, it doesn't work. So, I tried to re-register it using regsvr32. When I try to register all DLLs, all of those gets registered successfully except this (axscphst.dll). The error message I get is:
------------------------------------------------------------------------------------------------
---------------------------
RegSvr32
---------------------------
LoadLibrary("C:\Program Files\<app path>\DistributedDTS\axscphst.dll") failed - The specified module could not be found.
---------------------------
OK
---------------------------
------------------------------------------------------------------------------------------------
I tried to Google and can get only one URL: https://forums.microsoft.com/MSDN/Sh...20805&SiteID=1
But, the solution suggested here is something I'm already doing.
Can anyone tell me what I should do to find why its not getting registered only on this PC. If there is any workaround, kindly let me know that too.
It has become urgent issue now, so, please, please reply ASAP.
Thank you to all in advance. (If required, please move it to correct forum)
Cheers,
Nikhil