When I use the VBDemo32 program to Select SalesOrder information, only the Headings show and no data. Also this happens with Invoice data too. I have the driver set up using DCOM, with Crystal Reports Server, does anyone have any ideas why I can't get to the sales data.

Thanks

Glen

Crystal Reports Server runs queries as multiple treads, and the QODBC optimizer is single user only. So you need to setup a different optimizer file for the Crystal Reports Server to use than the other disktops applications. To do this step up a seperate System DSN (see: How do I create or configure a QODBC DSN? ) and specify a fixed location of the optimizer database folder for Crystal Reports Server to use (like: C:\Program Files\QODBC Driver for QuickBooks) instead of the default %UserProfile% method.

To repair the optimized SalesOrder and Invoice table you can run:

SELECT * FROM SalesOrder VERIFY WHERE TxnID = 'x'

and then:

SELECT * FROM Invoice VERIFY WHERE TxnID = 'x'

Tom

Thanks for the information, one question, can  I run the Select Verify statement in Multi User mode or does everyone have to be out of the system.

Glen

Tom

I set up new System DSN and set up the Optimizer, ran the Select statements and still I get no SalesOrder or Invoice data. When I use the Desktop Driver, I get the SalesOrder and Invoice data without a problem.

Is there anything else I can try, because I really need to get this Crystal Server up and running. The reports do work for list data, so I know Crystal Server works.

Thanks for your support

Glen

Using Crystal Reports Server please try the following query statements using Add Command:

select * from Invoice unoptimized where TxnDate >= {d'2007-10-01'}

and if you get results, do:

select * from Invoice verify where TxnDate >= {d'2007-10-01'}

and then try:

select * from Invoice where TxnDate >= {d'2007-10-01'}

on its own.

Tom

I got data with the Select Unoptimized statement, but nothing with the oter two statements. I did see that the OPT file grow to 41,000KB, and there was a Journal file, but it was not there at the end of the process.

Glen

I still can't get Invoice or SalesOrder data with the Server Edition driver? where do I go from here?

Glen

Tom

I noticed when I perform the Select Statement for Invoice or SalesOrder, Quickbooks shows Not Responding in Task Monitor.

Glen

Tom

When I run the report using Crystal Report Designer and trying to read Invoice or SalesOrder I get no data. And Crystal reports after running for a long time, show it is not responding in Task monitor. But using the desk top Qodbc Driver, I get the data without any problem.

Glen

Tom

Do you have anymore suggestions? I have tried everything, but I still can't get Sales Order or Invoice data.

Glen

Tom

Yes, the Workstation Edition is on a Desktop and it works great, but the Server Edition running Crystal server on a 2003 Windows server setup the way you showed in your last reply, I still can;t get Salesorder or Invoice data.

Glen

Tom

I had it set it up according to the Document, and it still is not working. I am getting the following errors from DCOM.

Event Type: Error
Event Source: Application Hang
Event Category: (101)
Event ID: 1002
Date:  1/3/2008
Time:  11:06:24 AM
User:  N/A
Computer: NMC-CRYSTAL
Description:
Hanging application crw32.exe, version 11.0.0.1282, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

Event Type: Error
Event Source: SideBySide
Event Category: None
Event ID: 32
Date:  1/3/2008
Time:  10:59:38 AM
User:  N/A
Computer: NMC-CRYSTAL
Description:
Dependent Assembly Microsoft.VC80.MFCLOC could not be found and Last Error was The referenced assembly is not installed on your system.

Event Type: Error
Event Source: SideBySide
Event Category: None
Event ID: 59
Date:  1/3/2008
Time:  10:59:38 AM
User:  N/A
Computer: NMC-CRYSTAL
Description:
Resolve Partial Assembly failed for Microsoft.VC80.MFCLOC. Reference error message: The referenced assembly is not installed on your system.

Event Type: Error
Event Source: SideBySide
Event Category: None
Event ID: 59
Date:  1/3/2008
Time:  10:59:38 AM
User:  N/A
Computer: NMC-CRYSTAL
Description:
Generate Activation Context failed for C:\WINDOWS\WinSxS\x86_Microsoft.VC80.MFC_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_DEC6DDD2\MFC80.DLL. Reference error message: The referenced assembly is not installed on your system.
.

Where do I go from here.

Thanks

Glen

You can check whether your DCOMs are working by using qbcust.asp found in How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? Once that works you can try the Crystal Reports Server again.

Tom

I checked out the Latest reply and Document and I still can't read SalesOrder or Invoice data. Is there any way I could get live help, beacuse this issue has been going on for over a month. Like I stated before I am an Application consultant and not a systems consultant.

Thanks

Glen