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

• 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
• Why do I lose connection to MySQL after some time?

Netezza

• Tables appears to be owned by ADMIN in 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?
• Using functions in DBMS_OUTPUT package in ODBC
• 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

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
• 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
• SQL Explain is greyed out
• 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 a query terminator
• Where does WinSQL stores its configuration files?
• 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
• 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 computer
• Trial for SynaMan Professional
• Uploading files containing foreign (unicode) characters
• Using SSL certificate with SynaMan
• Viewing existing public links