连接到微软的ODBC用于Oracle的Oracle 10g数据库 [英] Connect to an Oracle 10g database with Microsoft ODBC for Oracle

查看:356
本文介绍了连接到微软的ODBC用于Oracle的Oracle 10g数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想使用内置的Microsoft ODBC Oracle驱动程序连接到Oracle 10g数据库。我想用一个dnsless连接,所以我抓住从 www.connectionstrings.com 我的连接字符串。

I'm trying to connect to an Oracle 10g database using the built in Microsoft ODBC for Oracle driver. I want to use an dnsless connection, so I grab my connection string from www.connectionstrings.com.

在理想情况下,我不会要设置的DNS条目或Oracle TNS条目,我可能是错了,但我想上面会为我做的。我发现了以下内容:

Ideally I won't have to setup a DNS entry or an Oracle TNS entry, and I may be mistaken, but I thought the above would do that for me. I'm getting the following:

ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514:
TNS:listener does not currently know of service requested in connect
descriptor

ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed

ERROR [01000] [Microsoft][ODBC Driver Manager] 
The driver doesn't support the version of ODBC behavior that the
application requested (see SQLSetEnvAttr)."

据我可以在网上告诉,其他人都使用了微软的ODBC Oracle驱动程序连接到10G,但也许我失去了一些东西。我是从一个vb.net应用程序的方式连接。

As far as I can tell online, other people have used the Microsoft ODBC for Oracle driver to connect to 10g, but maybe I'm missing something. I'm connecting from a vb.net application by the way.

推荐答案

我不知道它是如何犹太回答你自己的问题,但我发现一个连接字符串,它是更多的东西我要找:

I'm not sure how kosher it is to answer your own question, but I found a connection string that is more what I'm looking for:

"Driver={Microsoft ODBC for Oracle}; " & _
                                 "CONNECTSTRING=(DESCRIPTION=" & _
                                 "(ADDRESS=(PROTOCOL=TCP)" & _
                                 "(HOST=myserver)(PORT=1521))" & _
                                 "(CONNECT_DATA=(SERVICE_NAME=servicename))); " & _
                                 "uid=username;pwd=password;

这篇关于连接到微软的ODBC用于Oracle的Oracle 10g数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆