asp.net 连接oracle数据库（急）

ghost225 2004-04-01 01:06:55

请问各位高手，怎样用asp。net连接oracle数据库啊，最好能给出连接语句，万分感谢！！！

...全文

142 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

zhpsam109 2004-04-01

打赏
举报

哈哈，好网！

hychieftain 2004-04-01

打赏
举报

楼上已经说的很清楚了，再给你一个网页参考
http://www.connectionstrings.com/

wangsaokui 2004-04-01

打赏
举报

connectstring="user id=你的用户名称;data source=BXHAPL4（你在tnsnames.ora文件中的数据库名称，看下面的文件）;password=你的数据库口令")

当然你必须有tnsnames.ora文件，类似于
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

BXHAPL4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CNABB-ATPM-WSK)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BXHAPL4.ABB.COM)
(SID = BXHAPL4)
)
)

MASTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnabb-atpm-wsk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = master)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnabb-atpm-wsk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

这样你的连接字符串就知道从这个文件中找到自己需要连接数据库的IP地址，端口以及其他的连接参数。

ghost225 2004-04-01