.net连接oracle数据库

1)在服务器上需要安装oracle

client

2)增加.ora文件(安装目录下/newwork/admin)

3)可采用其他连接oracle工具判断是否能正确连上oracle

3).net连接oracle:

user

id=scottpassword=tigerdata

source=oracle92persist

security

info=trueunicode=trueomit

oracle

connection

name=true

注意data

source后为第二步的ora文件里的名称

1.打开 安装目录D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN文件夹下的tnsnames.ora文件,进行如下配置：

TOPTEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.10.9)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = toptest) ) )

在web.config文件中添加连接字符串,如：

<add name="OracleConn" connectionString="Data Source=TOPTESTUser ID=ds1Password=ds1Unicode=True" providerName="System.Data.OracleClient"/>

2.如果程序与数据库在同一台计算机上,则可以用这一连接。

<add name="OracleConn" connectionString="Data Source=10.100.1.9User ID=ds1Password=ds1Unicode=True" providerName="System.Data.OracleClient"/>

3.使用连接字符串访问数据库

public static readonly string connectionString = ConfigurationManager.ConnectionStrings["OracleConn"].ConnectionString

4.按照以上的步骤进行 *** 作，ASP.NET就能够成功地访问Oracle数据库

在web.config中配置：

’连接oracle

dim

strconnect

as

string

=

system.web.configuration.webconfigurationmanager.connectionstrings("conn").tostring()

dim

conn

as

oledb.oledbconnection

=

new

system.data.oledb.oledbconnection(strconnect)

’返回数据

public

function

gettable(byval

sql)

conn.open()

dim

comm

as

oledb.oledbcommand

=

new

oledb.oledbcommand(sql,

conn)

dim

da

as

oledb.oledbdataadapter

=

new

oledb.oledbdataadapter(comm)

dim

dt

as

system.data.datatable

=

new

system.data.datatable()

da.fill(dt)

conn.close()

return

dt

end

function

’返回受影响的行数

public

function

impactdate(byval

sql)

conn.open()

dim

comm

as

oledb.oledbcommand

=

new

oledb.oledbcommand(sql,

conn)

dim

i

as

integer

=

comm.executenonquery

return

i

end

function

---