Q+E: Additional Parameters for LOGON() Command

 Last reviewed: November 4, 1994
Article ID: Q88939
The information in this article applies to:
  • Q+E for Microsoft Excel, for Windows, version 3.0a
  • Q+E for Microsoft Excel, for OS/2, version 3.0

Summary:

There are undocumented parameters in the Logon command in Q+E 3.0a. The server, USER_ID and password can be passed along with the DDE command. Although Oracle and EEDataMGR are listed, the commands listed below only work with SQL Server.

The syntax for the command is:

Logon(dbname_Text,Connection_Text,Match_Previous,Show_Dialog)

dbname_Text = ServerType (such as, SQLServer, Oracle, EEDataMGR)

Connection_Text = special keywords used to indicate connection parameters necessary to logon.

Match_Previous = TRUE indicates that if the user has previously logged onto the same server, then use that connection. False means starts a new connection every time.

Show_Dialog = TRUE indicates that the Logon dialog box should be displayed.

More Information:

Keywords for the connection string include: 

   SRVR=name_of_the_server
   UID=user_name
   PWD=password
   DB=database_name
Some examples of connection strings: 

   For SQLServer: "SRVR=testsvr;UID=guest;PWD=guest"
   For Extended Edition: "DB=EESvr;UID=guest;PWD=guest"

Example

=EXECUTE(chan,"[logon('SQLServer','SRVR=MYSVR;UID=guest;PWD=guest', 

                       TRUE,FALSE)]")
This command will try to log on to the SQLServer called "MYSRV" with the User Name "guest" and the Password "guest" without displaying the dialog box. If the user is already logged onto the server with the same User Name and Password then that connection will be used instead of initiating a new connection.

Reference(s):

READ.ME, Q+E for Windows, Pioneer Software Version 2.6.1. Section titled: ENHANCED LOGON COMMAND

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.