Clarion Community Help

Navigation: SQL Drivers > MSSQL Accelerator >====== PROP:LogonScreen (MSSQL Accelerator) ======

PROP:LogonScreen sets or returns the toggle that determines whether the driver automatically prompts for logon information. By default (PROP:LogonScreen=True), the driver does display a logon window if no connect string is supplied. If set to False and there is no connect string, the OPEN(file) fails and FILEERRORCODE() returns '28000.' For example:

Afile FILE,DRIVER('MSSQL')

!file declaration with no userid and password

END

CODE

AFile{PROP:LogonScreen}=True !enable auto login screen

OPEN(Afile)

The automatic logon screen lets prompts for the following connection information. Consult your MSSQL documentation for more information on these prompts:

Server	Select the workstation running the MSSQL database to import from. If the Server list is empty, you may type in the name. See your DBA or network administrator for information on how the server is specified.
Logon ID	For Standard Security, type your MSSQL Username. For Trusted Security (Integrated NT Security) no Username is required. See your server documentation or your DBA for information on applicable Usernames and security methods.
Password	For Standard Security, type your MSSQL Password. For Trusted Security (Integrated NT Security) no Password is required. See your server documentation or your DBA for information on applicable Passwords and security methods.
Options	Press this button to enable the following prompts. See your MSSQL Server documentation for information on these prompts.
Database	Select the MSSQL database that contains the tables or views to access. If the Database list is empty, you may type in the name. See your server documentation or your DBA for information on database names.
Language	The language used by MSSQL Server.
Application Name	The name of the application.
WorkStation ID	The workstation ID. Typically, this is the network name of the computer on which the application resides.