Difference between revisions of "Quickbooks Database Server Manager"
(Created page with "Quickbooks Database Server Manager by Intuit, supposedly also runs on GNU\Linux. I've spent some 10-20 hours trying to get it to work (with limited success) and here's what I...") |
|||
| Line 1: | Line 1: | ||
| − | Quickbooks Database Server Manager by Intuit, supposedly also runs on GNU\Linux. I've spent some 10-20 hours trying to get it to work (with limited success) and here's what I know. | + | Quickbooks Database Server Manager by Intuit, supposedly also runs on GNU\Linux. I've spent some 10-20 hours trying to get it to work (with limited success) and here's what I know. This program supports QB Enterprise clients only (I have read). |
==Overview== | ==Overview== | ||
| Line 8: | Line 8: | ||
The program is offered in an RPM format. It is possible to convert the RPM to a .DEB and install it on Debian. However there are integrated commands that will fail (a ps -efff which searches the task list for the port and ip of qbdbmgr), so its best run in RHEL. The program is a pair of 32 bit binaries, so it's either run in 32 bit or you can install 32-bit compatibility libraries in 64-bit mode. | The program is offered in an RPM format. It is possible to convert the RPM to a .DEB and install it on Debian. However there are integrated commands that will fail (a ps -efff which searches the task list for the port and ip of qbdbmgr), so its best run in RHEL. The program is a pair of 32 bit binaries, so it's either run in 32 bit or you can install 32-bit compatibility libraries in 64-bit mode. | ||
| + | |||
| + | The RPM will unpack two main directories. in /opt it will put two folders for the binaries. In /etc, it will put an init.d script, and a logrotate.d script. There are also configuration files in /opt/. Additionally, the .qbw.TLD, .qbw.DSN, files | ||
| + | |||
| + | |||
| Line 14: | Line 18: | ||
===Using Sybase tools to discover QB databases=== | ===Using Sybase tools to discover QB databases=== | ||
Yes, it is possible to use Sybase tools to discover QB DBs hosted by GNU\Linux on the LAN. You should also technically be able to connect, though I'm not sure what QB uses for credentials. | Yes, it is possible to use Sybase tools to discover QB DBs hosted by GNU\Linux on the LAN. You should also technically be able to connect, though I'm not sure what QB uses for credentials. | ||
| + | |||
| + | e.g. Sybase Central 6, has a Connect with Sql Anywhere 12 option. | ||
{{GNU\Linux}} | {{GNU\Linux}} | ||
Revision as of 07:53, 11 December 2019
Quickbooks Database Server Manager by Intuit, supposedly also runs on GNU\Linux. I've spent some 10-20 hours trying to get it to work (with limited success) and here's what I know. This program supports QB Enterprise clients only (I have read).
Overview
What QB Database server manager for Unix is, is Sybase SQL Anywhere. It appears to be tailored to Quickbooks. There are two programs:
- qbfilemonitord
- qbdbmgr_##
The number refers to your edition of QB. 2014, uses QBDBMGR_24.
The program is offered in an RPM format. It is possible to convert the RPM to a .DEB and install it on Debian. However there are integrated commands that will fail (a ps -efff which searches the task list for the port and ip of qbdbmgr), so its best run in RHEL. The program is a pair of 32 bit binaries, so it's either run in 32 bit or you can install 32-bit compatibility libraries in 64-bit mode.
The RPM will unpack two main directories. in /opt it will put two folders for the binaries. In /etc, it will put an init.d script, and a logrotate.d script. There are also configuration files in /opt/. Additionally, the .qbw.TLD, .qbw.DSN, files
Tips/Tricks
Using Sybase tools to discover QB databases
Yes, it is possible to use Sybase tools to discover QB DBs hosted by GNU\Linux on the LAN. You should also technically be able to connect, though I'm not sure what QB uses for credentials.
e.g. Sybase Central 6, has a Connect with Sql Anywhere 12 option.
| ||||||||||||||||||
