http://media.datadirect.com/download/eval_docs/odbc_unix_quickstart.htm#_MySQL_Wire_Protocol_Connection Options
Database: The name of the database to which you want to connect by default.
HostMame: The name of the machine on which the Informix server resides.
ServerName: The name of the Informix server as it appears in the sqlhosts file.
Service: The name of the service as it appears on the host machine.
Informix Wire Protocol
To configure a connection, you might enter:
[Informix Wire Protocol]
Driver=ODBCHOME/lib/xxifclnn.zz
Database=Informix3
HostName=InformixHost
LogonID=JohnD
PortNumber=1500
ServerName=InformixServer
Connection Options
Database: The name of the database to which you want to connect by default.
Hostname: Either the name or the IP address of the server to which you want to connect.
LogonID: Your user name as specified on the Informix server.
PortNumber: The port number of the server listener.
ServerNumber: The name of the Informix server as it appears in the sqlhosts file.
MySQL Wire Protocol
To configure a connection, you might enter:
[MySQL Wire Protocol]
Driver=ODBCHOME/lib/xxmysqlnn.zz
Database=MySQL3
HostName=MySQLHost
PortNumber=3306
Connection Options
Database: The name of the database to which you want to connect by default.
Hostname: Either the name or the IP address of the server to which you want to connect.
PortNumber: The port number of the server listener. The default is 3306.
Oracle
IMPORTANT: You must have all components of your database client software installed and connecting properly; otherwise, the driver will not operate correctly.
To configure a connection, you might enter:
[Oracle]
Driver=ODBCHOME/lib/ ivor8xx.nn
ServerName=OracleServer
Connection Options
ServerName: The client connection string designating the server and database to be accessed. The information required varies depending on the client driver you are using.
Oracle Wire Protocol
To configure a connection, you might enter:
[Oracle Wire Protocol]
Driver=ODBCHOME/lib/xxorann.zz
EditionName=oracle 1
HostName=199.226.224.34
PortNumber=1521
ServiceName=TEST
Connection Options
Hostname: Either the name or the IP address of the server to which you want to connect.
PortNumber: The port number of your Oracle listener. Check with your database administrator for the number.
ServiceName: The Oracle service name that specifies the database used for the connection. The service name is a string that is the global database name—a name that is comprised of the database name and domain name, for example: sales.us.acme.com.
SID: The Oracle System Identifier that refers to the instance of Oracle running on the server. The default is ORCL.
NOTE: SID and ServiceName are mutually exclusive. Only one or the other can be specified in the data source; otherwise, an error is generated.
EditionName: Oracle 11g R2 and higher only. The name of the Oracle edition the driver uses when establishing a connection. Oracle 11g R2 and higher allows your database administrator to create multiple editions of schema objects so that your application can still use those objects while the database is being upgraded. This option is only valid for Oracle 11g R2 and higher databases and tells the driver which edition of the schema objects to use.
PostgreSQL Wire Protocol
To configure a connection, you might enter:
[PostgreSQL Wire Protocol]
Driver=ODBCHOME/lib/xxpsqlnn.zz
Database=Pgredb1
HostName=PostgreSQLServer
PortNumber=5432
Connection Options
Database: The name of the database to which you want to connect by default.
Hostname: Either the name or the IP address of the server to which you want to connect.
PortNumber: The port number of the server listener. The default is 5432.
Progress OpenEdge® Wire Protocol
To configure a connection, you might enter:
[Progress OpenEdge Wire Protocol]
Driver=ODBCHOME/lib/xxoenn.zz
Database=odb1
HostName=OpenEdgeServer
PortNumber=5432
Connection Options
Database: The name of the database to which you want to connect by default.
Hostname: Either the name or the IP address of the server to which you want to connect.
PortNumber: The port number of the server listener.
Salesforce
The driver requires a Java Virtual Machine (JVM): Java SE 7 or higher. Before you configure a data source for the Salesforce driver, you must set the library path environment variable for your operating system to the directory containing your JVM’s libjvm.so [sl | a] file, and that directory’s parent directory. The library path environment variable is:
· LD_LIBRARY_PATH on Linux, Oracle Solaris, and HP-UX Itanium
· SHLIB_PATH on HP-UX PA-RISC
· LIBPATH on AIX
To configure a connection, you might enter:
[Salesforce]
Driver=ODBCHOME/lib/ivsfrc27.so
HostName=test.salesforce.com
UserName=JohnDoe
Password=secret
Connection Options
Host Name: The default Salesforce instance is login.salesforce.com. If you are logging into a different Salesforce instance, type the root of the Salesforce URL.
User Name: Type your logon ID for Salesforce.
Password: Type your case-sensitive password for the Salesforce instance.
If your Salesforce instance requires a security token, you can append it to the password, for example, secretXaBARTsLZReM4Px47qPLOS, where secret is the password and the remainder of the value is the security token. Both the password and security token are case-sensitive.
Fetch Size: Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.
WS fetch size: If set to 0, the driver attempts to fetch up to a maximum of 2000 rows. This value typically provides the maximum throughput. Setting the value lower than 2000 can reduce the response time for returning the initial data.
SQL Server Wire Protocol
To configure a connection, you might enter:
[SQLServer1 Wire Protocol]
Driver=ODBCHOME/lib/xxsqlsnn.zz
HostName=123.123.0.12
Database=master
PortNumber=1433
Connection Options
HostName: The name or the IP address of the server to which you want to connect.
If your network supports named servers, you can specify an address as: server_name. For example, you can enter SSserver.
You can also specify a named instance of Microsoft SQL Server. Specify this address as: 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.
Database: The name of the database to which you want to connect by default.
PortNumber: The port number of the server listener. The default is 1433.
Sybase IQ Wire Protocol
To configure a connection, you might enter:
[Sybase IQ Wire Protocol]
Driver=ODBCHOME/lib/xxsyiqnn.zz
Database=master
NetworkAddress=123.226.224.34,2638
Connection Options
Database: The name of the database to which you want to connect by default. If you do not specify a value, the default is the database defined by the system administrator for each user.
NetworkAddress: The IP address of the server to which you want to connect. Specify this address as: IP_address, port_number. For example, you can enter 123.226.224.34, 2638.
If your network supports named servers, you can specify an address as: server_name, port_number. For example, you can enter SyIQserver, 2638.
User Name: The default user ID that is used to connect to your database. Your ODBC application may override this value.
Sybase Wire Protocol
To configure a connection, you might enter:
[Sybase Wire Protocol]
Driver=ODBCHOME/lib/xxasenn.zz
Database=master
NetworkAddress=123.226.224.34,5000
Connection Options
Database: The name of the database to which you want to connect by default. If you do not specify a value, the default is the database defined by the system administrator for each user.
NetworkAddress: The IP address of the server to which you want to connect. Specify this address as: IP_address, port_number. For example, you can enter 123.226.224.34, 5000.
If your network supports named servers, you can specify an address as: server_name, port_number. For example, you can enter SSserver, 5000.
Driver for the Teradata Database
IMPORTANT: You must have all components of your database client software installed and connecting properly; otherwise, the driver will not operate correctly.
To configure a connection, you might enter:
[Teradata]
Driver=ODBCHOME/lib/xxterann.zz
DBCName=123.123.12.12
SecurityMechanism=TD2
SecurityParameter=5678
UserID=John
Connection Options
DBCName: The IP address or the alias name of the Teradata Server. Using an IP address reduces the time it takes to connect, but if that address is not available at connection time, the connection fails and the driver does not attempt to fail over to another address.
Using an alias name increases the time it takes to connect because the driver must search a local hosts file to resolve the name to the IP address information, but it allows the driver to try and connect to alternate IP addresses if the first address fails. If you use an alias name, you must have or create a local hosts file that contains the alias names. The alias name cannot be more than eight characters long.
SecurityMechanism: Enter TD2.
SecurityParameter: A string of characters that is to be regarded as a parameter to the authentication mechanism. The string is ignored by the ODBC driver and is passed on to the TeraSSO function that is called to set the authentication mechanism. The characters [] {} () , ; ? * = ! @ must be enclosed in curly braces.
UserID: The default UserID for the Teradata database.
Testing the Connection
The DataDirect Connect Series for ODBC installation includes a program named example that can be used to connect to a data source and execute SQL. The application is located in the ODBCHOME/example directory. To run the program, type example and follow the prompts to enter your data source name, user name, and password. If successful, a SQL> prompt appears and you can type in SQL Statements such as
SELECT * FROM accounts
If example is unable to connect, the appropriate error message appears.
