What i m using?

• Windows server 2003 Eenterprise Edition
• Quick Books:simple start free Starter Edition 2007
• Qodbc Version 8.0.0.234  30 day free trial version
• Apache 2.2 and php 5
• And RDC(Remote desktop Connection application) from window2000/xp to setup all the things on this window2003 server

What the problem

 when i use the vb demo with my self made DSN it works fine but when i use this DSN with your php sample file or as well in my file it give me following  error .

   On the Browser it says
 ----------------------------------------------------------
Warning: odbc_connect() [function.odbc-connect]: SQL error: [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. , SQL state S0000 in SQLConnect in C:\xampp\htdocs\qbook\conn.php on line 4

Error >> [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.

---------------------------------------------------------------

 AND in the qbsdklog.txt
=-----------------------------------------------------------------------------=
20071011.082832 I 113120 RequestProcessor ========= Started Connection =========
20071011.082832 I 113120 RequestProcessor Request Processor, QBXMLRP2 v6.0
20071011.082832 I 113120 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20071011.082832 E 113120 RequestProcessor An internal error occured while looking for a running instance of QuickBooks. Cannot continue. hr = 800401f3
20071011.082832 E 113120 RequestProcessor Could not create instance of QuickBooks. hr = 8004041c
20071011.082832 I 113120 RequestProcessor Connection closed by app named 'FLEXquarters QODBC'
20071011.082832 I 113120 RequestProcessor ========== Ended Connection ==========

=--------------------------------------------------------------------=

but when i use vb demo then in the  qbsdklog.txt  it says
=======---------------------------------------------======================
20071011.082728 I 120484 RequestProcessor ========= Started Connection =========
20071011.082728 I 120484 RequestProcessor Request Processor, QBXMLRP2 v6.0
20071011.082728 I 120484 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20071011.082754 I 120484 RequestProcessor Opening the file in the DoNotCare mode.
20071011.082820 I 108396 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 120484).
20071011.082821 I 108396 SpecVersion Current version of qbXML in use: 4.0
20071011.082821 I 108396 QBSDKMsgSetHandler QUERY: Host
20071011.082821 I 108396 QBSDKMsgSetHandler Request 1 completed successfully.
20071011.082821 I 108396 QBSDKMsgSetHandler QUERY: Company
20071011.082821 I 108396 QBSDKMsgSetHandler Request 2 completed successfully.
20071011.082821 I 108396 QBSDKMsgSetHandler QUERY: DataExtension Definition
20071011.082821 I 108396 QBSDKMsgSetHandler Request 3 completed successfully.
20071011.082821 I 108396 MsgSetHandler Finished.
20071011.082821 I 108396 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 120484), ret = 0.
20071011.082832 I 113120 CertVerifier The file does not contain an Authenticode signature.
================-------------------------------------=======================

it give the permision on all the folder specified in this forum even on the program file/\Intuit i gave the permission to every one .( administrator , iUSER_TEMPLATE ,everyone and gave full permission ) but nothing changed

My DSN settings (Summary)    Note: i m not usign DCOM enable and following setting is working fine on xp on my loacl pc (even on php)

Advanced(Tab)1.

General(tab)

Detail Trace when press the test connection button ON DSN creation

-********--**********----**********---**********---**********---**********---**********---**********-------

ISAMOpen
    Database: C:\Documents and Settings\All Users\Documents\Intuit\QuickBooks\Company Files\Forest Diamonds Inc..QBW
    DSN: qbook1
    UserName:
    Password:
    DeveloperCode:
    ApplicationCode:
    OpenMode: F
    UseDCOM: N
    IBizRemoteConnection: N
    IBizRemoteURL: http://localhost:2080
    IBizRemoteUserName: admin
    IBizRemotePassword:
    IBizRemoteAskPassword: Y
    IBizRemoteSSLAcceptServerCert:
    IBizRemoteConnectionTimeOut: 120
    IBizRemoteForce2002_2003: N
    IBizOEConnection: N
    IBizOETicketGUID:
    IBizOELoginGUID:
    IBizOELoginAsk: Y
    IBizReconnectionDelay: 0
    ColumnNameLen: 50
    UseCaseSensitiveRefNumber: Y
    OptimizerOn: Y
    OptimizerDBFolder: C:\Documents and Settings\Administrator\Application Data\QODBC Driver for QuickBooks\Optimizer
    OptimizerCurrency: C
    OptimizerDirtyReads: N
    OptimizerUpdateSync: N
    OptimizerEncrytionOn: Y
    ShortCircuitOptimizeFields: N
    UseIterators: Y
    IteratorChunkSize:  500
    IAppLaunchQBUI: Y
    IAppAutomaticLogin: N
    IAppReadOnly: N
    IAppAllowPersonalData: Y
    ConvertToLongVARCHAR: FALSE
    MaxLONGVARCHAR:  4096
    Convert To LONGVARCHAR: N
    Max LONGVARCHAR:   4096
    OleInitialize - Returned OK
    Logged In User:    Administrator
    Is a Service:      No
    Registration Name:
    RegSerial:        
    QODBC Version:     8.00.00.234
    DLL:               C:\WINDOWS\system32\fqqb32.dll
    Driver Name:       FQQB32.DLL
    Process Count:     1
    Thread Count:      0
    OpenMode:          Follow Company
    Include Raw:       No
    Version Type:      Evaluation QODBC Server Edition 2008
    Access Method:     QBXMLRP2.DLL (IAuth2)
    Thread ID:         88152
    SDK Module:        QBXMLRP2.DLL (IAuth2)
    QB Company Name:   C:\Documents and Settings\All Users\Documents\Intuit\QuickBooks\Company Files\Forest Diamonds Inc..QBW
    QB Product Name:   QuickBooks: Simple Start Free Starter Edition
    QB Major Version:  17
    QB Minor Version:  0
    QB File Mode:      SingleUser
    QB Automatic Login:No
    QB Country:        US
    QB Supported Ver:  1.0
    QB Supported Ver:  1.1
    QB Supported Ver:  2.0
    QB Supported Ver:  2.1
    QB Supported Ver:  3.0
    QB Supported Ver:  4.0
    QB Supported Ver:  4.1
    QB Supported Ver:  5.0
    QB Supported Ver:  6.0
    Optimize SQLITE3 Library Version: 3003007
    Optimize File Contents: C:\Documents and Settings\Administrator\Application Data\QODBC Driver for QuickBooks\Optimizer\Forest Diamonds Inc..OPT
        type                      name                      tbl_name                  rootpage                  sql                                                                                                 
        ========================= ========================= ========================= ========================= ====================================================================================================
        table                     FQOptimizeList            FQOptimizeList            2                         CREATE TABLE "FQOptimizeList"("FQOptimizeList_OptimizeName" VARCHAR(50) NOT NULL UNIQUE COLLATE NOCA
        index                     sqlite_autoindex_FQOptimi FQOptimizeList            3                                                                                                                             
        table                     FQOptimizeVersion         FQOptimizeVersion         4                         CREATE TABLE "FQOptimizeVersion" ("FQOptimizeVersion_CompanyName" VARCHAR(1000), "FQOptimizeVersion_
    FQOptimizeList Contents
        OptimizeName              TableList                 SQL                       LastTimeModified          LastTimeDeleted           LastTransactionTimeModifi LastTransactionTimeModifi LastTransactionTimeModifi LastTransactionTimeModifi TimeOfSecu
        ========================= ========================= ========================= ========================= ========================= ========================= ========================= ========================= ========================= ==========
    FQOptimizeVersion Contents
        CompanyName               Version                  
        ========================= =========================
        Forest Diamonds Inc.      5                        
    Optimize File: C:\Documents and Settings\Administrator\Application Data\QODBC Driver for QuickBooks\Optimizer\Forest Diamonds Inc..OPT
    0x00158AB8 [ISAM]
    NO_ISAM_ERR 00000 00000
ISAMClose
    0x00158AB8 [ISAM]
    Optimize SQLITE3 Library Version: 3003007
    Optimize File Contents: C:\Documents and Settings\Administrator\Application Data\QODBC Driver for QuickBooks\Optimizer\Forest Diamonds Inc..OPT
        type                      name                      tbl_name                  rootpage                  sql                                                                                                 
        ========================= ========================= ========================= ========================= ====================================================================================================
        table                     FQOptimizeList            FQOptimizeList            2                         CREATE TABLE "FQOptimizeList"("FQOptimizeList_OptimizeName" VARCHAR(50) NOT NULL UNIQUE COLLATE NOCA
        index                     sqlite_autoindex_FQOptimi FQOptimizeList            3                                                                                                                             
        table                     FQOptimizeVersion         FQOptimizeVersion         4                         CREATE TABLE "FQOptimizeVersion" ("FQOptimizeVersion_CompanyName" VARCHAR(1000), "FQOptimizeVersion_
    FQOptimizeList Contents
        OptimizeName              TableList                 SQL                       LastTimeModified          LastTimeDeleted           LastTransactionTimeModifi LastTransactionTimeModifi LastTransactionTimeModifi LastTransactionTimeModifi TimeOfSecu
        ========================= ========================= ========================= ========================= ========================= ========================= ========================= ========================= ========================= ==========
    FQOptimizeVersion Contents
        CompanyName               Version                  
        ========================= =========================
        Forest Diamonds Inc.      5                        
    NO_ISAM_ERR 00000 00000
--------------------------------*********************________________*********************___________________********

All the same things apply as in How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? but in your case it's the Apache system user. See also: I can't use the Remote Desktop and Terminal Services to setup DCOMs? 

There's also a updated version of DisplaySQL.php that can be found at: PHP samples or help?

Please install QODBC v8 (see: How can I get the latest version of QODBC? ) and then go back to the basics and perform the: How do I connect to QuickBooks for the first time? procedure before doing anything about setting up the QODBC DCOMs.

I don't use the Simply Start edition. Everything on this forum applies to Pro, Premier and Enterprise.

Hello tom ,
I upgrated to v8.0 but it still display the same Msg Box again, nothig changed.

any suggestion.

I repeat, go back to the basics and perform the: How do I connect to QuickBooks for the first time? procedure before doing anything about setting up the QODBC DCOMs.

Does the VB Demo connection work (without the DCOMs)?

Have you registered your copy of QuickBook Simple Start Edition? Your copy must be registered with Intuit before QODBC will connect.

What type of security have you setup on the server? There can be all sort of permissions issues using AUTHENTICATED USERS. Sometimes the *shotgun* approach of giving everything that has the words QODBC in it is the only way....

See the last post in: Permissions Issue with IIS using AUTHENTICATED USERS