DB.LOGON Required Before DB.SQL.QUERY To A SQL Server

When using the DB.Functions provided by QE.XLA to query an SQL Server table, it is necessary to use DB.LOGON("SQLServer") prior to sending the DB.SQL.QUERY() command. Otherwise, the DB.SQL.QUERY statement will fail and the result of the DB.SQL.QUERY will be a #REF!.

More Information:

The DB.SQL.QUERY command in the QE.XLA tests what sources are available before allowing the query. If the source in the query is not available, the macro fails and returns a #REF!.

Steps to Reproduce Problem

1. In Excel, open a new macro sheet. Enter the following:

         =DB.SQL.QUERY(2,"use pubs; Select * from SQLServer | sales")
   

2. Change to a worksheet and execute the macro. Nothing will be returned.

3. Add "=DB.LOGON("SQLServer")" (without quotation marks) before the DB.SQL.QUERY command.

4. Again, execute the macro. This time, after correctly logging on to the SQL Server, information will be returned.

"Q+E for Microsoft Excel User's Guide," pages 69-72