Substituting ODBC for JDBC to connect to SQL server for Veritas Backup Exec
The Backup Exec data collector, by default, uses JDBC (Java Database Connectivity) to connect to the SQL Server database. In most cases, this is the preferred mechanism for communicating with the SQL Server. However, in some instances--for example, TCP/IP is disabled for the SQL Server--JDBC will not be feasible.
In these rare situations, you can configure ODBC (Open Database Connectivity) to connect. The main limitation of this option is that it requires that a DSN (Data Source Name) be set up for each Backup Exec server for which the data collector needs access.
Note:
The data collector can be configured to use a mixture of JDBC and ODBC for specific servers.
Use the following steps to turn on ODBC for specific servers:
Obtain a copy the file from the Portal Server (the one that you created to load the Backup Exec servers into the database).
Edit anddelete those servers that you do not want to use ODBC. The format of the entry in the CSV file is:
<windows_domain>, <host or ipaddress>, <ipaddress>, , , BKUPEXEC
Save the file to as on the Data Collector server.
Launch the ODBC Data Source Administrator window:
Control Panel > Administrative Tools > Data Sources (ODBC)
Set up the ODBC DSN for each of the Backup Exec servers in , as depicted in the following sequence of windows.
The DSN needs to be of the form hostname_BKUPEXEC, where hostname is the second token in .
Note:
If the hostname_BKUPEXEC form does not work (see the third window in the following example), try substituting the IP address for the hostname. If you use the IP address, be sure to make appropriate changes to the CSV file to comply with the following required format:
<windows_domain>, <ipaddress>, <ipaddress>, , , BKUPEXEC
The DSN needs to be of the form hostname_BKUPEXEC, where hostname is the second token in .
Note:
If the hostname_BKUPEXEC form does not work (see the third window in the following example), try substituting the IP address for the hostname. If you use the IP address, be sure to make appropriate changes to the CSV file to comply with the following required format:
<windows_domain>, <ipaddress>, <ipaddress>, , , BKUPEXEC
