I am having an interesting problem. I downloaded the trial, and set up an SSIS package to run on a schedule which worked great after i figured out how to set up a proxy. Now my trial ran out and i bought the read only version, as i dont need to write any data to QB, just pull it out with my scheduled package. Now the package refuses to run on a schedule. It acts just like it did before i set up the proxy. Is there something tied to the proxy that i set up? Or does it have something to do with the version i bought? I'm using QB Enterprise Retail Edition 7.0 and SQL 2005.... Any help would be much appreciated.

Thanks

Ben

I think you mean DCOM? The Read Only version of QODBC doesn't support Windows Services. The use of Windows Services requires the QODBC Server Edition. When QODBC is run in evaluation mode it is a QODBC Server Edition Evaluation.

See: How does the 30 day evaluation work? How can I evaluate the Desktop Edition? 

Ok, so if i'm understanding this correctly.... Because SQL uses its own Windows service to schedule an SSIS package, i have to have the server edition with the DCOM? What if i only need the DCOM to be able to schedule to pull data from QB, is there a solution other then buying the $500 Server Edition because i will not ever be writing to QB? Maybe just a DCOM patch upgrade?

Thanks for your help

Ben

If you are going to use the Read Only version of QODBC, then you will need to setup the QODBC Remote Connector and iBiz Remote Connector locally on your SQL Server instead. See: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? 

Ok, now we're seeing progress. Do i need to set up and funky security settings or anything (meaning do i need to set up a proxy account?) as i am just getting a failed package. The IBIZ integrator is showing this in the log: Client Connected, Client Disconnected, Client Connected, Client Disconnected... etc, you get the point. It seems to be reading it ok, as its showing something in the log... but just to make sure, i just need to leave it set to read from the localhost:2080 correct?

Thanks

Ben

I am receiving errors at any level i can think to test it. Any time i have the remote connector it errors out, from the VBDemo and from the QODBC Configuration screen when you "Test Connection to QB". The only way i can get it to work is if i turn the remote connector off, then it connects just fine, with both VBDemo and the Test connection. I have tried every setting i can find in the QODBC, but no luck.

What am i doing wrong?
Ben

Ok, after testing with every setting i could think of, i'm still getting errors in the VBDemo. Its saying "[QODBC] Only Licensed for use with Enterprise Version Please contact your dealer for an upgrade". I can get it to run without the remote connector, but then it won't schedule. Do i need an upgrade to make this work?

Ben

Sounds like you're running the QODBC Enterprise Edition? The QODBC Remote Connector requires the full version of QODBC. Please download and install the latest full version update.

See:  How can I get the latest version of QODBC? 

Upgrade has been installed, but no change. From the beginning i've been under the impression that i had a full version... I just downloaded the trial, and then bought the Read Only version. The upgrade seemed to work just fine, downloaded and installed over my existing QODBC, and then had to re-set all of my preferences... but i'm still getting the Enterprise Version error when i try and connect with the VBDemo. I'm not sure where to go from here.......

Ben