This problem has been bugging me for a while now and would love any kind of imput on it.

Here is the problem:
I am creating a VB application that connects to QuickBooks using the Quickbooks SDK. It takes orders from a SQL server Database. I am using ADO to connect to the DB. Below is the code to do this.

References for project:
Visual Basic For Applications
Visual Basic runtime objects and procedures
Visual Basic objects and procedures
Microsoft ActiveX Data Objects 2.5 Library
gbFC1 1.1 Type Library

Components for project:
Microsoft ADO Data Control 6.0 (SP4) (OLEDB)


Private DB As adodb.Connection
Private RS As New adodb.Recordset

Set DB = New adodb.Connection

DB.Open "Driver={SQL Server};" & _
"server=IP_Address;" & _
"Address=IP_Address,1433;" & _
"Network=DBMSSOCN;" & _
"database=DB_name;" & _
"Uid=SQL_UID;" & _
"Pwd=SQL_Pwd;"

MySQL = "Select * FROM Table_Name where QuickBooks = 0"

RS.Open MySQL, DB, adOpenStatic, adLockOptimistic, dCmdText


I am only using the "Public Sub Main()" funtion. When the user clicks on the App.exe the file will run and display results, no user interacation is being used.


I am using the VB Package and Deployment wizard to create the setup.exe package. When I create it and run the setup.exe file on the machine the application was created on it installs without a problem and the app.exe runs error free. But when I run the setup.exe on another computer, the install goes fine but when I run the app.exe I always get the error "ActiveX component can't create object".

Please HELP!!!!!!!!!!!

Thanks beforehand.