Hi,
I am trying to access QuickBooks data from my SSIS (SQL Server Integration Services) package. I have installed QODBC driver both on client and remote machines. The remote machine has the QuickBooks application. I have enabled the IBiz Remote Connector on the remote machine and configured the QODBC set up on the client machine so that it connects to the QuickBook instance on the remote machine. On my client machine I have a SSIS package(with one DataFlow task) which reads data from one of the QuickBooks tables by connecting to remote machine using the  QODBC driver. When I try to run the package, I get the below error and the visual studio stops responding. I could the run the package successfully once though.(The SSIS package works fine if the client and remote machine are same.)

Error 1 Validation error. Data Flow Task: DataReader Source 1: System.Data.Odbc.OdbcException: ERROR 00000 QODBC QB Open Connection
Failed. Errored trying to Create IBiz QuickBooks Integration Object ERROR
00000 QODBC QB Open Connection Failed.

Can anyone help me in sorting out the problem ?
Thanks,
Ramakrishna

Thanks for the prompt reply. I am able to use the VB Demo on the client machine successfully. I have configured the client to open the currently opened file in QuickBooks. I also successfully wrote a C# program(on client machine) which connects to QuickBooks(remote machine) using the QODBC driver and reads data from a table. The problem is Iam getting the error while reading a table from  QuickBooks(remote machine) in SSIS(SQL Server Integration Services) package. The connection was successful in SSIS.

--Thanks