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
|
|
Vista - linked to SQL server, no results in queries? |
Author |
Message |
|
Posted : 2008-07-03 00:45:40 |
I'm trying to set up QODBC for a Quickbooks integration project and I'm having problems with it as a linked server in SQL server 2005...
Yesterday I had it working for most of the tables and returning results... log in today (The computer hasn't even been rebooted) and I get 0 rows for every query I try on any table in QB.
The script to test DCOM works, I created a new ODBC datasource for it with the optimizer set to a static location, which I made sure was read/write, Quickbooks user has full access to everything...
What else can I be missing?
Even when it was pulling results successfully yesterday I still was never able to get ANY results from the customers list... but was able to see all the invoices, employees, etc. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-07-03 07:53:38 |
To repair the optimized Customer table you can try running :-
SELECT * FROM OPENQUERY(QUICKBOOKS, 'SELECT * FROM Customer VERIFY WHERE ListID = "x"')
Where QUICKBOOKS is the name of the linked server. |
|
|
|
|
Posted : 2009-01-01 04:15:22 |
I am able to connect to QB with the included VB Demo and query any table and bring back results.
I go try to do the same in my web app using coldfusion and do the same query the demo is doing, no results. It is connecting, because when I dump the results it will bring back all the field columns, just no data.
Here is the query: SELECT * FROM Customer
It brings back nearly 3000 records in the demo - 0 records in my web app.
Any solution? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-01 13:58:35 |
Try running:
SELECT * FROM Customer unoptimized
from within your WebApp. |
|
|
|
|
Posted : 2009-01-03 07:38:42 |
The query is SO SLOW...the unoptimized worked...why? Never heard of unoptimized after the table name...
Anyways, would like to know why that is letting results come back.
Second - query is extremely slow thru our web app.
We have almost 3000 records in customer table
This query here will not resolve before timing out: SELECT * FROM Customer unoptimized WHERE fullname LIKE '%Yellow%'
This query will here will take about 8 seconds to resolve (still slow compared to our MS SQL apps): SELECT * FROM Customer unoptimized WHERE fullname = 'Yellow Dog Productions, LLC'
The same queries above using the VB Demo are less than 2 seconds for both.
Why are we having such trouble with query speeds...? Is It the "unoptimized" doing it?
Thanks.
Chuck |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-03 08:47:32 |
|
|
|
|