如何解决错误 ORA-06413:连接未打开?

How do I resolve the error ORA-06413: Connection not open?(如何解决错误 ORA-06413:连接未打开?)

问题描述

我的本​​地环境VS2012

My local environment VS2012

使用 Oracle 10g XE

Using Oracle 10g XE

Dim dbConn As New OleDbConnection

Dim dbComm As OleDbCommand

dbConn.ConnectionString = "Provider=msdaora;Data Source=XE;User ID=scott;Password=tiger"

dbConn.Open()

提示错误:ORA-06413:连接未打开.

Tip error: ORA-06413: Connection not open.

已经检查了 TNSNAMES.ora、SQLNET.ora、LISTENER.ora 并且没有问题.

Already check the TNSNAMES.ora, SQLNET.ora, LISTENER.ora and its nothing wrong.

但是为什么会出现这个错误呢?:(

But why this error appear? :(

推荐答案

错误是由路径名中的括号引起的.

The error is caused by the parenthesis in the pathname.

可能你从 C:\program file (x86) 执行 VS2012...

possibly you execute VS2012 from C:\program file (x86)...

解决方法:创建一个联结链接

workaround: create a junction link

步骤:

1. 来自:命令行执行

1. from: command line execute

C:>mkLink /j "Program Files x86" "Program Files (x86)"

然后

使用新路径(C:\program filex86...)

fix the (or create a new) shortcut with new path (C:\program file x86...)

这篇关于如何解决错误 ORA-06413:连接未打开?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！