Before using the ODBC operator, you must configure the ODBC initialization file on your platform to designate the DSN (data source name) in 'ODBC Data Sources' to point to the proper data source.
Following is a sample ODBC.ini file for a Solaris client system. It shows data source information for Teradata, ORACLE, and SQLServer data sources.
[ODBC] InstallDir=/usr/odbc Trace=0 TraceFile=/usr/joe/odbcusr/trace.log TraceAutoStop=0 [ODBC Data Sources] testdsn=tdata.so default=tdata.so Teradata=tdata.so Oracle=DataDirect 4.10 Oracle SQLServer Wire Protocol=DataDirect 4.10 SQL Server Wire Protocol [testdsn] [default] [Teradata] [Oracle] Driver=/opt/odbc/lib/ivor818.so Description=DataDirect 4.10 Oracle LogonID=oracle Password=oracle ServerName=DBCName=200.001.001.01 CatalogOptions=0 ProcedureRetResults=0 EnableDescribeParam=0 EnableStaticCursorsForLongData=0 ApplicationUsingThreads=1 [SQLServer Wire Protocol] Driver=/opt/odbc/lib/ivmsss18.so Description=DataDirect 4.10 SQL Server Wire Protocol Database=db LogonID=uid Password=pwd Address=sqlserverhost,1433 QuotedId=No AnsiNPW=No
The following is another sample ODBC.ini file for a Solaris client system, using Simba's Oracle ODBC Driver:
[ODBC] InstallDir=/usr/odbc Trace=0 TraceFile=/usr/joe/odbcusr/trace.log TraceAutoStop=0 [ODBC Data Sources] testdsn=tdata.so default=tdata.so Teradata=tdata.so Oracle=Simba Oracle ODBC Driver 32-bit [testdsn] [default] [Teradata] [Oracle] Driver=/opt/simba/oracleodbc_32/lib/libsimbaoracleodbc32.so Description=Simba Oracle ODBC Driver(32-bit) DSN HOST=200.001.001.01 PORT=1521 UID=oracle PWD=oracle SVC=oracle.service.name MEMLIM=104857600