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
|
|
new upgrade broke "insert payment" (QB Ent 8.0, QODBC 8.0) |
Author |
Message |
Mike |
|
Group | : Members |
Posts | : 7 |
Joined | : 2006-06-17 |
|
Profile |
|
Posted : 2008-04-19 02:41:46 |
Hello-
We just upgraded QB from Enterprise 6.0 to Enterprise 8.0, and also upgraded QODBC to 8.0. Our integration is successfully migrating both customers and invoices into and out of QB, and we are successfully also reading histories of payments.
The code that broke performs an INSERT into the ReceivePaymentLine table. Before the upgrade, this code had successfully received many thousands of payments into QB. We are using an ADODB Connection and Recordset and everything is working until the rs.open() statement (which opens the Recordset). That line of code just appears to hang, and never return.
For all the working queries the QODBC "Driver Status Panel" pops up and we can see the queries and status. And we occasionally get another dialog, something like "You have started a long QODBC query, please be patient." But for this INSERT statement, neither of these display even after 5-10 minutes.
Any help or suggestions greatly appreciated.
Mike |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-04-21 08:14:45 |
Try reviewing the ends of your QODBC and SDK Message logs for any possible error messages:-
and also try excuting a single payment statement using VB Demo instead. |
|
|
|
Mike |
|
Group | : Members |
Posts | : 7 |
Joined | : 2006-06-17 |
|
Profile |
|
Posted : 2008-04-22 02:26:09 |
The trace log contained one of those "activate the DESKTOP features" messages associated with versioning/licensing. Peculiar it never showed in a pop-up, but the message led me to the registration page which showed R/W version 2006, Version 8.0, and a serial id that started with W06. Not sure what happened, I have registered and entered the CD key for 2008.
Complete uninstall/reinstall (without entering the CD key), and I back up and running.
Thanks for your help- |
|
|
|
|