Oracle的连接字符串 [英] Connection String for Oracle

问题描述

大家好，

我可以知道与oracle 10g客户端连接的可能的连接字符串和哪个最稳定的连接字符串吗?因为我处于连接和事务必须使用OleDBConnection或OdbcConnection的情况..
示例:

Hi all,

Can I know what is the possible connection string and what most stable connection string to connect with oracle 10g client? because I''m in a situation where the connection and transaction either must use OleDBConnection or OdbcConnection..
Example:

Private m_MSSQLCN As OleDbConnection
Private m_MSSQLTR As OleDbTransaction
Private m_ODBCCN As OdbcConnection
Private m_ODBCTR As OdbcTransaction

Public Overridable Function OpenConnection_OleDB() As OleDbConnection

If (Not IsNothing(m_MSSQLCN)) Then
    If (m_MSSQLCN.State = ConnectionState.Open) Then
        m_MSSQLCN.Close()
    End If

    m_MSSQLCN= New OleDbConnection(MyBase.DBConnString)
    m_MSSQLCN.Open()
    Return m_MSSQLCN
End If

End Function

或

or

Public Overridable Function OpenConnection_ODBC() As OdbcConnection

If (Not IsNothing(m_ODBCCN)) Then
    If (m_ODBCCN.State = ConnectionState.Open) Then
        m_ODBCCN.Close()
    End If

    m_ODBCCN = New OdbcConnection(MyBase.DBConnString)
    m_ODBCCN.Open()
    Return m_ODBCCN
End If

End Function

ReadOnly Property DBConnString() As String

Get
   Return "DSN=" & clsGlobVars.strDataSource & ";UID=" & clsGlobVars.strUserID &
          ";PWD=" & clsGlobVars.strPassword & ";"
End Get

End Property

目前，我正在为ConnStr使用DSN，UID，PWD.如果有人认识别人，请帮助我.
寻求专业人士的帮助..tq

Currently I''m using DSN,UID,PWD for ConnStr. If anyone know others,please help me..
Asking help from expertise for this..tq

推荐答案

我建​​议使用此 link 以获得可能的连接字符串格式.

I would suggest to go with this link for possible connection string formats.

这篇关于Oracle的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！