当前在线人数17585
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:Re: Question about DSN (for oracle)
[同主题阅读] [版面: 数据库] [作者:yiyayiyayo] , 2007年04月27日00:01:05
yiyayiyayo
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: yiyayiyayo (Mera naam Itiaan hai), 信区: Database
标  题: Re: Question about DSN (for oracle)
发信站: BBS 未名空间站 (Fri Apr 27 00:01:05 2007)

It seems your connection string is for OleDb instead of ODBC, judging from
the info at the following URL.

http://www.connectionstrings.com/?carrier=oracle

What if you try this connection string as shown from the same URL for ODBC?

Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd
=myPassword;

【 在 cogt (苦荆茶) 的大作中提到: 】
: in XP, created system DSN with Microsoft ODBC for Oracle driver. In VBA,
def
: ined:
: adostring = "Provider=MSDAORA.1;Password=myPassword;User ID=dbUser;Data
Sour
: ce=myDataSource;Persist Security Info=True"
: but it always failed at: cn.Open adostring! any clue why?



--

※ 来源:·BBS 未名空间站 海外: http://mitbbs.com 中国: http://mitbbs.cn·[FROM: 76.199.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996