Not logged in : Login
(Sponging disallowed)

About: Step 5     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:HowToStep, within Data Space : data.openlinksw.com associated with source document(s)
QRcode icon
http://data.openlinksw.com/describe/?url=http%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Fuda%2Fhowto%2FMacOSXLiteSQLServerDataSourceNameConfigurationGuideStep5%23this&graph=urn%3Adata%3Aopenlink%3Aproducts&graph=urn%3Adata%3Aopenlink%3Aproducts

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

AttributesValues
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
described by
title
  • Step 5
type
position
nextItem
is topic of
is nextItem of
is schema:step of
Faceted Search & Find service v1.17_git122 as of Jan 03 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 28 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software