重装了服务器之后,经常遇到读取Oracle数据库发生如下报错:“The OLE DB provider "OraOLEDB.Oracle" for linked server”,一直以为是Oracle数据库在国外...其实解决方案很简单,在Server Objects>Linked Servers>Providers>OraOLEDB.Oracle点击右键,打开属性设置,开启“Allow inprocess”。
ORAMMCPMON11.ComponentData.1] [-HKEY_CLASSES_ROOT\ORAMMCPMON11.ComponentData.1\CLSID] [-HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup...] [-HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup\CLSID] [-HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup\CurVer...] [-HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup.1] [-HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup.1\CLSID]...[-HKEY_CLASSES_ROOT\OraOLEDB.Oracle] [-HKEY_CLASSES_ROOT\OraOLEDB.Oracle\CLSID] [-HKEY_CLASSES_ROOT...\OraOLEDB.Oracle\CurVer] [-HKEY_CLASSES_ROOT\OraOLEDB.Oracle.1] [-HKEY_CLASSES_ROOT\OraOLEDB.Oracle
HKEY_CLASSES_ROOT\ORCLSSO.ComponentData.1] [-HKEY_CLASSES_ROOT\OracleConfig.OracleConfig] [-HKEY_CLASSES_ROOT\OraOLEDB.Oracle....1] [-HKEY_CLASSES_ROOT\OraOLEDB.Oracle] [-HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup.1] [-HKEY_CLASSES_ROOT...\OraOLEDB.ErrorLookup] [-HKEY_CLASSES_ROOT\ORAMMCPMON11.ComponentData] [-HKEY_CLASSES_ROOT\ORAMMCCFG11
void Test1() { using (OleDbConnection conn = new OleDbConnection( “ Provider=OraOLEDB.Oracle...void Test2() { using (OleDbConnection conn = new OleDbConnection( “ Provider=OraOLEDB.Oracle...void Test3() { using (OleDbConnection conn = new OleDbConnection( “ Provider=OraOLEDB.Oracle...void Test4() { using (OleDbConnection conn = new OleDbConnection( “ Provider=OraOLEDB.Oracle
Source="; strConn+= hostName; } else if (dBType =1) //Oracle { //MSDAORA or OraOLEDB.Oracle....1 strConn = "Provider=OraOLEDB.Oracle.1"; strConn+= ";Persist Security Info=true";
WMBLOG_ORACLE", "DBType": 3, "Enabled": false, "HitRate": 10, "Connection": "Provider=OraOLEDB.Oracle..."DBType": 3, "Enabled": false,// 不开启 "HitRate": 10, "Connection": "Provider=OraOLEDB.Oracle...WMBLOG_ORACLE", "DBType": 3, "Enabled": false, "HitRate": 10, "Connection": "Provider=OraOLEDB.Oracle
microsoft.jet.oledb.4.0;data source=your_database_path;user id=admin;password=pass;" Oracle "Provider=OraOLEDB.Oracle
按关键字OraOLEDB.Oracle 7302搜,相同问题一堆,有说勾一下【允许进程内】的,有说把sqlserver服务的启动账户改为【LOCAL SERVICE】的,也有通过若干步骤修改一个叫【MSDAINITIALIZE
ID=system; Data Source=192.168.0.221/orcl; Persist Security Info=True 使用Oracle自带的oledb驱动: Provider=OraOLEDB.Oracle
, { "ConnId": 4, "DBType": 3, "Enabled": false, "Connection": "Provider=OraOLEDB.Oracle
Provider=OraOLEDB....Oracle;Data Source=MyOracleDB; User Id=myUsername; Password=myPassword; 受信连接 Provider=OraOLEDB.Oracle
"ConnId": "WMBLOG_ORACLE", "DBType": 3, "Enabled": false, "Connection": "Provider=OraOLEDB.Oracle
WMBLOG_ORACLE", "DBType": 3, "Enabled": false, "HitRate": 10, "Connection": "Provider=OraOLEDB.Oracle
领取专属 10元无门槛券
手把手带您无忧上云