I have been using QODBC Remote Connector with Server Edition 2007, version 7.00.00.214 successfully for a couple of months now. However, lately when I start the remote connector, several times, it prompts for username and password despite the fact that "Require Authentication" has always been unchecked.

Secondly, and this has always been a problem, whenever I run a query for the first time, it produces a "Timed Out" error. The second time around, which is usually within a couple of minutes, it runs just fine. Please help. Thank you.

That was earlier today; Now, displaySQL.cfm only produces this error:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.

VB Demo still connects.

ColdFusion runs queries as multiple treads, and the QODBC optimizer is single user only. So you need to setup a different optimizer file for ColdFusion 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 ColdFusion to use, like C:\Program Files\QODBC Driver for QuickBooks, instead of the default %UserProfile% method.

To repair the optimized customer table for ColdFusion you can run:

SELECT * FROM Customer VERIFY WHERE ListID = 'x'

Note: You may need to check the "Run 2.1 ODBC Compatibility" checkbox - Certain applications require ODBC 2.1 Compatibility to use QODBC. For example, anything that uses the Java ODBC library, like ColdFusion, requires this option turned on or recordsets will be returned with no rowsets or only 1 rowset.

See: Does QODBC work with Coldfusion? for more. DisplaySQL.cfm uses dataSource="QBs" which is the QuickBooks Data DSN. In order for this to work you must also configure the "QuickBooks Data" data source to auto-login to your company file as shown in: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

When using Windows 2003 Server you also need to check your "Enhanced Security Configuration for Internet Explorer" settings.

The Enhanced Security Configuration for Internet Explorer typically sets the IE security settings to "high", so QuickBooks throws a warning every time it starts, even for the SYSTEM service, which hangs QODBC while waiting for input.

I am not using the local browser (IE) on the server to browse to the pages. The browser is on a Windows XP machine. Here is the URL for you to check out: http://64.128.27.201/cva/qbcust.asp

Also the testDCOM is at: http://64.128.27.201/cva/testdcom.cfm

Ok, the connection is not happening:

oConnection.Open "QuickBooks Data"
response.write "QODBC DSN QuickBooks Data Open<BR>" & vbCrLf

So I'm guessing there's a error on the server that we're not seeing. Try running this on the server as localhost and look at the system logs.