?
Solved

Crystal Reports 2008 and VS 2010

Posted on 2011-10-10
8
Medium Priority
?
495 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:sivaman
8 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36944869
I dont think crystal supports changing the TYPE of db (from ADODB to ADO.NET) that way.
0
 
LVL 8

Expert Comment

by:Crashman
ID: 36944935
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


0
 

Author Comment

by:sivaman
ID: 36944956
Dear CodeCruiser,

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

Thanks
Siva
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36944977
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.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36945074
That is probably the issue.  I suspect it is still looking for an ADODB connection.

mlmcc
0
 

Author Comment

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

Thanks
Siva
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 2000 total points
ID: 36945455
0
 

Author Closing Comment

by:sivaman
ID: 36949737
Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question