帮忙提供个连接字符串,已经通过立马给分。
vs2005+oracle81,利用如下的这种方式连接数据库
string OracleConnectionString = "Provider=msdaora;User ID=nlv_guest;Data Source=nlv;Password=guest"; OracleConnection MyOracleConnection = new OracleConnection(OracleConnectionString);
OracleCommand MyOracleCommand = new OracleCommand();
MyOracleCommand.Connection = MyOracleConnection;我这个提示说“不支持 provider”。请大牛详细的说下这种方式需要什么条件以及连接字符串是什么,多谢了。
vs2005+oracle81,利用如下的这种方式连接数据库
string OracleConnectionString = "Provider=msdaora;User ID=nlv_guest;Data Source=nlv;Password=guest"; OracleConnection MyOracleConnection = new OracleConnection(OracleConnectionString);
OracleCommand MyOracleCommand = new OracleCommand();
MyOracleCommand.Connection = MyOracleConnection;我这个提示说“不支持 provider”。请大牛详细的说下这种方式需要什么条件以及连接字符串是什么,多谢了。
没有配置的话可以用Net Configuration Assistant工具去配置一个
选那个 配置本地服务名.
Oracle XE (or "Oracle Database 10g Express Edition") is a simple version that's free to distribute.
Driver=(Oracle in XEClient);dbq=111.21.31.99:1521/XE;Uid=myUsername;Pwd=myPassword;
using System.Data.OracleClient; String strCnn = "Data Source=xxdb;user=xx;password=xx";
OracleConnection cnn = new OracleConnection(strCnn);
String strSql = "select * from xx";
OracleCommand cmm = new OracleCommand(strSql, cnn);
try
{
cnn.Open();
..
..
} 刚试了.
cmd = new OracleCommand();
dataApter = new OracleDataAdapter(); cmd.Connection = conn;
dataApter.SelectCommand = this.cmd;
dataApter.SelectCommand.Connection = conn;