oracle配置问题 [英] problem with oracle configuration

问题描述

此代码有问题，这是我第一次使用oracle. :)
请帮帮我.我正在使用VS 2008

导入System.Data.OracleClient
导入System.Configuration.ConfigurationSettings

公共类DBConnection

Dim _Conn作为System.Data.OracleClient.OracleConnection


公共函数OracleConString()作为字符串
返回数据源=& AppSettings("DataSource")& _
;用户ID ="& AppSettings("DBUserID")& _
;密码="& AppSettings("DBPassword")

最终功能

公共函数OracleConn()作为System.Data.OracleClient.OracleConnection
_Conn =新的System.Data.OracleClient.OracleConnection(OracleConString)
返回_Conn
最终功能
End Class

I''m having problem with this code, this is my first time to use oracle. :)
Help me please. I''m using VS 2008

Imports System.Data.OracleClient
Imports System.Configuration.ConfigurationSettings

Public Class DBConnection

Dim _Conn As System.Data.OracleClient.OracleConnection


Public Function OracleConString() As String
Return "Data Source=" & AppSettings("DataSource") & _
"; User ID=" & AppSettings("DBUserID") & _
"; Password=" & AppSettings("DBPassword")

End Function

Public Function OracleConn() As System.Data.OracleClient.OracleConnection
_Conn = New System.Data.OracleClient.OracleConnection(OracleConString)
Return _Conn
End Function
End Class

推荐答案

我认为您需要测试此连接字符串格式，可能会解决您的问题..

i think you need to test this connection string format, might be it will solve your problem..

<add name="CONNECTIONSTRINGNAME" connectionstring="Data Source=(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=yes)(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.244)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.244)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.244)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.244)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=YOURORACLESERVICENAMEHERE)));User Id=system;Password=Softweb#123;" providername="System.Data.OracleClient" />

这篇关于oracle配置问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！