Following is a list of articles that resides in Synametrics' Knowledge base.

KnowledgeBase

• I get a virus warning when trying to download WinSQL

SynaManKB

• Accessing files on Azure via SynaMan
• Adding notes to any file
• Additional User Information in Public Links
• Alternative to WeTransfer
• Audit trail Logging
• Binding SynaMan HTTP server to a specific IP address
• CJIS Compliant File Sharing Solution
• Changing email template for public links
• Changing the location for Temp folder in SynaMan
• Changing the subject line for public links in SynaMan
• Creating public links
• Creating user accounts
• Cross Site Request Forgery in SynaMan
• Delegate Authentication in SynaMan's Embedded SMTP Server
• Difference between AJAX and Enhanced browser
• Difference between Internet and your local network
• Disabling auto-update in SynaMan
• Downloading multiple files together
• Dynamic IP address discovery wizard
• Enabling SSL for SynaMan
• Enforcing password policy in SynaMan
• Enhanced Browser in SynaMan
• Friendly IP Addresses in SynaMan and Syncrify
• Hiding forgot password link
• Home Folder in SynaMan
• How to enable Forward Secrecy for SynaMan/Syncrify
• How to force users to change their passwords periodically in SynaMan
• How to send large attachments via Email
• Integrating SynaMan With IIS 7
• Integrating SynaMan with Apache mod_proxy
• Login URL's
• Manually downloading a newer version and applying the patch
• Mapped drives in SynaMan
• Moving SynaMan from to a different machine
• Multiple HTTP ports
• No shared folder found
• Partial Branding in SynaMan
• Preventing users from changing their passwords
• Previewing files on a host machine
• Privacy concerns when sharing files on the cloud/Internet
• SMTP server for SynaMan
• Send Uploaded Files Directly to Printer
• Shared folders
• Shared public folders in SynaMan
• Specifying a custom host name for public links
• Starting and stopping SynaMan
• SynaMan FINRA Compliance
• SynaMan HIPAA Checklist
• Template user in SynaMan
• Tips on using SynaMan on a home/small office computer
• Total branding in SynaMan
• Trial for SynaMan Professional
• Uploading files containing foreign (unicode) characters
• Using SSL certificate with SynaMan or Syncrify
• Using SynaMan with Microsoft IIS server
• Using an SSL certificate for IIS in SynaMan
• Viewing existing public links
• Why are PUT and DELETE methods in HTTP server are enabled

Troubleshooting SynaMan

• Troubleshooting email problems
• You get a 404 error related to GWT in SynaMan

SyncrifyKB

• Aborting backups in Syncrify
• Accessing a NAS/Linux disk from Windows using UNC path and without password
• Accessing profile file from the server
• Backing up MDB and LDB files in MS SQL Server
• Backing up Syncrify itself
• Backing up Syncrify server
• Backup or restore a selected folder
• Bandwidth throttling while performing backups in Syncrify
• Bare Metal Backup on Windows
• Binding Syncrify HTTP server to a specific IP address
• Branding Syncrify Client
• Branding Syncrify Server
• Branding prior to version 2.4
• Browsing files on the server
• CPU utilization when using Syncrify
• Can I use Syncrify to backup to a local drive on the machine
• Change file location on Syncrify Server using junction points on Windows
• Changing default chunk size
• Changing the location of the temp folder in Syncrify
• Changing the path for Data Folder in Syncrify
• Chunk, merge, and temp files in Syncrify
• Connecting to Syncrify as a normal user
• Connecting to Syncrify as administrator
• Creating custom reports in Syncrify
• Cross-site request forgery in Syncrify
• Delete retention period on Syncrify server
• Difference between Daily and Interval backup
• Disabling server-to-client direction
• Effects of Anti-Virus software when running file synchronization in Syncrify
• Email Options in Syncrify
• Enabling SSL in Syncrify
• Encrypting user passwords when using an RDBMS
• File Interruption Scenarios
• Forcefully terminating Syncrify after some time
• Forcing clients to use a selection filters from server
• Guideline for modifying/deleting files from the server
• How to configure firewall on Windows 7
• How to upgrade Syncrify server and client to the latest version
• Importance of bandwidth usage in Syncrify
• Incorrect time on Syncrify Server
• Increasing the maximum memory used by Syncrify Server
• Installing Syncrify client on Windows OS
• Installing Syncrify on FreeNAS
• Installing Syncrify on other operating systems
• Integrating Syncrify with a NAS device
• Leading and trailing spaces in files and folder names on Mac and Linux
• Logging backup events to Windows Event Viewer
• Maintaining multiple versions of a backed up file
• Manually creating a schedule task in Windows
• Manually restoring files from Syncrify Server
• Manually upgrading Syncrify to the latest version
• Modifying repository path for a user
• Modifying rsync's block size in Syncrify
• Monitoring Syncrify Client
• Moving Syncrify server
• Plugin for MS SQL Server - Backing up MS SQL Server to a remote machine
• Plugin for MySQL database
• Privacy and security concerns when backing up important data
• Register Syncrify While Offline
• Rename Syncrify Client Profiles
• Repository path exceptions in Syncrify
• Resolving permission problems in Syncrify Client
• Restoring backed up files from one machine to a different
• Running Syncrify Client as root on Mac OS X
• Running Syncrify inside a closed network
• Scalability guide for running backups
• Scheduling backups under a different user account
• Searching files in Syncrify using the web interface
• Seeding initial backups in Syncrify
• Selective synchronization from the server side
• Specifying a mapped drive for backup repository
• Specifying backup direction in Syncrify
• Specifying multiple host names in Syncrify client
• Specifying selection filter in Syncrify
• Starting and stopping Syncrify server
• Steps for disaster recovery using Syncrify
• Steps for scheduling backup on Linux/UNIX using cron
• Switching from Integrated client to service based client
• Syncrify Anti-Virus and Firewall Packet Inspection
• Syncrify Client Catalina Permission Issues
• Syncrify HIPAA Checklist
• Syncrify Profile File - Explained
• Syncrify Two-Factor Authentication
• Syncrify backup job hooks
• Syncrify client appears hung when transferring large files
• Time difference between files on client and server
• Timezone synchronization in Syncrify
• Tips for backing up relational databases with Syncrify
• Tips on creating multiple copies of the same files
• Tips on running backup containing many files
• Updating Syncrify client
• Use of temporary files in Syncrify
• Using Office365 as the SMTP server for Syncrify, SynaMan
• Using Syncrify client from command line
• Using Syncrify client from console without GUI
• Using Windows Task Scheduler blank password
• Using an SSL certificate for IIS in Syncrify
• Using encryption in Syncrify
• Using folder cache in Syncrify
• Using foreign characters as top level folders
• Using mapped or remote drive with Syncrify client
• What does compress data mean
• What is Syncrify Data Folder
• What is a top level folder?
• Why do backing up VHD files take long
• Why is adding a root folder not a good idea

Troubleshooting

• Backups are taking long time, what can I do?
• Backups work manually but not when scheduled
• Cannot login after installing Syncrify
• Error while upgrading - MD5 signature does not match
• Fixing permission denied problem during SQL server backup
• How to fix No space left on device error
• I get a JVM_Bind error when starting the web server
• I get a message 'Unable to lock profile' when running a backup
• I ran out of disk space and now Syncrify won't start
• Job put on hold
• No files are copied even if some where modified
• OST files are not included in backup
• Running Syncrify Client on Windows XP and 2003
• Scheduler button does not work on Windows 7
• Settings won't save for a profile
• SynaMan/Syncrify won't start on Ubuntu/Debian after reboot
• Syncrify client connects to the server but generates errors when running backup
• Syncrify client does not upgrade automatically
• Syncrify creates empty folders with no files in them
• Syncrify server keeps asking for registration
• Syncrify shutdown after a few minutes due to invalid license
• Syncrify won't start after applying HTTPS certificate
• Troubleshooting Email Related Problems in Syncrify
• Troubleshooting a Syncrify Backup Job that Appears Stuck
• Troubleshooting common problems when running Syncrify Client on Linux
• Troubleshooting problems with bare metal backups
• Troubleshooting restarting problems with Syncrify
• Troubleshooting startup problems for Syncrify client
• Users disappeared in Syncrify
• Users get locked out because Syncrify/SynaMan would not accept password
• Using telnet to troubleshoot
• Viewing log files in Syncrify
• Volume shadow copy error 80042316 - Failed to start snapshot
• What does EOF reached error mean
• What is Invalid Job ID error
• Why do I get a warning in my browser after enabling SSL
• Why do I see my router's IP address in every log?

Syncrify How to

• Customizing password reset page
• Daisy Chain Backup
• Extending user authentication mechanism in Syncrify
• How to add custom headers in HTTP response
• How to backup Microsoft Exchange Mailbox - step by step instructions
• How to install Syncrify Client without the installer
• How to mimic functionality exposed by DropBox, Google Drive, SkyDrive and others with Syncrify
• How to restore files in Syncrify
• How to share one RDBMS with two instances of Syncrify Server
• Running Syncrify on Synology NAS
• Syncrify Client Email Reports with Custom Subject

WinSQLKB

• A SQL query/designer tool for Mimer
• Automatically Saving Sessions in WinSQL
• Best Way Get Support For WinSQL
• Connecting to Google BigQuery with ODBC
• Connecting to InterSystems IRIS SQL with ODBC
• Copying and pasting data from a result grid in WinSQL
• HiddenTreasures2
• Is WinSQL Lite really free?
• Special Comments in WinSQL
• Troubleshooting Salesforce connection using ODBC

Informix

• IBM Informix Driver crashes when calling SQLGetInfo method

IBM DB2

• I don't see any tables in the catalog window when connecting to DB2
• No row was found for FETCH, UPDATE or DELETE
• Problems getting DB2 catalog information after applying 8.1 fixpack 10 or higher
• SQL30082N Attempt to establish connection failed with security reason
• Transferring, migrating, exporting data from MySQL to IBM DB2
• Use period instead of a comma when displaying decimals in DB2

Ingres

• I don't see tables starting with SYS in WinSQL

MS Access

• Cross joining multiple databases in MS Access
• How do I connect to a database created with MS Access 2007
• Insert data into text files from MS Access
• Referential integrity constraints in MS Access
• Transactions in MS Access
• Using comments in MS Access
• Writing default values in Create Table statement
• Writing queries including dates in MS Access

MS Excel

• How to query data in MS Excel file with ODBC

MS SQL Server

• Configuring SQL Server Express to use TCP/IP for remote connections with ODBC
• Deleting duplicate rows with no primary key
• Inserting XML files in database tables.

MySQL

• I see views as tables when connecting to MySQL. How can I fix this?
• Connecting to MySQL using ODBC
• Increasing connection limit in MySQL
• TEXT column display ASCII code in MySQL instead of actual value
• Transferring, migrating, exporting data from MySQL to Oracle
• Why do I lose connection to MySQL after some time?

Netezza

• Tables appears to be owned by ADMIN in Netezza
• Transferring, migrating, exporting data from Netezza to MS SQL Server
• Transferring, migrating, exporting data from Netezza to Oracle
• Transferring, migrating, importing data from DB2 to Netezza
• Where can I download an ODBC driver for Netezza

Oracle

• How can I change the decimal separator from a dot to a comma?
• How to kill/terminate a session in Oracle
• Retrieving the Top-N or Bottom-N Rows from a SQL Table
• Setting default schema in Oracle
• TNS: Could not resolve service name - What does this mean?
• Transferring, migrating, exporting data from Oracle to Sybase
• Transferring, migrating, exporting data from Teradata to Oracle
• Using functions in DBMS_OUTPUT package in ODBC
• Using timestamp data type in Oracle
• What are Pseudo-columns in Oracle
• What is a deadlock and how does oracle handle it?
• What is a materialized view in Oracle

Pervasive

• Where can I get an ODBC driver for Pervasive?

PostgreSQL

• Connecting to PostgreSQL using ODBC
• Where can I download a PostgreSQL driver?

SQL Tips

• Example of using OUTER JOINS
• Find the nth Maximum and Minimum Values in a Given Column
• Formatting date fields in resultset
• List of ODBC drivers and vendors
• Padding leading zeros to an integer
• Quering tables with spaces in their names
• Using HAVING clause in SQL

Sales Questions

• Is it secure to give my credit card details over the Internet?
• Different payment options when purchasing
• Do I have to pay a fee to upgrade my previous versions of WinSQL to the latest version?
• How can I get invoice for my order?
• I paid with a credit card, how soon will I get the software?
• Shipping charges when ordering WinSQL
• What exactly will I receive with my order?

Installation

• Connecting to Firebird using ODBC
• Deploying in Citrix or Terminal Server environment
• Installation requirements for WinSQL
• Moving WinSQL from one machine to another
• Silent Install for WinSQL
• Uninstalling WinSQL
• Using WinSQL without installer - raw files
• WinSQL on USB drive
• WinSQL's Compatiblity with Vista and Windows 7

Registration

• How do I get a serial number for WinSQL Lite
• Serial number does not work
• What happens once your trial period is over?
• What is ODBC registration and how do I register the ODBC drivers
• WinSQL Standard runs in trial mode

Usage

• Application hangs when I press the Cancel button in WinSQL
• Can I compare schema between two different types of databases?
• Can I modify the SQL keywords in the editor?
• Changing the title of a tab in the resultset?
• Converting from one data type to another in ODBC
• Customizing keyboard shortcuts
• Error 126 when connecting to database
• Fetching database catalog - takes very long
• Finding version and release date of an ODBC driver
• Generating ODBC trace log
• Guide to running a SQL query and send the results via email to MS Excel or a text file
• How can I change the behavior of the editor
• How to take a screen shot of any window
• I don't see my datasources in WinSQL
• I get the following error when importing a databag. Error: Data type for parameter 1 has changed since first SQLExecute call
• Limiting WinSQL to SELECT queries
• ODBC Manager button does not work on Windows 7
• ODBC driver bug related to table columns
• Passing a connection string from command line?
• Running WinSQL in debug mode
• Running scheduled queries to a different output file
• SQL Explain is greyed out
• Task 'No name' ran successfully - why do I see this as email subject
• Testing network connectivity from one machine to another
• The application was unable to start correctly (0xc0000005)
• Transactions in a relational database
• Troubleshooting problems executing scheduled tasks
• Using ODBC connection string to establish connection
• Using ODBC Escape Clause in your SQL syntax
• Using WinSQL on a 64-bit OS
• Using command line arguments to run SQL queries
• Viewing multi-line results in a grid control (Zoom)
• What functions does WinSQL support?
• What is EditorSettings45.cfg file?
• What is WinSQL Data Folder
• What is a query terminator
• WinSQL pauses for a long time while writing SQL queries
• WinSQL runs as an invisible window - only appears in the task bar.