Avatar of sivaman
sivaman
Flag for United States of America asked on

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

Avatar of undefined
Last Comment
sivaman

8/22/2022 - Mon
Nasir Razzaq

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

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

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

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

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

mlmcc
sivaman

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

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
sivaman

ASKER
Thanks