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

• 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 Internet and your local network
• Downloading multiple files together
• Dynamic IP address discovery wizard
• Enabling SSL for SynaMan
• 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
• Backup or restore a selective folder
• 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
• 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
• Delete retention period on Syncrify server
• Email Options in Syncrify
• Enabling SSL in Syncrify
• Forcefully terminating Syncrify after some time
• How to configure firewall on Windows 7
• How to upgrade Syncrify server and client to the latest version
• Importance of bandwidth usage in Syncrify
• 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
• Moving Syncrify server from one machine to another
• Repository path exceptions in Syncrify
• Restoring backed up files from one machine to a different
• Running Syncrify on FreeNAS with BSD
• 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 selection filter in Syncrify
• Starting and stopping Syncrify server
• Steps for disaster recovery using Syncrify
• Steps for scheduling backup on Linux/UNIX using cron
• 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
• 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

• Cannot login after installing Syncrify
• I get a JVM_Bind error when starting the web server
• I get a message 'Unable to lock profile' when running a backup
• Scheduler button does not work on Windows 7
• SynaMan/Syncrify won't start on Ubuntu/Debian after reboot
• Syncrify client connects to the server but generates errors when running backup
• 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
• What is Invalid Job ID error
• Why do I get a warning in my browser after enabling SSL