SQL Server Data Store Properties

This category groups all SQL Server properties.

Access technology settings

Access technology to set

List of external stored procedures

Connection information

JDBC Driver1

Connect using3

Driver name3

Data library name

Programs library name

Create save file

Name of Journal

Order attributes in file

Use Custom JDBC URL1

Database name

Server name

Server TCP/IP port

Connect to server

Show Connection Dialog in WinForms1

Use trusted connection2,3,4

User id1

User password1

Use datasource for web-based applications

Additional connection string attributes2,3,4

Server connection pooling6

Unlimited size1

Size5

Create all pool connections at startup5

Recycle pool connections1

Recycle type1

Recycle time (minutes)1

Creation/Reorganization information

Database schema

Primary key definition

Declare referential integrity

Default tables storage area

Default indices storage area

Default temporary storage area

Generate COMMENT ON statements

Database information

SQL server version

Lock time-out (seconds)

Lock retry count

Properties that depend on Access Technology to Set property value:

¹JDBC
²ADO.NET
³ODBC
⁴Ruby
⁵Property depending on other property
⁶The "Server connection pooling" section properties only applies to the GeneXus built-in connection pooling mechanism.