Mac OS X Mac OS X
Windows Windows
Linux Linux

SQL Server

Frequently Asked Questions

This section provides answers to commonly asked questions. Should you have questions not addressed in this section or in the user documentation, please contact support.

Q: Is DB Solo - The SQL Query Tool free?

No, but it is extremely affordable. You can evaluate the product for 30 days without a license, but after the evaluation period you need to purchase a valid license for a fraction of the cost of other similar products. A single license allows a user to install and use the product on multiple computers (and operating systems) provided that only the licensed user is using the product.

Q:  My table contains over 5,000 rows, why do I only see the first 1,000 rows?

To conserve memory and speed up response times, DB Solo only loads the first 1,000 rows by default. To increase the default limit, go to Settings->Query Window and Settings->Browser Window and change the value in the 'Max Number of Rows Retrieved' field.

Q:  How do I create a stored procedure?

By default, DB Solo takes the text in the query window and splits it into separate statements using ; (semicolon) and 'go' as statement separators. DB Solo also removes both line and block comments before sending the statements to the server. When creating a stored procedure, the procedure will most likely contain these statement separators so standard execute would fail. To make it work, type in your procedure and select Query->Execute SQL Buffer As-Is.

Alternatively, you can go to Settings -> Query Panel and only use 'go' as your statement separator. That way, semicolons in you stored procedure will not be treated as statement separators.

Q: How do I execute a query containing a server-side comment?

See the answer above.

Q: If I have multiple queries in the Query Window, can I execute only one of them?

Yes. If you want to execute the statement under the cursor (caret), you can do that by hitting F5 or selecting 'Execute Current' from the Query-menu. You can also select one or more SQL statements with your mouse and hit Ctrl-Enter or select 'Execute' from the Query-menu. This will only execute the selected SQL text. If there is no selection, all statements in the query window will be executed.

Q: Data in my database contains Asian characters, how do I see them properly in DB Solo?

You have to make sure the default text font is one that contains glyphs for Asian characters. Go to Settings->General and pick a font under 'Default Text Font' that supports Asian characters. On Windows platforms Gulim, MS Gothic and many more fonts support Asian characters.

Q: My MS SQL Server uses Windows authentication, can I still access it?

Yes. When adding a new server connection you must enter a domain in addition to username and password. You have to do this even if you are currently logged into the correct domain. If you are using SQL Server authentication, you must NOT enter a domain, only enter your username/password.

Q: What if my SQL Server is running multiple instances?

You can connect to a specific instance by using one of the following notations in the host field: host\instance or \\host\instance.

Q: When should I use the Type 2 JDBC driver for DB2?

The Type 2 driver requires that you have installed native code DB2 client software (Runtime client/Application development client) on the computer you are trying to connect from. As a result of this, you only have to enter the database/alias name of the server you want to connect to, you don't have to set the host or port. You can optionally set the user name and password. Using the Type 2 driver is recommended when you are connecting to UDB 7.x servers.


Browse Archives