Win10 配置 Oracle ODBC数据源[不需要安装Oracle客户端]

快来打我* 2023-10-06 12:07 22阅读 0赞

## 1. 下载驱动包 ##

*  base包：instantclient-basic-windows.x64-12.1.0.2.0.zip
 *  ODBC包：instantclient-odbc-windows.x64-12.1.0.2.0.zip
 *  官网下载（需要账号）：[https://www.oracle.com/database/technologies/instant-client/downloads.html][https_www.oracle.com_database_technologies_instant-client_downloads.html]
 *  百度网盘：链接：[https://pan.baidu.com/s/1jKgTwb4za7cIzUB7CHH\_SA][https_pan.baidu.com_s_1jKgTwb4za7cIzUB7CHH_SA]  
    提取码：9ke7

## 2. 解压安装 ##

*  将两个解压包中文件放到同一个目录，例如`D:\Oracle\instantclient_12_1`，使用管理员权限打开CMD，进入`D:\Oracle\instantclient_12_1`目录
 *  运行`odbc_install.exe`，执行成功终端会出现`Oracle ODBC Driver is installed successfully`信息

## 3. 设置环境变量 ##

鼠标右键计算机 > 属性 > 高级系统设置 > 高级 > 环境变量 > 系统变量

<table> 
 <thead> 
  <tr> 
   <th align="left">名称</th> 
   <th align="left">值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td align="left">ORACLE_HOME</td> 
   <td align="left">D:\Oracle\instantclient_12_1</td> 
  </tr> 
  <tr> 
   <td align="left">Path</td> 
   <td align="left">％ORACLE_HOME％</td> 
  </tr> 
  <tr> 
   <td align="left">TNS_ADMIN</td> 
   <td align="left">％ORACLE_HOME％\network\ADMIN</td> 
  </tr> 
 </tbody> 
</table>

**注意**：如果下载 驱动包没有`network\ADMIN`目录，则需要新建`network\ADMIN`目录，在ADMIN目录下面添加`tnsnames.ora`文件，并添加如下内容：

XE =
      (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1527))
          (CONNECT_DATA =
              (SERVER = DEDICATED)
          	  (SERVICE_NAME = XE)
         )
      )

## 4. 配置ODBC ##

*  打开ODBC 驱动器  
    开始 > 控制面板 > 管理工具 > ODBC 数据源(64 位) **\[32、64对应你安装驱动包，例如安装64驱动包，打开ODBC 数据源(64 位)\]**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70]
 *  设置数据源  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70 1]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70 2]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70 3]

<table> 
 <thead> 
  <tr> 
   <th align="left">名称</th> 
   <th align="left">描述</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td align="left">Data Source Name</td> 
   <td align="left">自定义名字如:“Oracle”</td> 
  </tr> 
  <tr> 
   <td align="left">Description</td> 
   <td align="left">连接描述</td> 
  </tr> 
  <tr> 
   <td align="left">TNS Service Name</td> 
   <td align="left">两种方式：一种是点击下拉<code>tnsnames.ora</code>配置的名称如"XE" ，另一种填写：IP地址+端口号+SID 如: “192.168.0.1:1527/XE”</td> 
  </tr> 
  <tr> 
   <td align="left">UserID</td> 
   <td align="left">访问数据库的用户名</td> 
  </tr> 
 </tbody> 
</table>

*  连接测试  
    点击`Test Connection`测试弹出`Oracle ODBC Driver Connect`对话口 填写好密码 点击"OK" 若连接成功则提示 `Connection successful`

[https_www.oracle.com_database_technologies_instant-client_downloads.html]: https://www.oracle.com/database/technologies/instant-client/downloads.html
[https_pan.baidu.com_s_1jKgTwb4za7cIzUB7CHH_SA]: https://pan.baidu.com/s/1jKgTwb4za7cIzUB7CHH_SA
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200630154600230.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200630155511707.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200630155524713.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200630155537796.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODMzNjkyNA==,size_16,color_FFFFFF,t_70