Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - Auto Login as Service and Syncing tables to SQL Server
Posted by Jack - QODBC Support on 11 January 2016 02:02 PM

Troubleshooting - Auto Login as Service and Syncing tables to SQL Server

Problem Description:

So the QODBC works great running on the machine. We have the intent to integrate into our website / Intranet to create customers or make changes from the web. I noticed QuickBooks needs to be logged in and open to function. Is there a server version that will not need to have a user logged in or passes the info along automatically so the website continues to function correctly?

Is there a way to try the server version with syncing to SQL server? I need to be able to dump the customer table once daily to SQL. Maybe other tables in the future like orders or quotes. Does the server version need to have a remote desktop session open in order to work? If the server reboots because of an update I need to login to make it work again. That doesn’t seem very feasible for us.
 

Solution:

QODBC is not a driver that you would install on a server and multiple workstations would have access to it. The server version of QODBC is for synchronizing SQL Server with QuickBooks data or for a web or intranet application.

>>Is there a server version that will not need to have a user logged in or passes the info along automatically so the website continues to function correctly?
>>Does the server version need to have a remote desktop session open in order to work?

Please refer: How to Setup QODBC to Access QuickBooks when There is no-one Logged in

OR

You may configure a session-0, to automatically start and starts QuickBooks, QRemoteServer.
When you configure session-0, means you are setting up auto login of a user and that user will have a desktop session running.

>>Is there a way to try the server version with syncing to SQL server?

You can use Linked Server on SQL Server and connect to QuickBooks Data using QRemote. When you query Linked Server/tables you will always get live QuickBooks Data.

For dump of All the tables or selected tables from QODBC to Tables in SQL Server Database, You may write a script to create the table(s) in SQL Server and Get data from the linked server.

e.g.
SELECT * into LocalSQLTableName FROM OPENQUERY(YourLinkedServerName, 'SELECT * FROM LinkedTableName')

SELECT * into tblVendor FROM OPENQUERY(QRemote, 'SELECT * FROM Vendor')

You can add the script to the agent to run periodically.

Please refer below mentioned article for How to create Link Server with MS SQL 2005/2008/2012 Using QODBC/QRemote

For 32-bit SQL Server refer:
How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote

For 64-bit SQL Server refer:
How to create Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote


Also, Refer:
How to setup QODBC Driver to auto-connect to QuickBooks. (Video)
How to setup QODBC for Auto-login into QuickBooks




(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).