Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set Location Command - Change in database Location ! Inputs please !!! 2

Status
Not open for further replies.
donv

donv

Programmer
Jun 11, 2001
18
US
Hi All
I have a problem related to Set Location and ODBC datasource.The following is the scenario.

OLD:
1)I have a set of CR files configured to a particular database server through an ODBC datasource.
2)Each of the files under this ODBC source point to a view in that database.

NOW:
1)The database has been moved from that machine to a different machine.
2)The ODBC Datasource with the SAME old name now is configured to the new machine (locally USER Level ODBC on my PC as well as in the File System ODBC on CR server m/c).
3)The database Log in information like connect string,Userid,Password is the SAME as the old database(Locally as well as on the CR server m/c)

PROBLEM:
1)All the old report files retain their design but need to be converted to the new database.
2)I get "Error Detected By database DLL" error.
3)Then I go to database SET LOCATION in that Report file and give login information and select that datasource(view)for that file all over again.The report runs.

ISSUE:
Manually for all the CR files,I need to repeat the above process for all Report files(in my case there a few hundred)which is painful! That means everytime a database changes,crashes or whatever I need to set location for all crystal report files ?? Do I need to do this? Is there any other way ??? Does CR Store that login info of a particular database somewhere? I am using Oracle 9i and CR8.These are basically web reports.
Please help me ...

Thanks
donv


 
Sort by date Sort by votes
What database platform are you using? (ie SQL Server, Oracle, MS Access, etc.)
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Upvote 0 Downvote
Ken,I new database I am NOW using is Oracle 9i ; The old database was oracle 8i
 
Upvote 0 Downvote
Ken ,many thanks.I have gone through the document.
Actually,I am getting this error becoz of the Dynamic change of the database(which the document says as one of the reasonds).That much is understood.The remedial action is taken by changing the VIEW definition to match the new database defintion.
My problem is: I have about 150 report files.Is there no other way other than changing all the difinitions manually by using the set location command ?

Please let me know
 
Upvote 0 Downvote
Dear Donv,

Try this at the link below.

This unsupported Crystal Utility (requires 8.0 Developer or 8.5) is supposed to allow you to perform printer and database changes on one or more reports (batch mode).


I did download this and found that it runs fine if you have 8.5 pro installed, but will not run with 8.0 pro. I didn't have time to play with it, but looks like it works.

Hope this is helpful,

ro

p.s. I originally saw this utility mentioned in one of the Crystal forums, I did a search and couldn't find it so I am sorry that I cannot credit the original poster!
Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Upvote 0 Downvote
Hi DONV,
I am having a same problem like u had before....did u get to solve it ? Let me know if u did find a solution.

Thanks,
Rajesh
 
Upvote 0 Downvote
One thing you might want to consider is "Verify Database" as the different Oracle versions present slightly different things to CR.

That might be the cause of your problem. Editor and Publisher of Crystal Clear
 
Upvote 0 Downvote
Hi Rosemary ,many thanks.
Your posting was helpful and you figured my problem perfectly.But unfortunately the utility is not working
as I am using an older version of crpe32.dll in Crystal8. I am using Crystal version 8.0.1.0 and I think that utility works for versions beyond that.

Thanks a Lot
Donv
 
Upvote 0 Downvote
Dear Donv,

The utility will work against Crystal 8.0 reports as I tested it against them. However, you must either have the developer version of Crystal or Crystal 8.5 (it is a specific dll that is needed).

I know that you can purchase an upgrade to Crystal 8.5 for around $200. You must decide if it is worth it to you.

Hope this helps,

ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Upvote 0 Downvote
Hi,

I also faces the same problem of my rpt file location that is not fix. My data file is *.dbf, and my VB application on runtime will look for my dbf file and my rpt file too to display it. However, I had problem changing my dbf file location in my application by code. Please kindly advise how to do it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Question
We're using command in crystal report
Replies
1
Views
198
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
140
SoftwareRT
SoftwareRT
VHDN
  • Locked
  • Question
Using Special File in Command
Replies
5
Views
172
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
248
hilfy
hilfy
TariqMehmod
  • Locked
  • Question
Database Fields : Command
Replies
3
Views
111
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top