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

• Is WinSQL Lite really free?

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
• 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 need Form W-9 for my accounting department, where can I get it?
• 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?

WinSQL - Installation

• 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

WinSQL - 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 Developer runs in trial mode

WinSQL - 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
• 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.

Firebird

• Connecting to Firebird using ODBC

SynaManKB

• Adding notes to any file
• Audit trail Logging
• Binding SynaMan HTTP server to a specific IP address
• Changing the subject line for public links in SynaMan
• Creating public links
• Creating user accounts
• 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
• Home Folder in SynaMan
• Integrating SynaMan With IIS 7
• Integrating SynaMan with Apache mod_proxy
• Manually downloading a newer version and applying the patch
• Mapped drives in SynaMan
• Multiple HTTP ports
• No shared folder found
• Partial Branding in SynaMan
• Previewing files on a host machine
• SMTP server for SynaMan
• Shared folders
• Shared public folders in SynaMan
• Specifying a custom host name for public links
• Starting and stopping 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

SyncrifyKB

• Accessing a NAS/Linux disk from Windows using UNC path and without password
• Accessing profile file from the server
• Backing up Syncrify server
• Backup or restore a selective folder
• Bandwidth throttling while performing backups in Syncrify
• 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
• 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 and temp files in Syncrify
• Connecting to Syncrify as a normal user
• Connecting to Syncrify as administrator
• Contact support for technical questions about Syncrify
• Creating custom reports in Syncrify
• Delete retention period on Syncrify server
• Disabling server-to-client direction
• Email Options in Syncrify
• Enabling SSL in Syncrify
• Encrypting user passwords when using an RDBMS
• 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
• Increasing the maximum memory used by Syncrify Server
• Installing Syncrify client on Windows OS
• Installing Syncrify on other operating systems
• Integrating Syncrify with a NAS device
• Maintaining multiple versions of a backed up file
• Manually creating a schedule task in Windows
• Manually upgrading Syncrify to the latest version
• Modifying repository path for a user
• Monitoring Syncrify Client
• Moving Syncrify server from one machine to another
• 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
• Repository path exceptions in Syncrify
• Restoring backed up files from one machine to a different
• Running Syncrify on FreeNAS with BSD
• Scalability guide for running backups
• Scheduling backups under a different user account
• Seeding initial backups in Syncrify
• 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 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 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 is adding a root folder not a good idea

Troubleshooting

• Backups are taking long time, what can I do?
• Cannot login after installing Syncrify
• Error while upgrading - MD5 signature does not match
• Fixing permission denied problem during SQL server backup
• I get a JVM_Bind error when starting the web server
• I get a message 'Unable to lock profile' when running a backup
• OST files are not included in backup
• 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 server keeps asking for registration
• Syncrify won't start after applying HTTPS certificate
• Troubleshooting startup problems for Syncrify client
• 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

Syncrify How to

• Customizing password reset page
• 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 synchronize files across multiple machines
• Syncrify Client Email Reports with Custom Subject