Knowledgebase
[QODBC-ALL] How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video)
Posted by Rajendra Dewani (QODBC Support) on 22 September 2013 11:07 AM

 

How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video)

 

Download the sample code: Click Here

 

Also, refer to 
Sample C#.NET Web Application for Inserting InvoiceLine to existing Invoice

Sample Code for Inserting InvoiceLine to existing Invoice using PHP

 

Keywords: sample .net, sample, .net, Dot Net, C#,C#.Net, ASP.NET, Web Server, IIS, C#.NET

(0 vote(s))
Helpful
Not helpful

Comments (2)
Anna P.
30 December 2014 07:55 PM
Thank you for the video!
Can you please clarify: why is it necessary to use QRemote with 32bit application, why can't we use QODBC driver right away?
Thanks!
Jack
15 September 2017 03:03 PM
Hi Anna,

IIS Web Server is a service-based application.

When you run a web application in IIS Web Server the process is executed as a Windows services.

IIS Web Server service (Windows services) runs in the context of a SYSTEM account.

Visual Studio is the desktop-based application.

When you run the same web application in Visual Studio the process is executed in a Normal Desktop User Context.

Windows services are prevented from communicating with desktop applications like QuickBooks and QODBC.

QRemote works as a bridge between remote applications and the QODBC Driver by communicating data calls between the two worlds using TCP/IP (Internet) protocol.

So, to communicate with the service-based application, you need to use QRemote Server.
Please refer below-mentioned link for How to use QRemote:
http://qodbc.com/links/2483

IIS Web Server
You need to use "QuickBooks Data QRemote" QRemote data source name (DSN) for 32-bit IIS Server - Application Pool
& "QuickBooks Data 64-Bit QRemote" " QRemote data source name (DSN) for 64-bit IIS Server - Application Pool

For Desktop-based 32-Bit Applications, you can use "QuickBooks Data" - QODBC Driver and there is no need to use QRemote unless you are using QuickBooks Data Remotely.

Please refer below-mentioned link for Accessing QuickBooks Data Remotely using QODBC & QRemote:
http://qodbc.com/links/2517

For Desktop based 64-Bit Applications, you need to use QRemote Server.

Please refer below-mentioned link for How to Configure QODBC to Work With 64-bit Applications:
http://qodbc.com/links/2436

Also, Refer.

How to Identify if the application is 32-bit or 64-bit:
http://qodbc.com/links/2677
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).