Oracle OLEDB不支援sys以sysdba方式登陸

來源:互聯網
上載者:User
Oracle OLEDB常見的connection  string如下:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"
其中,User Id可以寫system,可以登陸成功。但如果寫成sys,會有錯誤訊息:sys必須以sysdba方式登陸。但是Oracle OLEDB並不支援下列方式:
User Id=sys as sysdba;
原因是OLE DB標準本來就不支援這種方式登陸。

如果硬要sys以sysdba方式登陸,只能使用ODBC。

相關資料如下(我試過oracle 10g,依然不行):
Doc ID: Note:276719.1
Subject: Is It Possible to Connect to Oracle as SYSDBA From ADO
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 18-JUN-2004
Last Revision Date: 03-AUG-2005

Applies to:
Oracle Provider for OLE DB - Version: 9.2.0.1
Oracle ODBC Driver - Version: 8.1.7.0 to 10.1.0.4
Microsoft Windows 2000
Microsoft Windows XP
Microsoft Windows Server 2003
Microsoft Windows (32-bit)

Symptoms
Unable to connect as SYSDBA from ADO applications.
Cause
Using the Microsoft OLEDB Provider to connect as SYSDBA

According to Bug 2114052, it is not possible, per the OLE DB specification,
to connect to a database with the "AS SYSDBA" syntax. This will not work
with Oracle OLE DB Provider either.

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.