We're sorry, the page you requested was not found.

We have recorded this error (404) to help us fix the problem. You may wish to try again using one of the links below

• Home
• Frequently asked questions

Site Map

Products WinSQL Features/Benefits Compare Editions Cost System Requirements Upgrade Policy Supported Databases What's New Obtaining serial number WinSQL Vs JaySQL White Papers Online video tutorials WinSQL FAQ Knowledge base Version History JaySQL Product Page Feature Matrix Cost User's Guide Mail Junction Overview Features How does it work Screenshots Cost System requirements Download Xeams SynaMan 10MinutesWeb AboutMyX

Support Support Options Forums Email Telephone Other links Download Purchase using credit card Purchase orders Useful tools and utilties

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.