我使用下面的DLL从客户端直接连接到Oracle。
oci.dll, Oracle.DataAccess.dll, oraociicus11.dll, OraOps11w.dll, orannzsbb11.dll, oraocci11.dll, ociw32.dll
连接字符串:
Dim oradb As String = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" _
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.128.33)(PORT=1521)))" _
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bipcdb)));" _
+ "User Id=msavameri;Password=123456;"
但是当我运行应用程序时,会发生以下错误:
ORA-28547: connection to server failed, probable Oracle Net admin error
以下是 Oracle.DataAccess 所需的文件列表:
oci.dll
Oracle.DataAccess.dll
orannzsbb11.dll
oraociei11.dll
OraOps11w.dll
确保所有这些文件都存在于客户端目录中。看起来您提供的列表可能缺少oraociei11.dll
.