The Data Source tab prompts for a DSN name, description, and information that identifies the target Microsoft SQL Server DBMS.
DSN - (Required) A brief and meaningful title for your Data Source Name
Description - (Optional) A longer description for your Data Source Name
Server Name - (Required) Use the drop down menu to invoke the driver's dynamic discovery of Microsoft SQL Server instances on the network, and choose the desired instance.
"Use the ""Advanced"" button to manually configure a connection if the Microsoft SQL Server instance could not be dynamically located, as detailed below.
Server Type - An OpenLink proprietary parameter that associates the connection with a particular TDS version.
Hostname - The hostname or IP address on which Microsoft SQL Server listens. May include an instance name, as discussed below (e.g., ""MySQLHost.example.com\\MySQLInstance"").
Port number - The TCP port on which Microsoft SQL Server listens. Leave blank when SQL Server TCP/IP port setting is ""Dynamic.""
Server Name - (Optional) Microsoft SQL Server instance name on the specified host. Usually not specified unless SQL Server TCP/IP port setting is ""Dynamic."" Though not optimal, a Microsoft SQL Server instance name can be specified by instead appending ""\\InstanceName"" to the Hostname field above (e.g., ""MySQLHost.example.com\\MySQLInstance"").
Mirror Host - The name of the Failover Server hosting the mirrored database if configured
Use strong encryption of data - The driver will demand an SSL encrypted connection to the Microsoft SQL Server instance. If the target instance is not configured for or capable of SSL connections, the connection will fail. This setting is not needed for connections to Microsoft SQL Server instances which are configured to demand SSL connections from clients; such demands are handled automatically by the driver. Note that SSL connections are never supported by Microsoft SQL Server 7 or earlier, nor when using TDS Version 7.0 or 4.2.
Use MARS - Multiple Active Result Sets enables the concurrent processing of multiple statements/queries and/or result sets on a single connection
Verify Server Certificate - Verify the SSL Certificate presented by the database server against the one specified in the ""CA file"" field
CA file - Specify the location of a Valid SSL Certificate for use during the connection "
After selecting your preferences, click "OK" to continue
Attributes | Values |
---|
type
| |
Description
| - The Data Source tab prompts for a DSN name, description, and information that identifies the target Microsoft SQL Server DBMS.
DSN - (Required) A brief and meaningful title for your Data Source Name
Description - (Optional) A longer description for your Data Source Name
Server Name - (Required) Use the drop down menu to invoke the driver's dynamic discovery of Microsoft SQL Server instances on the network, and choose the desired instance.
"Use the ""Advanced"" button to manually configure a connection if the Microsoft SQL Server instance could not be dynamically located, as detailed below.
Server Type - An OpenLink proprietary parameter that associates the connection with a particular TDS version.
Hostname - The hostname or IP address on which Microsoft SQL Server listens. May include an instance name, as discussed below (e.g., ""MySQLHost.example.com\\MySQLInstance"").
Port number - The TCP port on which Microsoft SQL Server listens. Leave blank when SQL Server TCP/IP port setting is ""Dynamic.""
Server Name - (Optional) Microsoft SQL Server instance name on the specified host. Usually not specified unless SQL Server TCP/IP port setting is ""Dynamic."" Though not optimal, a Microsoft SQL Server instance name can be specified by instead appending ""\\InstanceName"" to the Hostname field above (e.g., ""MySQLHost.example.com\\MySQLInstance"").
Mirror Host - The name of the Failover Server hosting the mirrored database if configured
Use strong encryption of data - The driver will demand an SSL encrypted connection to the Microsoft SQL Server instance. If the target instance is not configured for or capable of SSL connections, the connection will fail. This setting is not needed for connections to Microsoft SQL Server instances which are configured to demand SSL connections from clients; such demands are handled automatically by the driver. Note that SSL connections are never supported by Microsoft SQL Server 7 or earlier, nor when using TDS Version 7.0 or 4.2.
Use MARS - Multiple Active Result Sets enables the concurrent processing of multiple statements/queries and/or result sets on a single connection
Verify Server Certificate - Verify the SSL Certificate presented by the database server against the one specified in the ""CA file"" field
CA file - Specify the location of a Valid SSL Certificate for use during the connection "
After selecting your preferences, click "OK" to continue
|
name
| |
position
| |
nextItem
| |
is nextItem
of | |
is schema:step
of | |
Faceted Search & Find service v1.17_git142 as of May 17 2024
OpenLink Virtuoso version 08.03.3331 as of Sep 4 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (7 GB total memory, 5 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software