Knowledgebase: Microsoft Products
[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 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 | |
|
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!
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
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