Microsoft KB Archive/88939

{| = Q+E: Additional Parameters for LOGON Command =
 * width="100%"|

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: &quot;SRVR=testsvr;UID=guest;PWD=guest&quot; For Extended Edition: &quot;DB=EESvr;UID=guest;PWD=guest&quot;

Example
=EXECUTE(chan,&quot;[logon('SQLServer','SRVR=MYSVR;UID=guest;PWD=guest',

TRUE,FALSE)]&quot;) This command will try to log on to the SQLServer called &quot;MYSRV&quot; with the User Name &quot;guest&quot; and the Password &quot;guest&quot; 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
 * }