将oracle 12c连接到excel 2013 [英] connecting oracle 12c to excel 2013
本文介绍了将oracle 12c连接到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屋!
查看全文