# tnsnames.ora Network Configuration File: D:\OraHome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
medicare =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)最后这个medicare是我要添加的一个数据库,那个orcl是安装数据库时建的一个数据库,我这个medicare数据库添加对了没有,现在连不上medicare这个数据库,请问哪里出了错
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
medicare =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)最后这个medicare是我要添加的一个数据库,那个orcl是安装数据库时建的一个数据库,我这个medicare数据库添加对了没有,现在连不上medicare这个数据库,请问哪里出了错
<add key="connstr" value="User ID =redt_eps;Password =123aaa;Data Source=medicare; Max Pool Size = 300"/>
</appSettings> 这是web.config中连接数据库的!
先这样试试。应该是你的连接有问题……
另,计算机名叫LAN,真是一件比较神奇的事