Print Page | Close Window

Verify Database problem

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=6045
Printed Date: 04 May 2024 at 3:59am


Topic: Verify Database problem
Posted By: matei.costescu
Subject: Verify Database problem
Date 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


Replies:
Posted By: Tech
Date 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

Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window