Hello ,

I am using licenced version of QODBC Version 8.00.00.24.

Now, i try to connect to the Quickbooks through QODBC. I am using ASP.NET and c# (ADO 2.0) to connect to the Quickbooks.

Below is the connectionstring which i use to connect to the quick books which works.

Dsn=QuickbookDB;Driver={QODBC Driver for QuickBooks};OLE DB Services=-2

Now when i try to run an select query on customer table which has say 15 records it runs successfully, though a bit slow.

Below is my Optimizer setting

Now, when i run a query using my ASP.NET and c# application on item table which has roughly 1500 records. it takes ages to return back the result which
is not always reliable.

Below is the example query which i run
SELECT ListID FROM item NOSYNC WHERE Fullname = "'+itemname+'"

Also note that Fullname is JUMPIN_TYPE

 

Now why does this simple query take such a long time to execute??
Is there any setting i am missing ??

Please help. 

Both your ASP.NET and C# applications need to use a STA (single-threaded-apartment) threading model. Multi-threading actually slows QODBC down as we need to re-establish a connection to QuickBooks every time the Thread ID changes. 

See: ASP.NET vs Classic ASP and Performance - VB Demo verus my C# app