C#连接Oracle数据库

2025-07-16 13:14:48

1、下载“Oracle.ManagedDataAccess.dll”;

2、在工程中添加引用“Oracle.ManagedDataAccess.dll”;

3、引用命名空间“using Oracle.ManagedDataAccess.Client;”

4、连接数据库代码如下:publi罕铞泱殳c bool Connect(string hostaddress, string servername, string uid, string pwd){ string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="+ hostaddress +")(PORT=1521))(CONNECT_DATA=(SERVICE_NAME="+ servername +")));Persist Security Info=True;User ID="+ uid +";Password="+ pwd +";"; OracleConnection conn = new OracleConnection(connString); conn.Open(); if(conn.State==ConnectionState.Open) { conn.Close(); return true; } else { return false; }}

声明:本网站引用、摘录或转载内容仅供网站访问者交流或参考,不代表本站立场,如存在版权或非法内容,请联系站长删除,联系邮箱:site.kefu@qq.com。
猜你喜欢