首先是添加ORACLE和SQL Server的引用（reference）,ORACLE用的是它自带的类库
Imports
System.Data.SqlClient
Imports
Oracle.DataAccess.Client
在app.config里面设好connection string,具体如下：
<
appSettings
>
<
add key
=
“
SQLServerConnectionString
“
value
=
“
Data Source=MAPPA03C;Initial Catalog=LVSS;Integrated Security=True
“
/>
<
add key
=
“
OracleConnectionString
“
value
=
“
DATA SOURCE=lvnet;PASSWORD=lvss;PERSIST SECURITY INFO=False;USER ID=LVSS
“
/>
</
appSettings
>
然后便是在获得SQL Server和Oracle连接.
‘
——————————————————————–
‘
Function: GetSQLServerConn()
‘
Description: Implement the connection to SQL server database with the connection string in app.config
‘
Input:
‘
Remark:
‘
——————————————————————–
Public
Shared
Function GetSQLServerConn()
Function GetSQLServerConn() As SqlConnection
Dim conn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings(“SQLServerConnectionString“)) conn.Open() Return conn
End Function ‘
——————————————————————–
‘
Function: GetOracleConn()
‘
Description: Implement the connection to oracle database with the connection string in app.config
‘
Input:
‘
Remark:
‘
——————————————————————–
Public
Shared
Function GetOracleConn()
Function GetOracleConn() As OracleConnection
Dim conn As New OracleConnection(System.Configuration.ConfigurationManager.AppSettings(“OracleConnectionString“)) conn.Open() Return conn End Function
转载于:https://www.cnblogs.com/iswszheng/archive/2009/04/23/1441954.html
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/110921.html原文链接：https://javaforall.net
