1.ODBC驱动配置
1.1 获取unixODBC
进入官网:https://www.unixodbc.org/,选择Download 下载软件包。本文以unixODBC-2.3.14版本为例。
1.2上传unixODBC-2.3.14.tar
1.3 检查gcc 包
rpm -aq|grep gcc
1.4 解压安装包
tar -xzvf unixODBC-2.3.14.tar.gz
1.5 配置ODBC
./configure
1.6 编译安装ODBC
make && make install
1.7 查看ODBC版本
odbc_config –version
1.8 查看odbc 配置文件路径
odbcinst -j
1.9 配置odbc.ini 和odbcinst.ini文件
vi /usr/local/etc/odbc.ini
[dm8]
Description = DM ODBC DSND
Driver = DM8 ODBC DRIVER
SERVER =127.0.0.1
UID = SYSDBA
PWD = Dameng123
TCP_PORT = 5238
vi /usr/local/etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /dm/dmdbms/bin/libdodbc.so
1.10 验证ODBC是否安装配置成功
isql dm8
2.安装dmPython
2.1 检查Python3环境
python3 –version
2.2 配置DM8环境
export PATH=$PATH:/dm/dmdbms/bin
export LD_LIBRARY_PATH
=$LD_LIBRARY_PATH:/dm/dmdbms/drivers/odbc/
2.3 安装dmPython
cd /dm/dmdbms/drivers/python/dmPython/
python3 setup.py install
2.4 用Python程序验证dmPython是否安装成功
新增pythonTest.py文件。
vi pythonTest.py
import dmPython
conn=dmPython.connect(user=‘SYSDBA’,password=‘Dameng123’,server=‘192.168.197.142’,port=5238)
cursor = conn.cursor()
cursor.execute(‘select employee_name from DMHR.EMPLOYEE limit 10’)
values = cursor.fetchall()
print(values)
cursor.close()
conn.close()
python3 pythonTest.py
文章
阅读量
获赞
