Click here to Skip to main content
11,932,681 members (50,411 online)
Rate this:
Please Sign up or sign in to vote.
See more: Reporting
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 21:52pm
Edited 8-Aug-12 3:08am
kubi081 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151126.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