Knowledgebase
[QODBC-Desktop] How to use QRemote with ColdFusion
Posted by Jack - QODBC Support on 28 October 2016 12:25 PM

How to use QRemote with ColdFusion

Instructions about using QRemote with ColdFusion

   Using ColdFusion on an internal Intranet or the World Wide Web requires the Server Edition of QODBC. QuickBooks must be running with the company file opened on the system console.

     The first thing is to configure the QRemote Server.

Please refer: To how to configure QRemote.

 

ColdFusion Data Source Setup Instructions

      Run the ColdFusion Administrator. Enter your username & password & login.

Under DATA & SERVICES, choose Data Sources.

Use "QBs" as the Data Source name to match the DisplaySQL.cfm sample script below. The Driver is ODBC Socket. Press the Add button.

 

      QuickBooks Data QRemote is a DSN that is created by the QODBC installation. Under ODBC DSN, choose a QuickBooks DSN. The username should be set to Admin. You can put any notes you want in the description field.

      Next, Press the Show Advanced Settings Button.

      Make sure the Limit Connections and Maintain Connections are unchecked. You can remove the Create, Drop, Alter, Grant and Revoke checkboxes. Add checkboxes for Select, Insert, Update, Delete, and Stored Procedures.

      Press Submit, and your QODBC Data Source should appear on the Data Sources list.

      DisplaySQL.cfm uses dataSource="QBs," which is the QuickBooks Data QRemote DSN.

Sample Code:

<cfscript>
queryObj = new query();
queryObj.setDatasource("QBs");
queryObj.setName("qListOfArts");
result = queryObj.execute(sql="SELECT Top 10 ListId, Name, FullName,Phone from customer");
qListOfArts = result.getResult();
metaInfo = result.getPrefix();
queryObj.clearParams();
writeDump(qListOfArts);
writeDump(metaInfo);
</cfscript>

Download Sample

      To run this, Place this file under "CFIDE" & run it through the browser.

      The query result is shown above.

Keywords: PHP, IIS, ColdFusion, can it work with PHP, service-based application

(0 vote(s))
Helpful
Not helpful

Comments (2)
Azeem Iqbal
13 March 2018 05:31 PM
I have followed the exact instructions for this setup and I am getting the following error in CFAdmin

Connection verification failed for data source: QBITS
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application

I am testing this on CF11 running on on Windows 10.

Any help would be much appreciated.

Jack
14 March 2018 06:25 AM
Hi Azeem,

I think your ColdFusion is of 64-bit. If your ColdFusion is 64-bit, You need to use 64-bit QRemote DSN "QuickBooks Data 64-Bit QRemote" in your report & test again.

Please refer below mentioned article for the Architecture mismatch issue:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2439/0/qodbc-reports-architecture-mismatch-problem-when-connecting

If you are still the facing issue, Please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, Please attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Refer: How to take screenshot: www.qodbc.com/links/screenshot.htm
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).