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
Joined: 12 Jan 2011
Location: United States
Online Status: Offline
Posts: 1
Posted: 12 Jan 2011 at 8:56am
I am also getting the same.
'Syntax error or accessviolation'
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
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
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.
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