Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I'm using Active Reports Subreport tool, I want to bind data source in ActiveReport_ReportStart as script by connecting Oracle. I'm using the script below but I'm having this error: Error Message:[DBNETLIB][Connection Open (Connect()).]SQL Server does not exist or access denied. Invalid connection string attribute.

C#
public void ActiveReport_ReportStart()
{
string connString = "Provider=SQLOleDB;User Id=XXX;Password=XX;Server=XXX;Service      Name=XX;Direct=True;Persist Security Info=True";
string sqlString = @"sql query";
DataDynamics.ActiveReports.DataSources.OleDBDataSource ds = new     DataDynamics.ActiveReports.DataSources.OleDBDataSource();
ds.ConnectionString = connString;
ds.SQL = sqlString;
rpt.DataSource = ds;
}


it is actually oracle connection, so ı changed the connection string to :
Devart.Data.Oracle.OracleConnection con = new Devart.Data.Oracle.OracleConnection(); con.ConnectionString = "POOLING=FALSE;User Id=XX;Password=XX;Server=XX;Direct=True;Sid=XX;Persist Security Info=True";
DataTable dt = new DataTable();
Devart.Data.Oracle.OracleDataAdapter da = new Devart.Data.Oracle.OracleDataAdapter(sqlString, con);
da.Fill(dt);
sbrpt.DataSource = dt;

But this time I'm having "Type or namespace Devart could not be found!"

I have tried ;
arDesigner.Report.AddScriptReference("Devart.Data.Oracle.dll");
but it does not work!

Thanks in advance...
Posted
Updated 8-Aug-12 2:08am
v4
Comments
kubi081 8-Aug-12 2:23am    
any idea?

1 solution

Add references to both Devart.Data.dll and Devart.Data.Oracle.dll. If this doesn't help, please create a small test project and send it to our support team via
http://www.devart.com/company/contact.html.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900