将oracle 12c连接到excel 2013 [英] connecting oracle 12c to excel 2013

问题描述

我无法将64位的oracle 12c数据库连接到excel 2013宏.... !!

它说未找到数据源名称且没有指定默认驱动程序....有什么我我不见了？请帮助....



问候

解决方案

好的....我有办法。 ...制作DSN连接就可以了....这里是以下步骤：



我的电脑--->控制面板--->管理工具--->右键单击ODBC数据源（64位）--->添加--->选择oracle driver --->处理 - >然后窗口会打开询问一些用户名密码和DSN名称--->创建DSN使用前面提到的代码如下：

  Dim  conn < span class =code-keyword> As   New  ADODB.Connection 
 conn.Open    DSN = dsnName; uid = xyz; pwd = x123 

多数民众赞成真的！ :) :)



如果你想减少DSN连接，请使用：



< pre lang =vb> Dim conn As New ADODB.Connection
conn.Open driver = {机器中的驱动程序名称}; uid = XYZ; PWD = X123\"

I cannot connect oracle 12c database for 64 bit to excel 2013 macro....!!
It says Data source name not found and no default driver specified....is there something I am missing?? Kindly help....

Regards

解决方案

Ok....I got a way....making a DSN connection does it all....here are the steps:

My Computer ---> Control Panel ---> Administrative tools ---> Right click on ODBC data source(64 bit) ---> add ---> choose oracle driver ---> finish--> then window will open asking some username password and DSN name ---> create DSN use previously mentioned code like this:

Dim conn As New ADODB.Connection
conn.Open "DSN=dsnName;uid=xyz;pwd=x123"

Thats it!! :) :)

If you want to make a DSN less connection then use this:

Dim conn As New ADODB.Connection
conn.Open "driver={driver name in your machine};uid=xyz;pwd=x123"

这篇关于将oracle 12c连接到excel 2013的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！