Troubleshooting - Auto Login as Service and Syncing tables to SQL Server
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.
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
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.
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
How to setup QODBC Driver to auto-connect to QuickBooks. (Video)
How to setup QODBC for Auto-login into QuickBooks