# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# Common Support Questions

1. | MySQL: MySQL connection only works from local machine - Enable MySQL Remote Access
2. | MySQL: MySQL keeps dropping the connection.
3. | MySQL: Error when using the DELIMITER statement in MySQL
4. | MySQL: cannot convert value '0000-00-00 00:00:00' from Column x to TimeStamp where x is the column number of the DATETIME column
5. | MySQL: How to connect to MySQL versions older than 4.x, such as MySQL 3
6. | MySQL: How to connect to the Mac MAMP MySQL database / Connecting to local MySQL server through socket /tmp/mysql.sock
7. | MySQL: How to Connect Using different Character Sets or Character Encodings such as UTF-8
8. | MySQL, PostgreSQL, SQL Server: Unable to make a connection to hosting provider database (MySQL, PostgreSQL, MS SQL Server)
9. | PostgreSQL: PostgreSQL connection only works from local machine
10. | PostgreSQL: How to connect to PostgreSQL over SSL using self signed certificate.
11. | DB2: How to avoid table and row locking in DB2.
12. | DB2: Information for connecting to DB2 on the mainframe (z/OS).
13. | DB2: Connecting to DB2 on iSeries / AS400.
14. | Oracle: When attempting to connect to Oracle, the following error is thrown: Class oracle/sql/converter/CharacterConverters violates loader constraints.
15. | Oracle: OCI Error - java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
16. | Oracle: The error, java.sql.SQLException: Stream has already been closed, is thrown when querying an Oracle table with long or long raw columns.
17. | SQL Server: How to call a SQL Server DTS package.
18. | SQL Server: The following error is received when connecting to SQL Server from a Mac: Single-Sign-On is only supported on Windows. Please specify a user name.
19. | SQL Server: SQL Server login failure state codes
20. | SQL Server: How to use the GO SQL statement separator in RazorSQL for MS SQL Server
21. | SQL Server: How to connect to SQL Server named instances
22. | SQL Server / Sybase / SQL Anywhere: QUOTED_IDENTIFIER settings
23. | SQL Server: Unable to connect to SQL Server Express
24. | SQL Server / Sybase: How to view multiple results sets for a query such as sp_help.
25. | Sybase: How to resolve Sybase transaction log errors
26. | DBASE: Information on connecting to DBASE
27. | Netezza: Does RazorSQL support Netezza
28. | Pervasive: Does RazorSQL support Pervasive
29. | Paradox: Information on connecting to Paradox
30. | Ubuntu: How to add RazorSQL to the Ubuntu menu launcher
31. | Ubuntu: Graphics are flickering in Ubuntu
32. | RazorSQL: Are administrator privileges required for installing RazorSQL on Windows machines?
33. | RazorSQL: How to increase maximum memory settings for RazorSQL.
34. | RazorSQL: How to save a query using RazorSQL

Are administrator privileges required for installing RazorSQL on Windows machines?

`Administrator privileges are not required to install RazorSQL. However, the default setting for the Windows installer is to install RazorSQL in the Program Files directory, which is probably not writeable for your logon id if you do not have administrator privileges. There are two ways to get around this: 1. The easiest is to download the latest razorsql<version>_windows.zip file from http://www.razorsql.com/download.html to your desktop. Then extract the zip file and navigate to the razorsql<version> directory and launch razorsql.exe or razorsql.bat. 2. The second way is to launch the razorsql<version>_setup.exe Windows installer and when given the choice as to where to install RazorSQL, be sure to change the directory from the Program Files directory to a directory you have write access to such as your desktop.`

How to increase maximum memory settings for RazorSQL.

`For Windows machines, the max memory setting is contained in a file called razorsql.bat located in the RazorSQL installation directory. In this file, there is a line containing the text -Xmx384M or -Xmx256M depending on the version of RazorSQL you are using. Increase the number before the M, which stands for MegaBytes, to increase the memory. To take advantage of the change, RazorSQL must be launched by double-clicking razorsql.bat. For Mac OS X machines, right-click on the RazorSQL application file and select "View Package Contents". Edit the Info.plist file. In this file, there is a line that contains either -Xms16m -Xmx256m or -Xms16m -Xmx384m depending on the version of RazorSQL you are using. Increase the 256 or 384 number to increase the memory. For Linux / Unix machines, edit the razorsql.sh shell script. Increase the number after the -Xmx to increase the available memory for RazorSQL.`

How to save a query using RazorSQL.

`There are a couple of ways to save the queries depending on how they were executed. For individual queries, the easiest way to save the query is to press the "Save Query" button located on the query results toolbar or the "Save Query" option located in the right-click menu of the query results tab. You will then be prompted for where to save the query to on your file system. If you typed the query into the sql editor, you can do a File -> Save or File -> Save As to save the editor contents to a file on your computer. If you did not execute the query from the editor, but used the navigator or query builder to execute the query, you can click on the "view query" icon in the query results toolbar or right click on "Query 1" and select "View Query" to see the query that was executed. You can then do a control-A / command-A and control-C / command-C to copy the query to your clipboard. Also, all queries you execute are stored and can be viewed by selecting Connections -> View SQL History or Connections -> View Query Log. The SQL History by default stores 20,000 lines of history. The query log stores the history for the current connection.`