Hi,

I am using QODBC v8 . I was supposed to integrate quickbooks with my application, I am using QODBC for that. I have created a likned server in sql and written a stored procedure in which i''m synchronizing quickbooks invoices with invoices in my application. It works ok when I run it on development pc as .qbw file here is not to huge, ok means it takes around 1-2 mins for simple select queries, synchronization goes much longer. Now in production environment i've set up qodbc connection using remote connector by installing qodbc in pc having quickooks and pc having sql. Test connection to quickbooks is successful and it's even showing me tables in sql. but when i try to execute a single select statement on any table it takes too long. I have tried it on company table which has too less rows, but then also execution goes on for 30-40 mins, and I have to cancel the query. And the stored procedure I have written for quickbook is not even getting created, it also takes 30-40 mins and then I have to cancel. Please help me with this.

Thanks in Advance

Hi Tom,

Thanks for the reply. I have done it as per your suggestion, I have convinced client to use all these in same machine. Client has shifted his servers for that.  I am able to run single query in some seconds.

but my stored procedure is still not getting created. It has been 25 hours that I have started stored procedure creation query, and it's still running. I am not able to undestand what is the problem. RAM is 3 GB on server. QB file size is 112 MB. Please help me with this.

Thanks in Advance.