Creation Date: Mar 10, 2006 Last Update: Mar 13, 2006 Version: 1.1
Oracle ODBC Driver for Linux...3 Oracle ODBC Driver for Linux...4 ODBC Driver Manager...5 ODBC...7 ODBC...8...10 2
Oracle ODBC Driver for Linux Oracle Database 10g Release 1 Linux ODBC ODBC 3rd Oracle Database 10g Release 2 Linux(Intel x86) Oracle ODBC Driver Linux ODBC Oracle ODBC Driver for Linux Oracle Database 10.2.0.1 3
Oracle ODBC Driver for Linux Oracle ODBC Driver for Linux Oracle Database 10g Release 2 for Linux Oracle Database Clinent CD Oracle Universal Installer Oracle ODBC Driver Oracle Database 10g Release 2 for Linux libsqora.so.10.1 ODBC Driver > ls $ORACLE_HOME/lib/libsqora.so.10.1 /opt/oracle/product/ora102/lib/libsqora.so.10.1 4
ODBC Driver Manager Oracle ODBC Driver ODBC Driver Manager ODBC Driver Manager Oracle Windows Microsoft ODBC Driver Manager Linux ODBC UNIX/Linux unixodbc unixodbc http://www.unixodbc.org/.tar.gz RPM Linux UNIX 5
unixodbc-2.2.11.tar.gz unixodbc 2.2.11 unixodbc > gunzip unixodbc-2.2.11.tar.gz > tar xvf unixodbc-2.2.11.tar > cd unixodbc-2.2.11 >./configure > make > su > make install make install root /usr/local/bin /usr/local/lib /usr/local/etc 6
ODBC ODBC Driver Manager ODBC Oracle ODBC odbcinst.ini odbc.ini odbcinst.ini /usr/local/etc odbc.ini.odbc.ini > vi /usr/local/etc/odbcinst.ini [odbcoracle10g] Description = Oracle 10g ODBC driver. Driver = /opt/oracle/product/ora102/lib/libsqora.so.10.1 > vi ~/.odbc.ini [DSNOracle10g] Driver = odbcoracle10g ServerName = ora102 odbcinst.ini Oracle ODBC Driver Driver $ORACLE_HOME/lib/libsqora.so.10.1 odbcinst.ini root root [] odbcinst.ini.odbc.ini oracle odbcinst.ini Driver odbcinst.ini ServerName Oracle Database $ORACLE_HOME/network/admin/ tnsnames.ora [] ODBC ODBC 7
ODBC ODBC ODBC Oracle Database unixodbc isql ODBC SQL isql > isql <DSN> <userid> <password> > isql DSNOracle10g scott tiger +---------------------------------------+ Connected! sql-statement help [tablename] quit +---------------------------------------+ SQL> SQL> ODBC Oracle -v > isql -v odbcoracle10gbeta scott tiger [S1000][unixODBC][Oracle][ODBC][Ora]ORA-12541: TNS:no listener [ISQL]ERROR: Could not SQLConnect -v ORA-12541 8
isql SQL Oracle SQL*Plus SQL SQL> select * from emp; SQLRowCount returns -1 14 rows fetched SQL> ODBC ODBC Oracle ODBC Driver 9
Oracle Database ODBC C ODBC > cd $ORACLE_HOME/odbc/demo/cdemo > ls cdemo_odbc.mk connect.c insert1.c insert2.c select.c cdemo_odbc.mk ODBC make connect.c ODBC Oracle select.c ODBC insert1.c ODBC insert2.c ODBC TestDBDSN ODBC SCOTT EMP TestDBDSN SCOTT EMP 10
TestDBDSN select.c.odbc.ini TestDBDSN > vi ~/.odbc.ini [TestDBDSN] Driver = odbcoracle10g ServerName = ora102 select.c select > cd $ORACLE_HOME/odbc/demo/cdemo > make -f cdemo_odbc.mk select select EMP >./select EMPNAME=SMITH EMPNO=7369 EMPNAME=ALLEN EMPNO=7499 EMPNAME=WARD EMPNO=7521 EMPNAME=JONES EMPNO=7566 EMPNAME=MARTIN EMPNO=7654 EMPNAME=BLAKE EMPNO=7698 EMPNAME=CLARK EMPNO=7782 EMPNAME=SCOTT EMPNO=7788 EMPNAME=KING EMPNO=7839 EMPNAME=TURNER EMPNO=7844 EMPNAME=ADAMS EMPNO=7876 EMPNAME=JAMES EMPNO=7900 EMPNAME=FORD EMPNO=7902 EMPNAME=MILLER EMPNO=7934 ODBC ODBC Linux ODBC ODBC 11
Copyright 2006 Oracle Corporation Japan. All Rights Reserved. Oracle Oracle Corporation Oracle Corporation 12