Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Verify Database problem Post Reply Post New Topic
Author Message
matei.costescu
Newbie
Newbie


Joined: 10 Apr 2009
Online Status: Offline
Posts: 1
Quote matei.costescu Replybullet Topic: Verify Database problem
    Posted: 10 Apr 2009 at 7:52am
Hi,

I want to add a new database field on an existing report. I updated the cursor that the procedure returns to the report, but I can't see the new field in Crystal Report.

I think that "Database -> Verify Database" should update the fields that are present in the cursor, but I get this error:
ODBC error: [Oracle][ODBC]Syntax error or access violation.

Can you help me?

I use Seagate Crystal Reports Professional, Product 7.0.1.100
IP IP Logged
Tech
Newbie
Newbie
Avatar

Joined: 12 Jan 2011
Location: United States
Online Status: Offline
Posts: 1
Quote Tech Replybullet Posted: 12 Jan 2011 at 8:56am
I am also getting the same.
 
'Syntax error or access violation'
 
Please help me........
 
 
help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help help
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 14 Jan 2011 at 9:01am
Crystal can be picky about how it "sees" stored procedures.  Try going to "Set Database Location".  Create a new connection that connects to the same database as your existing connection.  Then change the location of the stored procedure to the new connection.  This should refresh the metadata so that Crystal can see the new field.
 
-Dell
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.000 seconds.