The following is a sample odbc.ini file that Setup installs in the installation directory. All occurrences of ODBCHOME are replaced with your installation directory path during installation of the file. Values that you must supply are enclosed by angle brackets (< >). If you are using the installed odbc.ini file, you must supply the values and remove the angle brackets before that data source section will operate properly. Commented lines are denoted by the # symbol. This sample shows a 32-bit driver with the driver file name beginning with iv. A 64-bit driver file would be identical except that driver name would begin with dd and the list of data sources would include only the 64-bit drivers.

[ODBC Data Sources]
SQL Server=DataDirect 8.0 SQL Server Wire Protocol

[SQL Server]
Driver=ODBCHOME/lib/ivsqls28.so
Description=DataDirect 8.0 SQL Server Wire Protocol
AEKeyCacheTTL=-1
AEKeystoreClientSecret=
AEKeyStoreLocation=
AEKeystorePrincipalId=
AEKeyStoreSecret=
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationIntent=0
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadOptions=2
BulkLoadThreshold=2
BulkLoadRecordDelimiter=
ColumnEncryption=Disabled
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
CryptoLibName=
CryptoProtocolVersion=TLSv1.2,TLSv1.1,TLSv1
Database=<database_name>
DefaultLongDataBuffLen=1024
EnableBulkLoad=0
EnableFIPS=1
EnableQuotedIdentifiers=0
EnableServersideCursors=1
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=<SQL_Server_host>
HostNameInCertificate=
InitializationString=
KeepAlive=0
KeepConnectionActive=0
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
MultiSubnetFailover=0
PacketSize=-1
Password=
Pooling=0
PortNumber=<SQL_Server_server_port>
PRNGSeedFile=/dev/random
PRNGSeedSource=0
ProxyHost=
ProxyMode=0
ProxyPassword=
ProxyPort=0
ProxyUser=
QueryTimeout=0
ReportCodePageConversionErrors=0  
SnapshotSerializable=0
SocketIdleTimeCheckInterval=1500
SSLLibName=
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XMLDescribeType=-10

[ODBC]
IANAAppCodePage=4
InstallDir=ODBCHOME
Trace=0
TraceFile=odbctrace.out
TraceDll=ODBCHOME/lib/ivtrc28.so
ODBCTraceMaxFileSize=102400
ODBCTraceMaxNumFiles=10
[ODBC File DSN]
DefaultDSNDir=
UseCursorLib=0

To modify or create data sources in the odbc.ini file, use the following procedures.

  • To modify a data source:
    1. Using a text editor, open the odbc.ini file.
    2. Modify the default attributes in the data source definitions as necessary based on your system specifics, for example, enter the host name and port number of your system in the appropriate location.

      Consult the "SQL Server Wire Protocol Attribute Names" table in the "Connection options descriptions" for other specific attribute values.

    3. After making all modifications, save the odbc.ini file and close the text editor.
      Important: The "Connection option descriptions" section lists both the long and short names of the attribute. When entering attribute names into odbc.ini, you must use the long name of the attribute. The short name is not valid in the odbc.ini file.
  • To create a new data source:
    1. Using a text editor, open the odbc.ini file.
    2. Copy an appropriate existing default data source definition and paste it to another location in the file.
    3. Change the data source name in the copied data source definition to a new name. The data source name is between square brackets at the beginning of the definition, for example, [SQL Server].
    4. Modify the attributes in the new definition as necessary based on your system specifics, for example, enter the host name and port number of your system in the appropriate location.

      Consult the "SQL Server Wire Protocol Attribute Names" table in the "Connection option descriptions" for other specific attribute values.

    5. In the [ODBC] section at the beginning of the file, add a new data_source_name=installed-driver pair containing the new data source name and the appropriate installed driver name.
    6. After making all modifications, save the odbc.ini file and close the text editor.
      Important: The "SQL Server Wire Protocol Attribute Names" table in the "Connection option descriptions" section lists both the long and short name of the attribute. When entering attribute names into odbc.ini, you must use the long name of the attribute. The short name is not valid in the odbc.ini file.