×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

'42000:[Oracle][ODBC]Syntax error or access violation'

'42000:[Oracle][ODBC]Syntax error or access violation'

'42000:[Oracle][ODBC]Syntax error or access violation'

(OP)
I am trying to added an external vendor's stored procedure located in an Oracle database using Crystal Report 11.  This procedure requires three paramteres.  When I add the procedure using the database expert. A parameter window appears requesting 'Discrete Values' for all.  When I enter valid values in each parameter, an error message appears, 'Query Engine Error: '42000:[Oracle][ODBC]Syntax error or access violation'.  I am using the Oracle drive,ODBC(RDO).Thanks!

RE: '42000:[Oracle][ODBC]Syntax error or access violation'

Is there a particular reason why you're using ODBC instead of a native Oracle connection?  I've seen issues before with trying to access stored procs through an ODBC connection.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

RE: '42000:[Oracle][ODBC]Syntax error or access violation'

(OP)
Hi Dell,

There is no reason to use ODBC driver. Since I'm new to Crystal, i used to use OLE DB. Since OLD DB does not let me to use stored proc. I tried ODBC. Please let me know how to use native Oracle connection. Thanks in advance!

RE: '42000:[Oracle][ODBC]Syntax error or access violation'

Oracle is a connection option for the database in Crystal.  Just select that and enter the server and login info.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

RE: '42000:[Oracle][ODBC]Syntax error or access violation'

(OP)
Hi Dell,

I do not see any oracle option. I can see Access/Excel(DAO) option.

What I did was - I clicked the "Create new connection" and I'm going through the options.

Please let me know where do to look for the option.

Thanks!

RE: '42000:[Oracle][ODBC]Syntax error or access violation'

It sound like it may not have been installed with Crystal as it should be under "Create New Connection."  Can you update your install and make sure that Oracle is selected in the section that identifies which databases Crystal can access?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

RE: '42000:[Oracle][ODBC]Syntax error or access violation'

(OP)
Thanks Dell! I'll update the crystal installation!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close