Solved

MSAccess Linking to Oracle via ODBC Driver  - Error ORA00911 Invalid Character

Posted on 2001-06-13
3
464 Views
Last Modified: 2012-06-27
I'm trying to link to an Oracle 8i (8.1.6) DB through MSAccess97. I'm using the Oracle ODBC Driver ().  I have done this successfully on several PCs, but on one PC, everytime I try to  open a table, I get an error ORA 00911 INVALID CHARACTER.  I'm certain that the data source name, login, and password names I'm using are correct.

Any help (even a pointer to where I can look up Oracle error codes) is much appreciated. Thanks!
0
Comment
Question by:DiscoDave2000
3 Comments
 
LVL 7

Accepted Solution

by:
q2eddie earned 50 total points
ID: 6187158
Hi, DiscoDave2000.

You can download a help file called SQL*Codes from the following link.

#Links
1. "SQL*Codes"
http://www.oraxcel.com/projects/sqlcodes/index.htm
(Click the download link and select the SQL*Codes item from the combobox on the next form.)

#From the chm file
ORA-00911

Cause:Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotes ("), this message will be issued.

Action:Remove the invalid character from the statement, or enclose the object name in double quotes.

Bye. -e2
0
 

Expert Comment

by:costello
ID: 6415485
If no objections are made in the next 5 days, I will force accept the contribution by q2eddie.

costello
Community Support Moderator @ Experts-Exchange

P.S. This post is made as part of the general effort to clean up this topic area, meaning, looping through all the open questions with no activity since 21 days.
0
 

Expert Comment

by:ComTech
ID: 6690977
Answer accepted by:

ComTech
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now