Linux/UNIX ODBC 配置全过程总结

#http://www.unixodbc.org/doc/  some materials about unixodbc
#http://www.easysoft.com/developer/interfaces/odbc/linux.html#unixodbc most worthy to read

#Chen peng MSN:peng.ch@hotmail.com 2006-4-28

# The unixODBC source distribution is a gzipped tar file on http://www.unixodbc.org
# Uncompress it in the dir /usr/local and then untar the resultant file.

gunzip unixODBC-2.2.12.tar.gz
tar -xzvf unixODBC-2.2.12.tar
./configure --prefix=/usr/local/unixODBC-2.2.12 --includedir=/usr/include --libdir=/usr/lib -bindir=/usr/bin --sysconfdir=/etc

# create an ODBC driver template file and run odbcinst. filename : template_file

/*
In this case your template file must contain the Driver and Description attributes at a minimum and optionally the Setup attribute e.g.
 
 [DRIVER_NAME]
 Description = description of the ODBC driver
 Driver = path_to_odbc_driver_shared_object
 Setup = path_to_driver_setup_shared_object

e.g:
 SkyKonnect:/ # cat /usr/local/etc/odbcinst.ini
 [MySQL]
 Description     = ODBC for MySQL
 Driver          = /usr/lib/libmyodbc3.so
 Setup           = /usr/local/lib/libodbcmyS.so
 FileUsage       = 2
 UsageCount      = 2

*/

odbcinst -f template_file -d -i

# You can list all installed ODBC drivers with:
odbcinst  -s -q
/*
 SkyKonnect:/usr/local/unixODBC-2.2.11/ODBCConfig # odbcinst  -s -q
 [myodbc3]
*/

# you can locate the odbcinst.ini file used to defined drivers as below If unixODBC is already installed :
odbcinst -j
/*
 SkyKonnect:/usr/local/unixODBC-2.2.11/ODBCConfig # odbcinst  -j
 unixODBC 2.2.11
 DRIVERS............: /usr/local/etc/odbcinst.ini
 SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
 USER DATA SOURCES..: /root/.odbc.ini
*/

/** Edit the SYSTEM or USER DSN ini file ( odbc.ini or .odbc.ini) and add a data source using the syntax:
   
    [ODBC_datasource_name}
    Driver = driver_name
    Description = description_of_data_source
    attribute1 = value
    .
    .
    attributen = value*

[1] [2] [3] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:在Solaris 10 X86上安装Oracle 10g RAC详解 (2)

下一篇:CIH文件型病毒检测消除程序