Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Overall poor performanceSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 Overall poor performance 
 Author   Message 
  IX 
  
 Group: Members 
 Posts: 1 
 Joined: 2008-02-14 
 Profile
 Posted : 2008-02-14 03:41:43

Hello -

I'm trying to find some answers to a problem which seems very common with this product. We are constantly having problems with slowness while using ASP.NET, ASP, and MSACCESS to query data from QB Enterprise 7. I've followed the ASP and .net "Remote Connector" instructions and have even spoken to flexquarters support about this. Some days, it works ok - slow, but returns data. Other days, the whole process hangs, some tables query fine, while others hang the browser, MSACCESS and even the QB server needs to be reset sometimes.

Has anyone found a solid way to make this work consistantly? Are we just trying to pull too much data or does QODBC break when trying to query big tables? Has putting QB on a dedicated server helped anyone else? It does not seem to take much network or hardware resources, but perhaps it's one of those apps who wants a server it all to itself? Right now it's running on our file server which does not see a tremendous amount of traffic.

i've heard that running QODBC server edition using DCOM and having a copy of QB running on each web server might improve performance, but we have a large web farm and this could be a nightmare.

I really appreciate any help, but please don't link slap me to another forum unless it directly addresses the problems I've mentioned above. this can make others viewing the post think it's resolved.

Many thanks!

 

 
- Jim Carbone 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-02-14 08:05:25
That's because the QODBC Remote Connector and the iBiz Remote Connector are only mean't to be used with desktop applications. For example, that Excell user that doesn't have QuickBooks on their workstation. When it comes to anything that runs as, or through, a Windows Service, the QODBC Server Edition and QODBC DCOMs must be used and run against QuickBooks on the server itself. The company (.qbw) file can be on another server via a VPN mapped drive if need be. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to