Current location:

Microsoft SQL Server

Location: Overlay Types dialog > Databases > Cadcorp View Geometry > Microsoft SQL Server

The Microsoft SQL Server Connection dialog will be displayed:

Server name

Select a server name from the drop-down list, or type the location of the server where the database you want to access is located. Selecting the database on the server is a separate action. Click Refresh to refresh the list. If the server instance uses a port other than the default specify the port after the server address, in the form: Server\SQL2016, 1434

Authentication

Windows Authentication

Select if the provider is to request a secure (or trusted) connection to a Microsoft SQL Server running in Windows NT. When selected, SQL Server uses integrated login security to establish connection using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The SQL Server system administrator must have associated your Microsoft Windows network ID with a SQL Server login ID.

SQL Server Authentication

Select to use a supplied user name and password to authenticate your logon information to the data source.

Login

Type the user ID to use for authentication when you log on to the data source.

Password

Type the password to use for authentication when you log on to the data source.

Database

Type the name of the database that you want to access or select it from the drop-down box.

Save connection details in Options database (with encrypted password)

Check this tickbox if SIS should store these connection details in the Options database. The password will be stored in encrypted form for security.

Saved connection name

This text box will become active if the Save connection details in Options database (with encrypted password) tickbox is checked. Enter a meaningful name for this connection. This text box cannot be left blank and the same name cannot be used twice.

If the Microsoft SQL Server Connection has been made previously, and the connection details saved, the Microsoft SQL Server Connection dialog will be displayed in the form shown below:

In this case click on one of the Saved connections or Currently used connections (if any are in use) to complete the connection details.

Click Next.

The Recordset dialog will be displayed:

Database Tables/Columns

Displays the tables and columns available in the connected database. Highlight the required table or column in this pane. Database names are case sensitive, use upper-case names for interoperability.

Add/Remove

Click the Add button to add the selected column to the chosen list. If a table is selected then all its columns will be added.

The Remove button removes a selected column from the Selected columns list.

Selected columns

Displays the selected database table columns. Move the horizontal slider to the right to reveal the Alias column, this column is used to map the database column name onto a SIS property/attribute name. If the recordset is being used as part of a database-based dataset, then you can enter existing property names (e.g. _shape$) to redefine the created items' properties.

If you wish to assign a column to be used for hyperlinks, then when you have clicked Add, scroll the pane horizontally to show the Alias column. In the column that is to contain the hyperlink data rename the Alias to _URI$:

When the dataset is displayed in the Map Window the Properties Control Bar will display any property value that it recognises as a URL, or as a file or folder name, as a clickable link.

SQL Where

Enter the SQL syntax clause that can be used to join several different tables, or restrict which rows are imported. Do not use the WHERE SQL keyword.

Click Next.

The View Geometry dialog will be displayed:

BLOB Configuration

BLOB Field

The field that contains the BLOB (Binary Large OBjects) string. Select from drop-down list.

Format

This is the format of the BLOB string. SIS Binary Item is the default setting. If the original overlay was created using a non-default setting, such as GeoJSON or OGC Well Known Binary format, you have to select this from the Format drop-down list to open the overlay.

The following formats are currently supported.

ESRI Shape

GeoJSON

OGC Geography Markup Language

ODC Well Known Binary

OGC Well Known Text

SIS Binary Item

SIS V6 ASCII.

Optional Configuration

ID Field

The field that contains the item ID.

Overlay Configuration

Name

This is the overlay name.

Theme

This drop-down shows any Themes associated with the overlay:

If you do not want to modify the dataset's Coordinate Reference System, Scale, etc. click Finish.

If you do want to make some changes click the More Properties button.

The View Geometry dialog will be displayed:

Coordinates:

Displays the coordinate reference system that the dataset items are defined in. To view or edit the coordinate system details drop-down the combo-box list, and press the right arrow at the bottom to display the Coordinate Reference System dialog.

Feature Table:

This is the feature table to use for feature-coded items in this dataset. Feature-coded items get information about their feature code either from this feature table, or, if set, their own Feature Table property.

Scale:

The default viewing scale for this dataset. This will affect how Text items convert their point heights into world sizes.

Properties... button

Click the Properties... button to display the resizable Cadcorp View Geometry dialog showing the values of properties which may be viewed or edited:

Click OK to return to the second View Geometry dialog.

On completion click Finish on the initial View Geometry dialog.

Top of page

Send comments on this topic.

Click to return to www.cadcorp.com