Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Access query to Oracle tables via ODBC failing

Re: Access query to Oracle tables via ODBC failing

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/03/19
Message-ID: <6er47p$202$3@news00.btx.dtag.de>#1/1

On Thu, 19 Mar 1998 00:36:10 GMT, bbeishli_at_bdm.com (Ben Beishline) wrote: Hi,

>Hi there. I have a problem that I hope someone can help me with.
>
>We are migrating the back end of an Access 97 database to Oracle. I have the
>new Oracle tables created and populated, and linked in the Access database. If
>I open up the tables, I can see the data just fine, so it appears that the
>ODBC connection is working OK.
>
>Unfortunately, there are many queries that won't work, and I have been working
>for several days trying to figure out how to fix them, to no avail.
>
>It seems that whenever a query has both an outer join and an order by clause,
>things go bad. I get one of the 2 following error messages:
>
>ODBC - call failed (I click <OK>)
>[Oracle][ODBC Oracle Driver] [Oracle OCI] ORA-00936: missing expression (#936)
>
>or
>
><same as above except for> ORA-00933: SQL command not properly ended (#933)
>
>The sql expressions do have the proper semicolons at the end. If I change the
>query so it has only one or the other of outer joins and order by clauses, but
>not both, it works. Of course, that doesn't give me the data I want.
>
>I also can't get any SQL Passthrough query to work. When I try, I get:
>
>ODBC - call failed (I click <OK>)
>[Oracle][ODBC Oracle Driver] [Oracle OCI] ORA-00911: invalid character (#911)
>
>This happens with even the simplest query, such as:
>
>SELECT * FROM BPAC;
>
>(BPAC is the name of a table.)
>
>Has anyone seen these problems before? I'm using the Oracle73 ODBC driver.
>From what I've read, I believe that any query from access is supposed to work
>through ODBC on Oracle tables, although some should be rethought for the sake
>of network effeciency.
>
>I have tried the obvious soultion of having one query that pulls the data with
>the outer join, and then another that queries the first and sorts, but I still
>get the same error. I guess Jet is passing it to the server as one operation.
>
>Any help would be extremely appreciated. I'm fairly familiar with Access but
>know little about Oracle, and I've tried everything I can think of. All I can
>say is,
>
>help?
>
>I will be watching both newsgroups I'm posting this to, but my news server
>doesn't get all of the messages, so I would appreciate it if any answers are
>emailed to me as well as posted.
>
>Thanks,
>
>Ben Beishline

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de
Received on Thu Mar 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US