Crystal Reports 2008 and VS 2010

Dear Experts,

I converted a Vs2003 to VS2010 solution and migrated the reports from Crystal Reports 4 to Crystal Reports 2008. When I meant migration, I opened the reports and saved them in CR 2008.

Now in .net code, I replaced a following line of code
mReport.Database.Tables(intTable).SetDataSource(rs)
where rs is ADODB recordset

with
Report.Database.Tables(intTable).SetDataSource(rs)
here rs is dataset.

when I run the code, Im getting the following error
"Unknown Database Connector Error
Error in File Insert8x11 {FF45DD93-E337-400A-80DB-2E9529C608B9}.rpt:
Unknown Database Connector Error"

Could you please let me know what I'm missing here..

Thanks
Siva Manickam

Crystal ReportsVisual Basic.NET

Last Comment

sivaman

8/22/2022 - Mon

Nasir Razzaq

10/10/2011

I dont think crystal supports changing the TYPE of db (from ADODB to ADO.NET) that way.

Haver Ramirez

10/10/2011

When you use a Typed Dataset you only need to change the database

Rep.SetDataSource(Dts)

Whe you use a stored you must change the info of conexion

For Each connection As IConnectionInfo In Rpt.DataSourceConnections
connection.SetConnection(server, base, user, pass)
Next

sivaman

10/10/2011

ASKER

Dear CodeCruiser,

Could you please let me know how to do it then???

Thanks
Siva

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

Nasir Razzaq

10/10/2011

Try opening the report in designer, changing the db info and using a typed dataset and then use an instance of that typed dataset in SetDataSource in code.

Mike McCracken

10/10/2011

That is probably the issue. I suspect it is still looking for an ADODB connection.

mlmcc

sivaman

10/10/2011

ASKER

Im new to crystal reports..could you please show me an article where I can read completely about it..

Thanks
Siva

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION

Nasir Razzaq