windows 配置 oracle odbc :
打开odbc 数据源管理器》》系统DSN》》点击“添加”
如图:
若没有驱动程序 “Oracle in OrcClient11g_home” ,需要安装oracl客户端。
下载地址: Oracle Instant Client Downloads >> Instant Client for MicrosoftWindows (x64) >>
*Instant Client Package - SDK: Additional header files andan example makefile for developing Oracle applications with Instant Client
instantclient-sdk-windows.x64-11.2.0.4.0.zip (1,446,625bytes)
*Instant Client Package - ODBC: Additional libraries for enabling ODBCapplications
instantclient-odbc-windows.x64-11.2.0.4.0.zip (1,358,385 bytes)
安装后打开目录:D:\app\huangzc\product\11.2.0\client_2\Network\Admin
创建监听文件:tnsnames.ora
内容如下:
[plain] view plain copy
1. orcl22 = #监听名称
2. (DESCRIPTION =
3. (ADDRESS_LIST =
4. (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.22)(PORT = 1521)) #IP及端口
5. )
6. (CONNECT_DATA =
7. (SERVICE_NAME = orcl)#SID
8. )
9. )
重新打开odbc数据库管理器,可以看到有oracle驱动程序 “Oracle inOrcClient11g_home”
选择该驱动程序打开数据源配置。
填写完成后,点击“测试连接(testconnection)”,输入密码,完成!
#####################################################
安装odbc驱动,其实只要以下两文件:
instantclient-basic-windows.x64-11.2.0.2.0.zip (53,669,935bytes)
instantclient-odbc-windows.x64-11.2.0.2.0.zip (1,356,558bytes)
俩个文件解压在同一个目录中
打开命令行,到目录中运行 odbc_install.exe 即可!
E:\software\instantclient_11_2>odbc_install.exe
Oracle ODBC Driver is installed successfully.