News Articles

Articles posted here are for the use of our clients to get quick self help answers to questions and simple solutions to problems. News reports are not necessarily the opion of our company but for reference only. We don't provide any guarantee that solutions posted or referenced will work for your situation and that you should use them at your own risk. None of the information posted should be used for illegal practices.

QuickBooks database server will not start - SQLANY 17.0 cannot be found

​Issues with the QuickBooks database server used to be a fairly rare occurrence. But since 2019, many of the servers running QuickBooks have been updated to new versions of the Windows Server OS and the QuickBooksDB##. The end user will typically get the following error when attempting to connect to the server in a multiuser setting. "Error Code: H...

Continue reading
7
15043 Hits
0 Comments

VMware vCenter Server Appliance with embedded database fails due to full database partition

vCenter Server Appliance with an embedded vPostgres database may stop running with out any warning. After logging into the web user interface (web UI) of the appliance you may notice that, in the Storage Usage on the Summary tab, the database statistics are showing 100%. Attempting to start the vCenter Server services at this point will result in the service running for a brief moment before is automatically shuts down again. This occurs because a disk partition on the vPostgres database contains no free space.

VMware doesn't have any recommended preventative maintenance tasks at this time but it doesn't hurt to establish your own in order to prevent this sort of issue in the first place. There is a retention policy for the database and we will look at why that may not be adequate for some installations.

Continue reading
0
6211 Hits
0 Comments

MySQL Import of SQL file fails with error 1064

On a number of occasions I have attempted to import an exported MySQL database file and received the following message.

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?# -------------------------------------------------------- # Host:     ' at line 1 */
/* Error with snippets directory: The specified path was not found */

# --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.5.40 - MySQL Community Server (GPL)
# Server OS:                    Win32
# HeidiSQL version:             7.0.0.4053
# Date/time:                    2014-01-20 09:48:36
# --------------------------------------------------------

Continue reading
0
4556 Hits
0 Comments

Are you in need of computer repair?

Start Here

Locations Serviced:

Firestone

Frederick

Dacono

Longmont

Fort Lupton

Erie

Mead

Berthod

Loveland

Windsor

Brighton

Denver

Boulder

Thornton

Westminster

Aurora

Arvada

Parker

Highland Ranch

Centenial

 

Have I been pwned?
Check if you have an account that has been compromised in a data breach.