Print Page | Close Window

Trouble verifying database

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10320
Printed Date: 27 Apr 2024 at 11:58pm


Topic: Trouble verifying database
Posted By: xoleigh
Subject: Trouble verifying database
Date Posted: 22 Jun 2010 at 3:24am
Hi All
 
I'm new to Crystal reports and in desperate need of your help. I am trying to make changes to an existing report. I have made the required changes in the SQL stored procedure, I am however working on my Localhost server. I need to implement these changes on the Localhost first before implementing them on the live server.
 
When I run the report on live it works perfectly, but as soon as I switch servers it throws an unknown error. I noticed that it tries to convert my date parameters to 'Datetime' again during execution. Why is this? Because this does not happen when I run the report on the live server.
 
Your help will be highly appreciated.


Replies:
Posted By: Emir_W
Date Posted: 28 Jun 2010 at 9:49pm
try to help.
when you are in localhost server, have you try to verify it? what is the result?
same thing for live server. what is the result when you verify the report?
 
just a sily question:
is the setting for both server, localhost and live server, are same?
e.g.: collation, etc.
 
 


-------------
Emir W

Posted By: xoleigh
Date Posted: 09 Jul 2010 at 4:12am
Thanks for your response.

When verifying from my local DB it inserts a 'convert' function when processing the date parameters and then throws an exception saying 'invalid character near convert'.

When i tried verifying via the live DB it gave me the opposite error. Saying iI'm missing the 'convert' function.

Posted By: suresh123
Date Posted: 15 Sep 2010 at 6:11pm
Okay, my simple suggestion is to connect to mysql using the command line, with that username and password with that database

mysql -D empdb -u root -p

If you can't do that, then clearly you have a problem with mysql itself.
You'll need to install mysql of course, have a schema called empdb,
and a user called root (almost always there, but bad practice to use this account daily)
with the correct password

also, as pointed out prior, the $sql query itself looks like a syntax error.



http://www.worldwideshoppingmall.co.uk/potteryshop/nicer-dicer.asp - JML | http://www.worldwideshoppingmall.co.uk/toys/educational-literacy.asp - Learning Resources

Posted By: heidy12
Date Posted: 10 Jan 2011 at 5:51pm
I'm new to Crystal reports and in desperate need of your help. I am trying to make changes to an existing report. I have made the required changes in the SQL stored procedure, I am however working on my Localhost server. I need to implement these changes on the Localhost first before implementing them on the live server.
Your suggestions about it will be highly appreciated.


-------------
heidy


Print Page | Close Window