Set Location

[mnasuto]

Hi,

I am using CR 8.0, and SQL database, ODBC connection.
My reports where working correctly thru application(VB) and from CR.

I moved database to new server.

I create new DSN and Set new location for reports.
After that, all reports are working running from Crystal, but they not working then run from application(VB).

Please help me if you can.

Best,
Marta

 

[kenhamady]

You might have code in the app that logs into the DSN, and you have to update the code in the app. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mnasuto]

Dear Ken,

Thanks for your response.

We are not using runtime code to connect to the data source,
we using NT security.

My reports are based on store procedures with parameters.
All reports work fine in the old location.

After moving database and reports to the new location they are not running through application, but they are working through CR.
I did some experiments with these reports.
They are working through application if I eliminate parameters from store procedures.

If is some problem with parameters why reports are working in CR and in old location?

Best,
Marta

 

[kenhamady]

What happens when they don't work? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mnasuto]

Dear Ken,

Thank you for follow up.
I get help from Segate Support and everything is ok now.


I was getting 20599 error.

I changed location by using Set Location but I did not removed database and Owner-look step 3 below. I still do not undestund why Set Location-Set Location is not working!!!!!!

In case if someone has this same problem I am placeing Crystal Support Solution below.


Crystal Support Advise:

The following steps illustrate how to successfully change the Server and Stored Procedure:

In the Crystal Report Designer:
1. Open the report.
2. On the 'Database' menu click 'Set Location'
3. In the 'Table' box remove the Database and Owner. For example:
'pubs.dbo.Proc(byroyalty;1)' becomes 'Proc(byroyalty;1)'
4. Click 'OK' and save the report

In Microsoft Visual Basic:
1. Open the application
2. Enter the following code to change the Server and Store Procedure

'Connect to the new server
CrystalReport1.Connect = "DSN=NewServername;UID=username;PWD=password;DSQ=databasename"

'Change the Stored Procedure
CrystalReport1.Datafiles(0) = " Proc(Newbyroyalty;1)


Best,
Marta

 

[mnasuto]

Hi Ken,

I have this same problem again.

I applied above Crystal Support suggestions.
Everything worked fine.

So all reports working fine on new server.
Then I changed Stored Procedure for report(new server). Now report is based on new Stored Procedures with different names.

To change SP:
1.I went to Set Location-Set Location for new SP
2.In the 'Table' box I removed the Database and Owner.
3.I verified database.


Results: This same error as before.Reports are working through Crystal but not through application on client machine. It works through application on developer machine. Error is this same as before-20599.

Please help if you can.
Best,
Marta

 

[kenhamady]

Did you update the application commands code with the new DSN and SP information? I think there are several connectivity problems that will generate this error.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mnasuto]

Dear Ken,

Thanks for following up.
I just notice that I stil had in SP name of old SP as I created new SP by coping old one.
After name correction report is working.

I am wonder how this report worked at all in CR and through application on developer machine!

Thanks Ken,
Best,
Marta