User Tools

Site Tools


mssql_accelerator_connection_information_and_driver_configuration_file_properties.htm
Navigation:  SQL Drivers > MSSQL Accelerator >====== MSSQL Accelerator Connection Information and Driver Configuration–File Properties ====== Previous pageReturn to chapter overviewNext page

Typically, you add MSSQL support to your application by importing the table definitions into your Clarion Data Dictionary. The Import Wizard automatically fills in the File Properties dialog with default values based on the imported item. However, you can use the Owner Name field in the File Properties dialog to further configure the way the MSSQL Accelerator accesses the data.

The OWNER attribute for MSSQL takes the format:

server,<;database>,<;uid>,<;pwd><;;LANGUAGE=language><;;APP=name><;;WSID=name>

LANGUAGE The language used by MSSQL Server.
APP The name of the application.
WSID The workstation ID. Typically, this is the network name of the computer on which the application resides.

See your MSSQL Server documentation for information on these settings.

TipBox.jpg

Type an exclamation point (!) followed by a variable name in the Owner Name field to specify a variable rather than hard coding the OWNER attribute . For example: !GLO:SQLOwner.

mssql_accelerator_connection_information_and_driver_configuration_file_properties.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1