|
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
|
|
| Pass-Through Query in Access 2007 generating Error |
| Author |
Message |
|
|
| Posted : 2008-06-01 07:46:54 |
When I try to create a pass-through query, after I select the Quickbooks DSN, I get the following error:
I edit the connection string, but get another error:
Suggestions? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-06-02 08:50:13 |
Edit the the ODBC Connect Str to use just use: ODBC;DSN=QuickBooks Data;SERVER-QODBC; only. The rest of the connection parameters will be loaded by QODBC based on your settings.
|
|
|
|
|
|
| Posted : 2008-06-05 08:37:31 |
Still no joy. Here is the screenshot showing both the Query Properties and the error message. I started VBDemo and ran a query successfully both before and after the screenshot was taken, so I am connected to the db.
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-06-05 09:23:31 |
| The second error is not related to the connection string and you haven't provided any details on the SQL Statement you are using. |
|
|
|
|