The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.
The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, and yy represents the extension. The values for the options are samples and are not necessarily the ones you would use.
[ODBC Data Sources]
SQL Server Wire Protocol=DataDirect 8.0 SQL Server Wire Protocol Driver
[SQL Server Wire Protocol]
Driver=ODBCHOME/lib/xxsqlsyy.zz Database=default
HostName=SSServer
PortNumber=1433
Connection Option Descriptions:
Database: The name of the database to which you want to connect by default.
HostName: The host server or listener using one of the following options:
Named Servers: If your network supports named servers, specify the name of the server. For example, you can enter SSserver.
IP Address: Specify the IP address of the server to which you want to connect. For example, you can enter 199.226.224.34.
Named Instance: Specify the name of the named instance using the following format: server_name\instance_name. If only a server name is specified with no instance name, the driver uses the default named instance on the server.
Virtual Network Name (VNN): Type the virtual network name of the availability group listener.
LogonID: The default user ID that is used to connect to your database.
PortNumber: The port number of the server listener. The default is 1433.
Database: The name of the database to which you want to connect by default.