怎么把vs跟oracle关联起来

怎么把vs跟oracle关联起来

用using System.Data.OracleClient添加引用System.Data.OracleClient至少安装ORAcle9I的客户端，并在“控制面板-〉管理工具-〉服务”中打开oracle的监听程序。具体作法，首先必须将oralce的TNSNAMES.ORA文件中设定数据源名称。例如ASP.NET连接Oracle9i代码范例： MYORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SOFTSTAR)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = myoracle) ) ) ORA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 210.43.104.131)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora) ) ) 修改oracle目录下的文件SQLNET.ORA为 SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME,ONAMES)