I am trying to get QODBC working with QBES 9 installed in terminal services mode on Windows Server 2008 64.

I have written a web service that makes an ODBCConnection to the "QuickBooks Data" DSN.  This works fine on my other servers, but it is not working on WS 2008.  I have configured IIS 7 to run its application pools in 32 bit mode, so I am able to consume the 32 bit QODBC driver.  I am trapping ODBC errors in the web service code, and am unable to catch any. The web service just hangs.  No SDK log entries are created.  VBDemo works OK, but only with DCOM servers NOT enabled.  When DCOM servers are enabled, VBDemo errors out: "DCOM Servers must be enabled when using Server Edition".

I have NOT installed the standard ASP role in IIS 7, but have installed .NET and the features neccessary to run web services.  Shall I also install the standard ASP role, since the DCOM configuration requires the ASPNET user to have custom permissions?

I have followed the instructions for manually configuring DCOM servers on Windows Server 2003, and modified them to fit my environment:

WS 2003 User                   WS 2008 User Equivalent??

ASPNET                              Network Service

IUSR_Machine                   IIS_USRS

Has anyone else tried to get this working in the following environment?

If VBDemo works, can't I just write an application that utilizies the same model?  If so, could I obtain the source for VBDemo?

Thanks, Mike

QODBC runs just fine on a 64 bit OS because it runs as 32 bit via WOW64.  I have integrated the driver with a company file and VBDemo runs fine.  The issue seems to be getting DCOM to work.  When DCOM servers are enabled, VBDemo breaks and my ODBCConnection.Open() hangs.

If VBDemo works, I am certain that I can write my own application.  Do you have any more advice other than "NOT SUPPORTED"?  Is anyone familiar with how VBDemo is written?

-- Mike

Sorry in order to support QODBC on 64 bit operating systems will need to be able to support the whole product, not just VBDemo. At this stage no support is available for 64 bit operating systems.

If you still want the source of VB Demo, you can look at the generic version:

 

Visual Basic ODBC Demo Program 32 bit Source Code (35k)