由于初始化提供程序时出错，测试连接失败。“OraOLEDB.Oracle.1”提供程序未在本地计算机上注册
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14203678/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Test connection failed because of an error in initializing provider. The 'OraOLEDB.Oracle.1' provider is not registered on the local machine
提问by Jon Jaussi
I get this error when trying to connect to an Oracle 11g database from SSIS 2008 on a laptop running Windows 7.
在运行 Windows 7 的笔记本电脑上尝试从 SSIS 2008 连接到 Oracle 11g 数据库时出现此错误。
Test connection failed because of an error in initializing provider. The 'OraOLEDB.Oracle.1' provider is not registered on the local machine
由于初始化提供程序时出错，测试连接失败。“OraOLEDB.Oracle.1”提供程序未在本地计算机上注册
I am stuck here: I can connect to the Oracle database using TOAD but not SSIS 2008 from the same laptop. Any help on how I might be able to resolve is appreciated.
我被困在这里：我可以使用 TOAD 连接到 Oracle 数据库，但不能从同一台笔记本电脑连接到 SSIS 2008。任何有关我如何解决的帮助表示赞赏。
回答by Ciarán
The Oracle ole db driver is not always installed as standard when installing Oracle. Re-run your oracle installation and make sure you've installed it
安装 Oracle 时，Oracle ole db 驱动程序并不总是作为标准安装。重新运行您的 oracle 安装并确保您已安装它
