请问水晶报表PUSH模式中OleDb连接Oracle数据库的连接字符串怎么写？ 急！！ 在线等！！

[firstchen]

水晶报表PUSH模式中创建Access数据库的连接可以如下：
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:\\×.mdb; Persist Security Info=False;";
OleDbConnection MyConnection = new OleDbConnection(strConnection);

请问OleDb连接Oracle数据库的连接字符串怎么写？

[cpbeoms]

用OracleConnection不是更好吗
Data Source=表空间;User Id=用户名;Password=密码

[xwdd129]

Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle


Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"


Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"