|
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
|
|
| errors and failures after primary install |
| Author |
Message |
|
|
| Posted : 2007-07-28 06:05:54 |
I recently installed QODBC on two machines. The first machine is running the remote server, a trial version of QODBC, and Quickbooks Pro 2007. The second machine which will be used as a database development platform is running a trial version of QODBC. We've successfully installed, tested, and accessed the Quickbooks data files on the remote server without incident. However from the remote machine I was initially able to access the Quickbooks datafile as used in the previous successful trial on the remote server only once. The first call to the remote machine retrieved a number of records successfully then failed at about 75% of the way through the same table tested on the server machine. In both cases it was a retrieval of the "invoice" data.
Now when I try and connect via Microsoft Access it attempts to connect, shows a connection, begins to process records and fails when it hits the first record. It does create an empty table with the appropriate column headers but does not retrieve the data when as it did in the first test locally on the remote server. The error message that is displayed in the remote connector is:
[27/07/2007 1:47:03 PM - 192.168.0.56] Client has disconnected.
[27/07/2007 1:47:03 PM - 192.168.0.56] Client has connected.
[27/07/2007 1:47:04 PM - 192.168.0.56]
Received from client: <?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="CA2.0"?>
<QBXML>
<QBXMLMsgsRq onError="continueOnError">
<DataExtDefQueryRq requestID="1">
<OwnerID>0</OwnerID>
</DataExtDefQueryRq>
</QBXMLMsgsRq>
</QBXML>[27/07/2007 1:47:20 PM - 192.168.0.56]
Response from QuickBooks:
[27/07/2007 1:47:20 PM - 192.168.0.56]
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<DataExtDefQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<DataExtDefRet>
<OwnerID>0</OwnerID>
<DataExtName>Job Number</DataExtName>
<DataExtType>STR255TYPE</DataExtType>
<AssignToObject>Customer</AssignToObject>
<AssignToObject>Vendor</AssignToObject>
<AssignToObject>Employee</AssignToObject>
</DataExtDefRet>
</DataExtDefQueryRs>
</QBXMLMsgsRs>
</QBXML>
[27/07/2007 1:47:20 PM - 192.168.0.56]
[27/07/2007 1:47:22 PM - 192.168.0.56] Client has disconnected. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-07-28 10:16:02 |
|
|
|
|