Cannot create an instance of OLE DB provider OraOLEDB.Oracle
在SQL SERVER 2008 R2下用Windows 身份认证的登录名创建了一个访问ORACLE数据库的链接服务器xxxxx，测试成功，木有问题，但是其它登录名使用该链接服务器时，报如下错误： 消息 7302，级别 16，状态 1，第 1 行 Cannot create an instance of OLE DB provide
在SQL SERVER 2008 R2下用Windows 身份认证的登录名创建了一个访问ORACLE数据库的链接服务器xxxxx，测试成功，木有问题，但是其它登录名使用该链接服务器时，香港服务器，报如下错误：
消息 7302，香港服务器租用，级别 16，状态 1，第 1 行
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "xxxxxx".
此时需要在“服务器对象”——>“链接服务器”——>“访问接口”下，找到OraOLEDB.Oracle选项，单击右键选择属性，然后在访问接口选项下勾选“允许进程内”（Allow inprocess）。即可解决上面问题，有时候，网站空间，可能需要重新新建此链接服务器。
老外给出了一个解决这个问题的步骤，相当详细严谨，几乎面面俱到。可以作为参考学习的好资料：
Ran into this issue where the linked server would work for users who were local admins on the server, but not for anyone else. After many hours of messing around, I managed to fix the problem using the following steps:
1：Run “dcomcnfg.exe”. Navigate to “Component Services -> Computers -> My Computer -> DCOM Config”.
2：Open the properties page of “MSDAINITIALIZE”.
3：Copy the “Application ID” on the properties page.
4：Close out of “dcomcnfg”.
5：Run “regedit”. Navigate to “HKEY_CLASSES_ROOT\AppID\{???}” with the ??? representing the application ID you copied in step #3.
6：Right click the “{???}” folder and select “Permissions”
7：Add the local administrators group to the permissions, grant them full control.
8：Close out of “regedit”.
9：Reboot the server.
10：Run “dcomconfig”. Navigate to “Component Services -> Computers -> My Computer -> DCOM Config”.
11：Open the properties page of “MSDAINITIALIZE”.
12：On the “Security” tab, select “Customize” under “Launch and Activation Permissions”, then click the “Edit” button.
13：Add “Authenticated Users” and grant them all 4 launch and activation permissions.
14：Close out of “dcomcnfg”.
15：Find the Oracle install root directory. “E:\Oracle” in my case.
16：Edit the security properties of the Oracle root directory. Add “Authenticated Users” and grant them “Read & Execute”, “List folder contents” and “Read” permissions. Apply the new permissions.
17：Click the “Advanced Permissions” button, then click “Change Permissions”. Select “Replace all child object permissions with inheritable permissions from this object”. Apply the new permissions.
18：Find the “OraOLEDB.Oracle” provider in SQL Server. Make sure the “Allow Inprocess” parameter is checked.
19：Reboot the server.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1376
52
How to use provide/inject in Vue to implement method transfer between ancestor components and descendant components
Jun 11, 2023 pm 12:17 PM
As a popular front-end framework, Vue provides a variety of methods to organize and manage interactions between components. In Vue, provide and inject are two methods that can be used to implement method transfer between ancestor components and descendant components. Provide and inject are methods for communication between advanced components provided by Vue. Their function is to provide data to ancestor components, and then use the inject method to receive data in descendant components. 1. Definition of provide and inject pro
How to use provide and inject in Vue3
May 11, 2023 pm 11:52 PM
1. Scene reproduction Don’t worry about the meaning of the title API. Here I will start by writing a more common scenario. The internal code of the corresponding component is relatively simple, and I will not show it here. Logically, these three components are referenced layer by layer. The corresponding page effect is as follows: As shown above, this is a very common scenario in projects, with three layers of nested components. (In fact, there are still deep levels of nesting. For now, it is enough for us to take three levels of nesting as an example.) OK, your current requirement is: you need to provide a string data "Han Zhenfang" in the grandfather component to provide it to the son component. If you are smart, you must have thought of props. Without further ado, let’s get started. 2. Passing Props "How advanced I thought it was. Isn't this the scene where data is passed from father to son?
Use provide and inject in Vue to implement data transfer and performance optimization between components
Jul 17, 2023 pm 07:19 PM
Use provide and inject in Vue to achieve data transfer and performance optimization between components. In Vue, data transfer between components is a very common requirement. Sometimes we want to provide data at a node in the component tree and then use the data in its descendant components. In this case, we can use Vue's provide and inject to achieve this. In addition to data transfer, provide and inject can also be used for performance optimization, reducing the level of props transfer and improving component performance. prov
How to use provide/inject in Vue to transfer data between ancestor components and descendant components
Jun 11, 2023 am 11:36 AM
In Vue, we often need to transfer data between components. When passing data between ancestor components and descendant components, we can use provide/inject provided by Vue. 1. The role of provide/inject In Vue, provide and inject are a pair of APIs used for data transfer between ancestors and descendants. Specifically, provide is used to define some data/methods that need to be shared in ancestor components, while inject is used to
How to use Provide and Inject in Vue3 plug-in
Jun 01, 2023 pm 08:34 PM
Why Vue3 plugins work differently than before In Vue2, most plugins inject properties onto this. For example, the Vue router can be accessed through this.$router. However, the setup() method no longer contains the same reference to this. The main reason for this change is to add support for Typescript. So how do we access our plug-ins in Vue3? We can use provide and inject to help us inject dependencies into the Vue program. Provide/inject is used for dependency injection, which allows us to provide plugins in the root directory of the Vue program and then inject them into child components. In Compositio
How to solve Vue error: unable to use provide and inject correctly for cross-level component communication
Aug 20, 2023 pm 06:01 PM
How to solve Vue error: unable to use provide and inject correctly for cross-level component communication. In Vue development, communication between cross-level components is a common requirement. Vue provides two APIs, provide and inject, to implement cross-level component communication. However, sometimes we may encounter some errors when using these two APIs. This article will introduce how to solve the problem of Vue error: unable to correctly use provide and inject for cross-level component communication, and provide the corresponding
What is provide & inject in Vue and how to use it?
Jun 11, 2023 pm 12:05 PM
Vue.js is a very popular JavaScript framework in the current front-end world. It has many excellent features such as responsive data binding, componentized view architecture, dependency tracking, and template rendering. The most commonly used function is component programming. Vue provides us with functional tests such as component registration, component parameter passing, etc. However, in some cases, the transmission of component data will encounter more difficult problems. At this time , we can use provide and inj provided in Vue
Provide and inject functions in Vue3: efficient data transfer between components
Jun 18, 2023 pm 08:45 PM
The provide and inject functions in Vue3 have become the preferred solution for efficient data transfer between components. They use a new mechanism to allow child components to obtain data in ancestor components and at the same time update data in ancestor components in parent components, which provides unlimited possibilities for building complex and flexible applications. This article will discuss the provide and inject functions in Vue3 in depth to help readers better understand their working principles and usage. What are provide and inje
