Troubleshooting - Auto Login as Service and Syncing tables to SQL Server
So the QODBC works excellently running on the machine. We intend 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 require a user to log in or passes the info along automatically, so the website continues to function correctly?
Is there a way to try the server version by syncing to the SQL server? I need to be able to dump the customer table once daily into SQL. Maybe other tables in the future, like orders or quotes. Does the server version need a remote desktop session open to work? If the server reboots because of an update, I need to log in to make it work again. That doesn’t seem very feasible for us.
QODBC is not a driver you would install on a server; 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 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 to work?
Please refer: To how to Setup QODBC to Access QuickBooks when no one Logged in.
You may configure a session-0 to start and starts QuickBooks and QRemoteServer automatically.
When you configure session-0, you are setting up the auto login of a user, and that user will have a desktop session running.
>>Is there a way to try the server version by syncing to the 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 to the below-mentioned article for How to create a Link Server with MS SQL 2005/2008/2012 Using QODBC/QRemote.
For 32-bit SQL Server, refer to:
How to create a Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote
For 64-bit SQL Server, refer to:
How to create a Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote
How to set up QODBC Driver to auto-connect to QuickBooks. (Video)
How to setup QODBC for Auto-login into QuickBooks