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

2021-09-16 00:00:00 vb.net oracle

我的本​​地环境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...)

相关文章