Click here to Skip to main content
11,718,289 members (89,211 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: active Reports
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.

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);
sbrpt.DataSource = dt;

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

I have tried ;
but it does not work!

Thanks in advance...
Posted 6-Aug-12 20:52pm
Edited 8-Aug-12 2:08am
kubi081 at 8-Aug-12 2:23am
any idea?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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

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

  Print Answers RSS
0 OriginalGriff 215
1 F-ES Sitecore 210
2 Maciej Los 140
3 Jochen Arndt 120
4 Andy Lanng 115
0 OriginalGriff 535
1 Maciej Los 529
2 Richard MacCutchan 440
3 CHill60 415
4 F-ES Sitecore 415

Advertise | Privacy | Mobile
Web01 | 2.8.150901.1 | Last Updated 15 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100