Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Changing datasource = problems! Post Reply Post New Topic
Author Message
nlc19
Newbie
Newbie


Joined: 16 Jun 2011
Online Status: Offline
Posts: 1
Quote nlc19 Replybullet Topic: Changing datasource = problems!
    Posted: 16 Jun 2011 at 5:03am
Hi,
Am hoping someone can help me.  One of our applications was recently upgraded and this also involved the SQL database being renamed. (SQL2005).  I have a load of Crystal reports which all point to the previous named database.
 
I have tried to update the report using the Database > Set Datasource Location and this is now showing the new Database name.
 
However, if I run the report it is still pulling information from the old Database.  If I click on Database > Show SQL query it shows the name of the old database, not the new one which is now showing as the Datasource Location.
 
This is Crystal XI.  Any ideas?  Thanks in advance.
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 16 Jun 2011 at 1:10pm
If the Tables and Fields names aren't identical to the old database you have to remap the data fields.It seems to me though you should be getting an error message instead of the report running at all.I wonder if the Set Datasource Location box isn't recognizing them as the same and you just think it's changing.Whenever i change one the report properties changes to "False" and I have to edit it to say "True" or the report throws a Database Connection Error.
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 19 Jun 2011 at 11:42pm
sometimes, i have found that you have to the set location on all the tables, not just the connection.
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 20 Jun 2011 at 12:00pm
Originally posted by Dewald

sometimes, i have found that you have to the set location on all the tables, not just the connection.



Yea,you're right.in Crystal 10 after you've changed the database name you have to go under properties for each table and double click the "Overridden Qualified Table Name:" and retype the name of the table.Don't forget the subreports either.
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 06 Jul 2011 at 4:53am
make sure you verify the database to pull in the new values
sharona
IP IP Logged
keithme
Newbie
Newbie
Avatar

Joined: 19 Jan 2013
Online Status: Offline
Posts: 2
Quote keithme Replybullet Posted: 19 Jan 2013 at 2:15pm
I have this same problem. Verifying the Database just says its ok. ALL Table Names (and fields) are the SAME. None of the above seems to help.

My sql code also still says the OLD Database name.. can we EDIT this code??

Hope someone can help!!!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 22 Jan 2013 at 6:04am
This has been an issue for some time.  The only way that I have been able to 'fix' it is to update data source table by table (Set Datasource Location).

I hope this helps.
IP IP Logged
keithme
Newbie
Newbie
Avatar

Joined: 19 Jan 2013
Online Status: Offline
Posts: 2
Quote keithme Replybullet Posted: 22 Jan 2013 at 12:20pm
Looking at: http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=13766 I found the second entry said:

Click on Database (menu item on top of the screen)
click Log on or off Server (Data Explorer window should open up)

Being in despair (as nothing had helped and this didn't look like my answer) I DID click ==LOG ON OR OFF SERVER==

Nothing seemed to happen but when I went back to the report IT HAD MY NEW DATA THERE!!!!!!

Wonderful!!

So we should all make sure to click the "Log On of Off Server" FIRST as I guess that breaks the OLD connection and ALLOWS the NEW!!

Worked for me anyway.. thanks to user "CrystalDesigner".

:)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.