 |
| Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
June 8th, 2006, 04:25 PM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Database connectivity - pls help
Hi,
Crystal reports are developed on one system that will have SQL Server database using ODBC-RDO object getting the data.
I copied the Crystal reports another system and Installed SQL server & restore the database.
Crystal reports are not showing the data. it's popup the error.
pls help me How to connect database & reteriew the data.
thanks in Advance
|
|
June 8th, 2006, 11:24 PM
|
|
Friend of Wrox
|
|
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello,
ODBC-RDO and .NET? Are you missing something?
ODBC-RDO and VB 5.0/6.0 is fine and nice pair, but not with .NET, where you
use ADO.NET
And, by the way, what is the error it popups?
okay, check this
http://p2p.wrox.com/topic.asp?TOPIC_ID=4585
Hovik Melkomian has given nice reply there, follow it and you might some
ideas to fix your CR problem
Hope this helps.
With Regards,
Raghavendra Mudugal
|
|
June 9th, 2006, 11:29 AM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
quote:Originally posted by Raghavendra_Mudugal
Hello,
ODBC-RDO and .NET? Are you missing something?
ODBC-RDO and VB 5.0/6.0 is fine and nice pair, but not with .NET, where you
use ADO.NET
And, by the way, what is the error it popups?
okay, check this
http://p2p.wrox.com/topic.asp?TOPIC_ID=4585
Hovik Melkomian has given nice reply there, follow it and you might some
ideas to fix your CR problem
Hope this helps.
With Regards,
Raghavendra Mudugal
|
|
|
June 9th, 2006, 11:32 AM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi,
Iam using Crystall Reports XI. those reports viewing through Jboss & J2ee. In Crystall Designer it self the data is not coming.. how to reset the new database information.. pls help
|
|
June 9th, 2006, 11:38 AM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi,
error : login failed once we click OK then it's shows another one
"Failed to retrieve data from the database
Details:42502:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'TableName'.[Database Vendor Code:208]"
thanks & regards
N Mure
|
|
June 9th, 2006, 11:33 PM
|
|
Friend of Wrox
|
|
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello,
Change the location of the object which you are using in the report.
There you have to select the new server DB, then table or SP or view,
then you have to click the button, to get effect of the new DB to the
existing report which was created w.r.t another sql server.
I dont know where it is now in XI version, but it something like
"Set Locations" there you have to select the new DB details and click
"Replace Button".
Hope this helps.
With Regards,
Raghavendra Mudugal
|
|
June 13th, 2006, 01:15 PM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi.. Thanks Raghavendra Mudugal,
Using u r tips i solved the problem.. thanks a lot
|
|
|
