| Author |
Topic |
|
sirrrahhc
Starting Member
8 Posts |
 Posted - 2008-03-09 : 19:13:51
|
| Hey guys whats up?? this is my first time here so if I'm posting this in the wrong forum please let me know...anyways, I'm working with SQL Server 2003 and am having a problem running active x objects from a DTS package. The active x object is a simple vbs file that uploads an xml file into a SQL database. The vb script works fine when ran indenpendantly but when ran from within a DTS package I get an "ActiveX Object Function not found" error...is this an issue with needing to install the latest service pack?? if so, what is the latest version?? thanks in advance guys!!!!!chris harris |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-09 : 19:31:23
|
When you ran the script "independently" ..was it on the server box? or a local PC?The component may not be installed on the server box. Do you have other DTS packages that use ActiveX?When you run the ActiveX script independently, is done while IN DTS design mode? Does the DTS package have the correct connection properties etc?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 19:47:29
|
| we installed sql server on a local box and created a local DB. I ran the DTS package from this box so yes, from the SQL server box but of course I don't have any other DTS packages using active x that i'm trying to run. When I ran the script by itself it was not from DTS design, I just double click the script (the file saved on the c drive) and it ran fine. It also has the correct connection string because when I test the connection step it works fine. i'm stumped????? talked to a couple sql server guys where i work and they suggested installing the latest SP for the version but I couldn't find anything other than SP 1 & 2 for 2003...are these the only SP's for 2003??chris harris |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-09 : 19:52:32
|
Sounds like this:quote:
Note To use Microsoft ActiveX scripting in Microsoft SQL Server 2000 after uninstalling SQL Server 7.0, you must re-register the ActiveX scripting library (Axscphst.dll). Use the Regsvr32.exe registration utility and execute the following command (substituting your own drive letter) from the command prompt or the Windows Run command:regsvr32.exe C:\Program Files\Microsoft SQL Server\80\Tools\Binnaxscphst.dllIf the registration is successful, a message box appears indicating that Axscphst.dll is registered properly.
FROM http://msdn2.microsoft.com/en-us/library/aa933459(SQL.80).aspxI found that pretty easy. Since it works outside DTS, but not inside...it could be that.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 19:59:26
|
| thanks dataguru1971!!!!! I won't get a chance to try this until tomorrow but I will and will re-post to verify that it worked. Thanks again!!!!!chris harris |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-09 : 20:02:44
|
just doing my part to make sure msdn's google cache is updated ;)
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 20:37:57
|
| ok, I went ahead and logged in and tried it...I am getting an error message saying:LoadLibrary("C:\Program")failed - The specified module could not be foundI had to change directories when I started dos prompt...the actual command I ran looked like this:C:\> regsvr32.exe C:\Program Files\Microsoft SQL Server\80\Tools\Binnaxscphst.dllI checked in this directory and that DLL file is not there...any suggestions?? thanks again!!!!!chris harris |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-09 : 20:58:52
|
I would find that DLL, or see if you can install it from the SQL install disc.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 21:06:29
|
| cool, I will install that and let u know how it works, thanks!!!!!chris harris |
|
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 21:32:12
|
| ok, I found the dll file...was checking the wrong spot so the file does exist after all...i have checked my path im entering in c prompt like 14 times and it is written out correct (as far as I can tell)...C:\>regsvr32.exe C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dllThis is all written within 1 command...I have double checked and located the file but keep getting that object could not be found error even tho its there...i could understand if it said it was corrupt or something and needed to be re-installed but that object not found error is wierd to me. I will try re-installing it again tomorrow but just wanted to throw this out there and see what u thought about this...thanks again for your help guru!!!chris harris |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-09 : 21:48:53
|
I really have no idea. I was just googling the problem to see what I could dig up. I wanted to know the answer just in case it happens to me someday!
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 21:58:41
|
| me too...i will keep looking and check w/ my other guys at work tomorrow and c what they think...i'll let u know what i find out, or don't...thanks again!!chris harris |
|
|
|
sirrrahhc
Starting Member
8 Posts |
Posted - 2008-03-09 : 23:22:59
|
| ran a query to find out what version those guys are using and its 2000 w/ sp3 installed...going to try sp4 and c if that fixes it...will let u know...thanks!!chris harris |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2008-03-11 : 15:48:58
|
| sirrrahhc,Change your command line to look like this (see the double quotes):c:\>regsvr32.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll"If that doesn't work, change it to:c:\>%SYSTEMROOT%\System32\regsvr32.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll"Both of those are single line DOS commands, and should be followed by the ENTER key. |
|
|
|
|
Active X Object not found