Visual Web Developer 2008 access to QB ODBC 9.0 |
Author |
Message |
|
Posted : 2009-01-01 02:33:40 |
Hello,
I'm trying to write a web app that will query the QB database using the odbc 9.0 included with our QB 8.0 enterprise edition. I can create a new connection to the database on our server called odbc. I can view the tables. However, when I try to run queries or "retrieve data" from within visual studio I get an errors depending on what I do.
One error states the table might not exist or you may have insufficient permissions. The other error is in response to when I try to run queries such as SELECT ListID FROM Account
Or any other simple query. I get an error "command is not supported by provider" or , a long error with #42S00
I thought I had sufficient permissions to read the data as I can pull it in fom MS Access, and I can also see the tables in VS. I also have QB open on my computer and am logged in as a user, non admin. I'm pretty sure we logged on as admin and granted each program specific access to the company file earlier. I cant stay logged in as admin at my company for security reasons. I have been appointed to develop this appolication however, to query qb from Goldmine using asp.net.
I need this to work real bad, any help would be appreciated. thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-01 14:15:10 |
|
|
|
|
Posted : 2009-01-06 04:02:31 |
But we have quickbooks enterprise edition, I thought the latest odbc driver is included. It also shows a demo on how to get data in to MS Access, a Windows application. I dont understand
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-06 12:32:09 |
|
|
|
|
Posted : 2009-01-07 01:37:31 |
Although I appreciate the condescention, the example in your link is not quite what I need to do. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-07 10:38:51 |
|
|
|
|
Posted : 2009-01-07 13:48:11 |
I do have VS2008 EE Service Pack 1. I'm certainly not claiming to know a lot about this. We will purchase whatever we have to to get this done. I don't think we need the server edition, after calling Flex Quarters and speaking to someone there. They stated that as far as they know, I should be able to run Visual Studio and see data from within that program on the same machine where QB is running. I would only need the server edition if VS was accessing from a different machine. I just wonder why I can see the tables in the database explorer window, after making a connection to the quickbooks DSN, but not actually run any queries without getting the errors below. |
|
|
|
|
Posted : 2009-01-09 08:17:05 |
If anyone has an answer to this I would really appreciate it. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-09 09:17:03 |
|
|
|
|
Posted : 2009-01-10 09:14:19 |
I uninstalled what I had (the desktop edition you can install from Quickbooks) and installed from the link you provided in your last answer. I assume that the download at that link was the NON DESKTOP version?
After installing and running it I get the exact same problem |
|
|
|
|
Posted : 2009-01-10 09:27:49 |
It seems I can run a query now from VWD but it always returns null values. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-10 14:27:34 |
Ok run this SQL Statement:
Select * from Customer unoptimized
If that returns values, rebuild the optimized table by doing:
Select * from Customer verify |
|
|
|
|
Posted : 2009-01-15 08:46:21 |
Select * from Customer unoptimized returned null values as well
|
|
|
|