FAQ for SQL Tester

 


Here You will find some common questions and answers about SQL Tester.

 

#1
Q: Do I need to manually install and activate the SQL Tester in MS Excel?
A: No, the installation-program will automatically install and activate it.
#2
Q; Can I install the SQL Tester in my user-profile folder?
A: Since SQL Tester is an add-in to MS Excel it should be available to all users logged on the computer, ie the answer is no.
#3
Q: Can SQL Tester be used to insert, update and delete records?
A: No, the tool can only retrieve data via the SQL-statement SELECT.
#4
Q: Does SQL Tester support Data Shaping?
A: The present version does not support it. The best tool for data shaping is the built-in tool Pivottable which is both powerful and flexible.
#5
Q: Does the SQL Tester support specific database-related SQL-statements?
A: SQL Tester works with the ANSI/ISO SQL3 standard (SQL-99).

Some RDBMS (Relation Database Management Systems) like MS SQL Server, Oracle and DB2 have their own specific version of SQL including commands that will not work with the SQL Tester.  
#6
Q: Can SQL Tester execute stored procedures?
A: The tool is targeting raw SQL-statements only.
#7
Q: When I try to open the helpfile I get an error-message that MS Excel can't find
    "@MSITStore C:\SQL Tester\SQL_Tester.chm". How can I resolve it?
A: This is a known issue that refers to Windows. You may download the tool MJ's Help Diagnostics to check if the required systemfiles are installed and registrated. You may also check out the following MS Knowledge Base-article:
 
#8
Q: I´m having a problem when using Oracle ODBC-driver and trying to view the tables. SQL Tester generates an error like: "2147352566 - Out of present range".
A: The solution is to use the OLE DB Provider for Oracle instead, which is the recommend way for connection to Oracle databases with SQL Tester.
#9
Q: SQL Tester's VBA code-generator gives the whole SQL-statement in one line. How can I change it so it will be splitted into several lines instead?
A: The following example shows how to solve it:


stSQL = "Select FirstName, LastName, Company," & _

             "Address, City," & _

             "State, Zip " & _

             "FROM Customers"

#10
Q: Does the Google Desktop Beta cause any problems?

A: The Google Desktop Beta may cause one or several of the following issues:

  • Request for project password on closing Excel.
  • Duplicate project names in the VB-editor.
  • Toolbar fails to appear.

 

The best solution is to uninstall the Google Desktop Beta.