We own the read write version of QODBC (v6 155). We are only using the driver to retrieve data for now. I've written two applications (perl/CGI/Win32/Excel) to retrieve Purchase Order and Invoice information. The applications work sometimes.
When the applications don't work, there are messages in the Apache error log to the effect that the connection failed.
The system is set to connect whether QuickBooks is running or not.
I am including the text from the ODBC messages, the messages from the SDK and the messages from the Apache error log. Notice that the error messages have a reference to:
SELECT "type", "tbl_name" FROM "SQLite_MASTER" database disk image is malformed
First the Apache error log entries:
[Tue Jun 20 19:58:44 2006] [error] [client 127.0.0.1] DBI connect('REPORTS','reports',...) failed: [QODBC] QB Begin Session Failed. Error = 80040421, This application is not allowed to change its authentication preferences unless QuickBooks is running with the Administrator logged in., referer: http://localhost/cgi-bin/po.cgi [Tue Jun 20 19:58:44 2006] [error] [client 127.0.0.1] (SQL-00000)(DBD: db_login/SQLConnect err=-1) at D:/Apache2/cgi-bin/po.cgi line 185, referer: http://localhost/cgi-bin/po.cgi
ODBC Messages
2006-06-20 19:58:44 QODBC Ver: 6.00.00.155 ********************************************************************************************************************* IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040421, This application is not allowed to change its authentication preferences unless QuickBooks is running with the Administrator logged in. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
2006-06-20 19:58:59 QODBC Ver: 6.00.00.155 ********************************************************************************************************************* IsAService: False SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" database disk image is malformed
2006-06-19 18:02:43 QODBC Ver: 6.00.00.155 ********************************************************************************************************************* IsAService: True Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
-----------------------------------------------------------
SDK Messages
20060619.174234 I 5708 CertVerifier The file does not contain an Authenticode signature.
20060619.174234 I 5708 RequestProcessor ========= Started Connection ========= 20060619.174234 I 5708 RequestProcessor Request Processor, QBXMLRP2 v5.0 20060619.174234 I 5708 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060619.174235 I 5708 RequestProcessor Opening the file in the Multi-User mode. 20060619.174246 I 5708 RequestProcessor Connection closed by app named 'FLEXquarters QODBC' 20060619.174246 I 5708 RequestProcessor ========== Ended Connection ========== XML in use: 4.0 20060619.174237 I 4444 QBSDKMsgSetHandler QUERY: Host 20060619.174237 I 4444 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174237 I 4444 QBSDKMsgSetHandler QUERY: Company 20060619.174237 I 4444 QBSDKMsgSetHandler Request 2 completed successfully. 20060619.174237 I 4444 QBSDKMsgSetHandler QUERY: DataExtension Definition 20060619.174237 I 4444 QBSDKMsgSetHandler Request 3 completed successfully. 20060619.174237 I 4444 MsgSetHandler Finished. 20060619.174237 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 5708), ret = 0. 20060619.174238 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 5708). 20060619.174238 I 4444 SpecVersion Current version of qbXML in use: 5.0 20060619.174238 I 4444 QBSDKMsgSetHandler QUERY: PO 20060619.174238 I 4444 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 100 20060619.174238 I 4444 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174238 I 4444 MsgSetHandler Finished. 20060619.174238 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 5708), ret = 0. 20060619.174239 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 5708). 20060619.174239 I 4444 SpecVersion Current version of qbXML in use: 5.0 20060619.174239 I 4444 QBSDKMsgSetHandler QUERY: Transaction Delete 20060619.174239 I 4444 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174239 I 4444 MsgSetHandler Finished. 20060619.174239 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 5708), ret = 0. 20060619.174242 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 5708). 20060619.174242 I 4444 SpecVersion Current version of qbXML in use: 5.0 20060619.174242 I 4444 QBSDKMsgSetHandler QUERY: PO 20060619.174242 I 4444 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 100 20060619.174242 I 4444 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174242 I 4444 MsgSetHandler Finished. 20060619.174242 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 5708), ret = 0. 20060619.174243 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 5708). 20060619.174243 I 4444 SpecVersion Current version of qbXML in use: 5.0 20060619.174243 I 4444 QBSDKMsgSetHandler QUERY: Transaction Delete 20060619.174243 I 4444 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174243 I 4444 MsgSetHandler Finished. 20060619.174243 I 4444 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 5708), ret = 0. 20060619.174325 I 3328 CertVerifier The file does not contain an Authenticode signature.
20060619.174325 I 3328 RequestProcessor ========= Started Connection ========= 20060619.174325 I 3328 RequestProcessor Request Processor, QBXMLRP2 v5.0 20060619.174325 I 3328 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060619.174326 I 3328 RequestProcessor Opening the file in the Multi-User mode. 20060619.174329 I 5168 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3328). 20060619.174329 I 5168 SpecVersion Current version of qbXML in use: 4.0 20060619.174329 I 5168 QBSDKMsgSetHandler QUERY: Host 20060619.174329 I 5168 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174329 I 5168 QBSDKMsgSetHandler QUERY: Company 20060619.174329 I 5168 QBSDKMsgSetHandler Request 2 completed successfully. 20060619.174329 I 5168 QBSDKMsgSetHandler QUERY: DataExtension Definition 20060619.174329 I 5168 QBSDKMsgSetHandler Request 3 completed successfully. 20060619.174329 I 5168 MsgSetHandler Finished. 20060619.174329 I 5168 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3328), ret = 0. 20060619.174329 I 5168 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3328). 20060619.174329 I 5168 SpecVersion Current version of qbXML in use: 5.0 20060619.174329 I 5168 QBSDKMsgSetHandler QUERY: PO 20060619.174329 I 5168 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 100 20060619.174329 I 5168 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174329 I 5168 MsgSetHandler Finished. 20060619.174329 I 5168 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3328), ret = 0. 20060619.174330 I 5168 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3328). 20060619.174330 I 5168 SpecVersion Current version of qbXML in use: 5.0 20060619.174330 I 5168 QBSDKMsgSetHandler QUERY: Transaction Delete 20060619.174330 I 5168 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174330 I 5168 MsgSetHandler Finished. 20060619.174330 I 5168 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3328), ret = 0. 20060619.174333 I 3328 RequestProcessor Connection closed by app named 'FLEXquarters QODBC' 20060619.174333 I 3328 RequestProcessor ========== Ended Connection ========== 20060619.174351 I 368 CertVerifier The file does not contain an Authenticode signature.
20060619.174351 I 368 RequestProcessor ========= Started Connection ========= 20060619.174351 I 368 RequestProcessor Request Processor, QBXMLRP2 v5.0 20060619.174351 I 368 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060619.174352 I 368 RequestProcessor Opening the file in the Multi-User mode. 20060619.174355 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 368). 20060619.174355 I 5280 SpecVersion Current version of qbXML in use: 4.0 20060619.174355 I 5280 QBSDKMsgSetHandler QUERY: Host 20060619.174355 I 5280 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174355 I 5280 QBSDKMsgSetHandler QUERY: Company 20060619.174355 I 5280 QBSDKMsgSetHandler Request 2 completed successfully. 20060619.174355 I 5280 QBSDKMsgSetHandler QUERY: DataExtension Definition 20060619.174355 I 5280 QBSDKMsgSetHandler Request 3 completed successfully. 20060619.174355 I 5280 MsgSetHandler Finished. 20060619.174355 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 368), ret = 0. 20060619.174355 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 368). 20060619.174355 I 5280 SpecVersion Current version of qbXML in use: 5.0 20060619.174355 I 5280 QBSDKMsgSetHandler QUERY: PO 20060619.174355 I 5280 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 100 20060619.174355 I 5280 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174355 I 5280 MsgSetHandler Finished. 20060619.174355 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 368), ret = 0. 20060619.174356 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 368). 20060619.174356 I 5280 SpecVersion Current version of qbXML in use: 5.0 20060619.174356 I 5280 QBSDKMsgSetHandler QUERY: Transaction Delete 20060619.174356 I 5280 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174356 I 5280 MsgSetHandler Finished. 20060619.174356 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 368), ret = 0. 20060619.174358 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 368). 20060619.174358 I 5280 SpecVersion Current version of qbXML in use: 5.0 20060619.174358 I 5280 QBSDKMsgSetHandler QUERY: PO 20060619.174358 I 5280 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 100 20060619.174358 I 5280 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174358 I 5280 MsgSetHandler Finished. 20060619.174358 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 368), ret = 0. 20060619.174359 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 368). 20060619.174359 I 5280 SpecVersion Current version of qbXML in use: 5.0 20060619.174359 I 5280 QBSDKMsgSetHandler QUERY: Transaction Delete 20060619.174359 I 5280 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174359 I 5280 MsgSetHandler Finished. 20060619.174359 I 5280 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 368), ret = 0. 20060619.174402 I 368 RequestProcessor Connection closed by app named 'FLEXquarters QODBC' 20060619.174402 I 368 RequestProcessor ========== Ended Connection ========== 20060619.174744 I 588 CertVerifier The file does not contain an Authenticode signature.
20060619.174744 I 588 RequestProcessor ========= Started Connection ========= 20060619.174744 I 588 RequestProcessor Request Processor, QBXMLRP2 v5.0 20060619.174744 I 588 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060619.174745 I 588 RequestProcessor Opening the file in the Multi-User mode. 20060619.174747 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 588). 20060619.174748 I 2008 SpecVersion Current version of qbXML in use: 4.0 20060619.174748 I 2008 QBSDKMsgSetHandler QUERY: Host 20060619.174748 I 2008 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174748 I 2008 QBSDKMsgSetHandler QUERY: Company 20060619.174748 I 2008 QBSDKMsgSetHandler Request 2 completed successfully. 20060619.174748 I 2008 QBSDKMsgSetHandler QUERY: DataExtension Definition 20060619.174748 I 2008 QBSDKMsgSetHandler Request 3 completed successfully. 20060619.174748 I 2008 MsgSetHandler Finished. 20060619.174748 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 588), ret = 0. 20060619.174749 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 588). 20060619.174749 I 2008 SpecVersion Current version of qbXML in use: 5.0 20060619.174749 I 2008 QBSDKMsgSetHandler QUERY: Invoice 20060619.174749 I 2008 InvoiceStorage::DoQuery Setting iterator chunk size to 100 20060619.174800 I 2008 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.174800 I 2008 MsgSetHandler Finished. 20060619.174800 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 588), ret = 0. 20060619.175154 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 588). 20060619.175154 I 2008 SpecVersion Current version of qbXML in use: 5.0 20060619.175154 I 2008 QBSDKMsgSetHandler QUERY: Transaction Delete 20060619.175154 I 2008 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.175154 I 2008 MsgSetHandler Finished. 20060619.175154 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 588), ret = 0. 20060619.175155 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 588). 20060619.175155 I 2008 SpecVersion Current version of qbXML in use: 5.0 20060619.175155 I 2008 QBSDKMsgSetHandler QUERY: Invoice 20060619.175155 I 2008 InvoiceStorage::DoQuery Setting iterator chunk size to 100 20060619.175159 I 2008 QBSDKMsgSetHandler Request 1 completed successfully. 20060619.175159 I 2008 MsgSetHandler Finished. 20060619.175159 I 2008 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 588), ret = 0. 20060619.180209 I 2060 CertVerifier The file does not contain an Authenticode signature.
20060619.180209 I 2060 RequestProcessor ========= Started Connection ========= 20060619.180209 I 2060 RequestProcessor Request Processor, QBXMLRP2 v5.0 20060619.180209 I 2060 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060619.180243 E 2060 RequestProcessor An internal error occured while looking for a running instance of QuickBooks. Cannot continue. hr = 80080005 20060619.180243 I 2060 RequestProcessor Connection closed by app named 'FLEXquarters QODBC' 20060619.180243 I 2060 RequestProcessor ========== Ended Connection ==========
Trace Messages:
ISAMOpen Database: D:\quickbooks6_datafile\MMA Partners LLC-qb6.QBW DSN: REPORTS UserName: reports Password: reports DeveloperCode: ApplicationCode: OpenMode: M UseDCOM: N IBizRemoteConnection: N IBizRemoteURL: http://localhost:2080 IBizRemoteUserName: admin IBizRemotePassword: IBizRemoteAskPassword: Y IBizRemoteSSLAcceptServerCert: IBizRemoteConnectionTimeOut: 120 IBizRemoteForce2002_2003: Y IBizOEConnection: N IBizOETicketGUID: IBizOELoginGUID: IBizOELoginAsk: Y IBizReconnectionDelay: 0 ColumnNameLen: 50 UseCaseSensitiveRefNumber: Y OptimizerOn: Y OptimizerDBFolder: C:\Program Files\QODBC Driver for QuickBooks\Optimizer OptimizerCurrency: C OptimizerEncrytionOn: Y IAppLaunchQBUI: N IAppAutomaticLogin: Y IAppReadOnly: N IAppAllowPersonalData: N OleInitialize - Returned OK Logged In User: administrator Is a Service: Yes Registration Name: Agilaire RegSerial: W06U10014455 QODBC Version: 6.00.00.155 DLL: C:\WINDOWS\system32\fqqb32.dll Driver Name: FQQB32.DLL Process Count: 1 Thread Count: 1 OpenMode: Multi-User Mode Include Raw: No Version Type: QODBC Desktop Read Write 2006 Access Method: QBXMLRP2.DLL (IAuth2) Thread ID: 1344 SDK Module: QBXMLRP2.DLL (IAuth2)
2006-06-19 18:02:43 QODBC Ver: 6.00.00.155 ********************************************************************************************************************* IsAService: True Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector" Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
0x00000000 [ISAM] S0000 00000 [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
ISAM_BEGINSESSIONFAIL S0000 00000 [QODBC] QB Begin Session Failed.
|