Oracle oledb does not support sysdba login by sys

Source: Internet
Author: User
Common connection strings of Oracle oledb are as follows:
"Provider = oraoledb. Oracle; Data Source = myoracledb; user id = username; Password = asdasd ;"
Here, the user ID can be written to system and can be successfully logged on. However, if it is written as sys, there will be an error message: SYS must be logged in as sysdba. However, Oracle oledb does not support the following methods:
User ID = sys as sysdba;
The reason is that the ole db standard does not support this method.

If you want sys to Log On As sysdba, you can only use ODBC.

The related information is as follows (I have tried Oracle 10g, but it still does not work ):
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:
Oracle provider for ole db-version: 9.2.0.1
Oracle ODBC driver-version: 8.1.7.0 to 10.1.0.4
In 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

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.