Board index MS SQL Server

can't create activex component runtime error

can't create activex component runtime error

Post by daren ha » Mon, 24 Mar 2003 23:01:07



i got this error when i program in vb using DTS. on my computer it runs
fine with error but when i install on my clients' pc , it comes out with
this error->"can't create activex component runtime error". pls advise.

If yearStr <> Trim(cmbYear.Text) Then
  infomsg = MsgBox("Year selected does not match year_code in Budget
File uploaded!", vbCritical, "Incorrect File Used")
  Screen.MousePointer = vbDefault
  Exit Sub
End If

SimpleExecutePackage

----------------------------

Private Sub SimpleExecutePackage()

Dim sMessage As String
Dim lErr As Long
Dim sSource As String
Dim sDesc As String

Set oPKG = New DTS.Package

oPKG.LoadFromSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , ,
"Upload TBSS Budget"
oPKG.GlobalVariables("sFileName").Value = Trim(txtFileName.Text)
oPKG.GlobalVariables("sTableName").Value = Trim(xlsString)
oPKG.GlobalVariables("sHeaderName").Value = Trim(HeaderString)
oPKG.SaveToSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , , ,
True

For Each oStep In oPKG.Steps
  oStep.ExecuteInMainThread = True
Next

oPKG.Execute

For Each oStep In oPKG.Steps
  If oStep.ExecutionResult = DTSStepExecResult_Failure Then
    oStep.GetExecutionErrorInfo lErr, sSource, sDesc
    sMessage = sMessage & "Step """ & oStep.Name & _
               """ Failed" & vbCrLf & _
               vbTab & "Error: " & lErr & vbCrLf & _
               vbTab & "Source: " & sSource & vbCrLf & _
               vbTab & "Description: " & sDesc & vbCrLf & vbCrLf
    Else
      sMessage = sMessage & "Step """ & oStep.Name & _
                 """ Succeeded" & vbCrLf & vbCrLf
    End If
Next

oPKG.UnInitialize

Set oStep = Nothing
Set oPKG = Nothing

End Sub

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

can't create activex component runtime error

Post by Narayana Vyas Kondredd » Tue, 25 Mar 2003 00:59:18


Do you know on which line you are getting this error? Most probably while
instantiating the DTS package object, which would mean that the required
components are not present on your client's PC. Do you know if your client's
PC has SQL client tools installed?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


i got this error when i program in vb using DTS. on my computer it runs
fine with error but when i install on my clients' pc , it comes out with
this error->"can't create activex component runtime error". pls advise.

If yearStr <> Trim(cmbYear.Text) Then
  infomsg = MsgBox("Year selected does not match year_code in Budget
File uploaded!", vbCritical, "Incorrect File Used")
  Screen.MousePointer = vbDefault
  Exit Sub
End If

SimpleExecutePackage

----------------------------

Private Sub SimpleExecutePackage()

Dim sMessage As String
Dim lErr As Long
Dim sSource As String
Dim sDesc As String

Set oPKG = New DTS.Package

oPKG.LoadFromSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , ,
"Upload TBSS Budget"
oPKG.GlobalVariables("sFileName").Value = Trim(txtFileName.Text)
oPKG.GlobalVariables("sTableName").Value = Trim(xlsString)
oPKG.GlobalVariables("sHeaderName").Value = Trim(HeaderString)
oPKG.SaveToSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , , ,
True

For Each oStep In oPKG.Steps
  oStep.ExecuteInMainThread = True
Next

oPKG.Execute

For Each oStep In oPKG.Steps
  If oStep.ExecutionResult = DTSStepExecResult_Failure Then
    oStep.GetExecutionErrorInfo lErr, sSource, sDesc
    sMessage = sMessage & "Step """ & oStep.Name & _
               """ Failed" & vbCrLf & _
               vbTab & "Error: " & lErr & vbCrLf & _
               vbTab & "Source: " & sSource & vbCrLf & _
               vbTab & "Description: " & sDesc & vbCrLf & vbCrLf
    Else
      sMessage = sMessage & "Step """ & oStep.Name & _
                 """ Succeeded" & vbCrLf & vbCrLf
    End If
Next

oPKG.UnInitialize

Set oStep = Nothing
Set oPKG = Nothing

End Sub

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

can't create activex component runtime error

Post by daren ha » Tue, 25 Mar 2003 16:51:26


i solved the " can't create activex component
 runtime error" by installing the sql server 7 server components +
client connectivity components. however,
i got another run-time error the system cannot find the find specified.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

can't create activex component runtime error

Post by Narayana Vyas Kondredd » Tue, 25 Mar 2003 16:48:51


Debugging time again :-) Are you referencing a file in your package? Be
aware that DTS is a client side thingy, and when invoked from a client app,
it runs locally. When invoked from a job, it runs on the server. So, you
need to be careful with the file paths. Use UNC paths if you can.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


i solved the " can't create activex component
 runtime error" by installing the sql server 7 server components +
client connectivity components. however,
i got another run-time error the system cannot find the find specified.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

can't create activex component runtime error

Post by daren ha » Tue, 25 Mar 2003 17:22:00


see below. i installed vb and the de* breaks on the code below. my
package name is "Upload TBSS Budget"
and the package description is "Upload TBSS Sale Budget"
what am i doin wrong? on my computer it runs fine.

Private Sub SimpleExecutePackage()

Dim sMessage As String
Dim lErr As Long
Dim sSource As String
Dim sDesc As String

Set oPKG = New DTS.Package

oPKG.LoadFromSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , ,
"Upload TBSS Budget" ---> de* breaks on here!!!
{error: system can't find the file specified here}

oPKG.GlobalVariables("sFileName").Value = Trim(txtFileName.Text)
oPKG.GlobalVariables("sTableName").Value = Trim(xlsString)
oPKG.GlobalVariables("sHeaderName").Value = Trim(HeaderString)
oPKG.SaveToSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , , ,
True

For Each oStep In oPKG.Steps
   oStep.ExecuteInMainThread = True
Next

oPKG.Execute

For Each oStep In oPKG.Steps
   If oStep.ExecutionResult = DTSStepExecResult_Failure Then
     oStep.GetExecutionErrorInfo lErr, sSource, sDesc
     sMessage = sMessage & "Step """ & oStep.Name & _
                """ Failed" & vbCrLf & _
                vbTab & "Error: " & lErr & vbCrLf & _
                vbTab & "Source: " & sSource & vbCrLf & _
                vbTab & "Description: " & sDesc & vbCrLf & vbCrLf
     Else
       sMessage = sMessage & "Step """ & oStep.Name & _
                  """ Succeeded" & vbCrLf & vbCrLf
     End If
Next

oPKG.UnInitialize

Set oStep = Nothing
Set oPKG = Nothing

End Sub

*** Sent via Developersdex http://www.veryComputer.com/ ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

can't create activex component runtime error

Post by Allan Mitchel » Tue, 25 Mar 2003 17:23:57


Hello,

This error can also occur if there are version incompatabilities.

Service Pack and Version Compatibility Problems
http://www.sqldts.com/default.aspx?6,222,223,0,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Debugging time again :-) Are you referencing a file in your package? Be
: aware that DTS is a client side thingy, and when invoked from a client
app,
: it runs locally. When invoked from a job, it runs on the server. So, you
: need to be careful with the file paths. Use UNC paths if you can.
      ---  Microsoft Outlook Express 6.00.2600.0000

 
 
 
Top

can't create activex component runtime error

Post by Narayana Vyas Kondredd » Tue, 25 Mar 2003 17:15:47


The following article talks about this problem:
http://www.veryComputer.com/

--
HTH,
Vyas, MVP (SQL Server)
http://www.veryComputer.com/


see below. i installed vb and the de* breaks on the code below. my
package name is "Upload TBSS Budget"
and the package description is "Upload TBSS Sale Budget"
what am i doin wrong? on my computer it runs fine.

Private Sub SimpleExecutePackage()

Dim sMessage As String
Dim lErr As Long
Dim sSource As String
Dim sDesc As String

Set oPKG = New DTS.Package

oPKG.LoadFromSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , ,
"Upload TBSS Budget" ---> de* breaks on here!!!
{error: system can't find the file specified here}

oPKG.GlobalVariables("sFileName").Value = Trim(txtFileName.Text)
oPKG.GlobalVariables("sTableName").Value = Trim(xlsString)
oPKG.GlobalVariables("sHeaderName").Value = Trim(HeaderString)
oPKG.SaveToSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , , ,
True

For Each oStep In oPKG.Steps
   oStep.ExecuteInMainThread = True
Next

oPKG.Execute

For Each oStep In oPKG.Steps
   If oStep.ExecutionResult = DTSStepExecResult_Failure Then
     oStep.GetExecutionErrorInfo lErr, sSource, sDesc
     sMessage = sMessage & "Step """ & oStep.Name & _
                """ Failed" & vbCrLf & _
                vbTab & "Error: " & lErr & vbCrLf & _
                vbTab & "Source: " & sSource & vbCrLf & _
                vbTab & "Description: " & sDesc & vbCrLf & vbCrLf
     Else
       sMessage = sMessage & "Step """ & oStep.Name & _
                  """ Succeeded" & vbCrLf & vbCrLf
     End If
Next

oPKG.UnInitialize

Set oStep = Nothing
Set oPKG = Nothing

End Sub

*** Sent via Developersdex http://www.veryComputer.com/ ***
Don't just participate in USENET...get rewarded for it!

 
 
 
Top

1. runtime error 429 "ActiveX component cannot create object

I created a small simple program that takes information from a one page
form and writes it to a simple access database.  When trying to save the
data from a remote workstation I get the following error:

runtime error 429 "ActiveX component cannot create object"  I thought it
might have to do with a network mapping problem but the workstation is
mapped correctly so I'm unsure what may be causing the problem.

Any suggestions would be appreciated....thanks

Douglas

2. bug?? with stored proc returning a recordset back to vb/ado when stored proc gets rs from temp table / i have working code which reproduces the problem

3. Error: ActiveX component can't create object in VB

4. Spell Checker

5. ActiveX component can't create an object, error 429

6. Oracle Security

7. DTS Error - ActiveX component can't create object

8. How to use Count function in Query?

9. Error: 429: ActiveX component can't create object

10. Error 429: ActiveX component can't create object when running DTS

11. Error: the component ActiveX can't create the object

12. New PC: Error 429 - ActiveX component can't create object

13. Error 429: ActiveX component can't create object when running DTS


All times are UTC
Board index