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
|
|
QODBC Error with SQL |
Author |
Message |
|
Posted : 2007-04-02 14:31:37 |
My environment is QODBC 7.00.207, SQL 2005 on W2k3 using linked server and Remote Ibiz connector to QB2007 Pro on Win XP.
I have a script in SQL that creates an invoice and then queries the invoice number back out to add to my local sql table. The insert of the invoice is always successful but I frequently get this error when trying to query the newly added invoice number:
Msg 7399, Level 16, State 1, Procedure sp_ImportInvoiceToQuickBooks, Line 55 The OLE DB provider "MSDASQL" for linked server "qodbc" reported an error. The provider reported an unexpected catastrophic failure. Msg 7330, Level 16, State 2, Procedure sp_ImportInvoiceToQuickBooks, Line 55 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "qodbc".
I have tried querying the invoice number a few different ways and now matter how I do it there are problems like this. Right now I am using this query which generates the above error some of the time: select Top 1 @InvoiceNo = RefNumber, @InvTxnId = txnid from qodbc...invoiceline where InvoiceLineTxnLineId is not null order by TimeModified DESC, InvoiceLineSeqNo Desc
I have also tried this query, but it was unreliable too: select @InvoiceNo = max(RefNumber), @InvTxnId = max(txnid) from qodbc...InvoiceLine where CustomerRefListID = @CustomerRefListID and InvoiceLineType = @InvoiceLineType and InvoiceLineItemRefListID = @InvoiceLineItemRefListID and InvoiceLineQuantity = @InvoiceLineQuantity and InvoiceLineRate = @InvoiceLineRate
Also, in my environment, sometimes after successfully running a script or query I get an error when trying to run another one. It seems like all of the resources are not closed properly and therefore the next attempt fails. I will try to post that error next time it occurs. I think it is Error trying to initialize Ibiz Remote Connector.
Anyway, rebooting my SQL Server seems to resolve either issue. When I run the script with the same data after re-booting it works fine. This makes me think the script and data are not the problem. What can I check in my environment to resolve this issue?
Thanks, Harry |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-02 15:39:30 |
QuickBooks and QODBC needs to be on your Windows 2003 Server that's running MS SQL Server 2005. We don't support the use of the iBiz Connector with Windows Services. This should be done via the QODBC Server Edition DCOMs.
You should also update to QODBC v7.00.00.214 which has the new option: Optimize data after an Insert or Update: causes QODBC to do "Load Updated Data" after an insert or update is executed on a table. Useful for programmers who what to test that their data has succesfully been written to QuickBooks.
|
|
|
|
|