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 Inserting Invoice using ASP and IIS |
Author |
Message |
|
Posted : 2006-11-29 03:32:13 |
I'm using IIS to connect to my quickbooks using ASP. I've followed the "Create an Invoice" guide listed in this forum, and I get an error when I run it.
The line item seems to work fine, but when i try to insert the invoice header I get: "Error: 3263 - This request cannot be completed because the integrated application had requested read-only access. Have the integrated application request read/write access, and have the QuickBooks administrator grant this access."
Here's the code for both lines (the invoice line and header): sql = "INSERT INTO InvoiceLine (InvoiceLineItemRefListID, InvoiceLineDesc,InvoiceLineRate, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('ADC0000-1156257299', 'Building permit 1', 1.00000, 1.00, '20000-999022286', 1)" objconn.execute(sql)
sql = "INSERT INTO Invoice (CustomerRefListID, ARAccountRefListID, TxnDate, RefNumber, BillAddressAddr1, BillAddressAddr2, BillAddressCity, BillAddressState, BillAddressPostalCode, BillAddressCountry, IsPending, TermsRefListID, DueDate, ShipDate, ItemSalesTaxRefListID, Memo, IsToBePrinted, CustomerSalesTaxCodeRefListID)" sql = sql & " VALUES ('2FF70000-1093614823', '100000-1009633985',{d'2006-10-01'},'1', 'John Barrett', '2121 2nd Ave. W.', 'Hibbing', 'MN', '55746', 'USA', 0, 'D0000-1009636146',{d'2006-10-31'},{d'2006-10-01'}, '6B60000-1009634165', 'Memo Test', 0, '10000-1053349510')" objconn.execute(sql)
I'm using 127.0.0.1 on my computer to run the script. I've been able to access quickbooks using DisplaySQL.asp. It appears as if the first insert statement works fine. I'm also using the remote connector to connect.
Thanks for the help! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-29 13:13:46 |
If you're using QuickBooks Enterprise, QODBC is automatically read-only and you need to purchase a full read-write or server edition of QODBC. Otherwise you need to have the QuickBooks Admin user check your preferences for Integrated applications and make sure QODBC is not in read-only mode:
|
|
|
|
|