Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    119

    Unanswered: ActiveX component can't create an object

    Good day!

    I encounter this error "ActiveX component can't create an object" whenever I run the report from my Visual Basic program.

    The programming tools I used:
    FrontEnd: Visual Basic 6
    BackEnd: MS SQL Server 2000
    Reports: Crystal Reports 9

    I have a report where it needs to get data from a different data source w/c is Pervasive SQL. What I did...I import data from Pervasive SQL to MS SQL Server using a DTS Package. Then I call the report, the report will now be getting data from MS SQL Server.

    My problem is...everytime I run the report, this error occurs. But what puzzled me is that it only occurs on some computers.

    What could be the cause and solution of the error?

    Please help.
    Thanks a lot.

  2. #2
    Join Date
    Oct 2005
    Posts
    119
    Everytime I run the report, the DTS Package will be executed first.

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    But what puzzled me is that it only occurs on some computers
    This is a sign that you need support files installed on the target computer.

    If you distributed the app by copying an exe to the target computers, you are experiencing why that isn't a good idea. Instead, BUILD A SETUP PACKAGE!

    Generally, the package & Deployment wizard does an acceptable job. A better solution is visual studio installer (VSI)
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •