|
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
|
|
| Error trying to query the customer table |
| Author |
Message |
|
|
| Posted : 2006-12-23 03:25:01 |
When I run this query I receive the following error. This is something we have been doing every day forever and as far as I can tell everything seems to be working/functioning fine... Any ideas?
SELECT
C.AccountNumber AS
CustomerMID,
C.ListID
FROM QODBC...Customer AS C
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [QODBC] Error]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ].
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-12-23 13:54:07 |
The error isn't to do with the SQL Statement itself. It is saying that your SQL Server failed to connect with QODBC via the OLE DB provider 'MSDASQL'. This could be for a number of reasons, but the simplest reason could have been that QuickBooks could have been running in sinlge user mode at the time or had another company file open. I would need to know more on your setup to guess further. |
|
|
|
|