Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: Trouble verifying database Post Reply Post New Topic
Author Message
xoleigh
Newbie
Newbie


Joined: 19 May 2010
Online Status: Offline
Posts: 5
Quote xoleigh Replybullet Topic: Trouble verifying database
    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.
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet 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
IP IP Logged
xoleigh
Newbie
Newbie


Joined: 19 May 2010
Online Status: Offline
Posts: 5
Quote xoleigh Replybullet 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.
IP IP Logged
suresh123
Newbie
Newbie


Joined: 15 Sep 2010
Location: India
Online Status: Offline
Posts: 1
Quote suresh123 Replybullet 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.



JML | Learning Resources
IP IP Logged
heidy12
Newbie
Newbie


Joined: 10 Jan 2011
Online Status: Offline
Posts: 1
Quote heidy12 Replybullet 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
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.016 seconds.