Site Map

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
• 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 - 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
• 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
• 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 HTTP server to a specific IP address
• 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
• Multiple HTTP ports
• No shared folder found
• 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
• Trial for SynaMan Professional
• Uploading files containing foreign (unicode) characters
• Using SSL certificate with SynaMan or Syncrify
• Using SynaMan with Microsoft IIS server
• Viewing existing public links

SyncrifyKB

• Branding Syncrify
• Browsing files on the server
• Connecting to Syncrify as a normal user
• Connecting to Syncrify as administrator
• Enabling SSL in Syncrify
• How to configure firewall on Windows 7
• Installing Syncrify client on Windows OS
• Installing Syncrify on other operating systems
• Moving Syncrify server from one machine to another
• Restoring backed up files from one machine to a different
• Running Syncrify on FreeNAS with BSD
• Seeding initial backups in Syncrify
• Specifying a mapped drive for backup repository
• Specifying selection filter in Syncrify
• Steps for disaster recovery using Syncrify
• Syncrify client appears hung when transferring large files
• Tips on creating multiple copies of the same files
• Updating Syncrify client
• Using Syncrify client from command line
• Using encryption in Syncrify

Troubleshooting

• SynaMan/Syncrify won't start on Ubuntu/Debian after reboot
• Syncrify client connects to the server but generates errors when running backup
• Syncrify won't start after applying HTTPS certificate
• Troubleshooting startup problems for Syncrify client
• Viewing log files in Syncrify