Re: can't do ODBC pass-through from Access to Oracle

From: Robert Clevenger <robc_at_magicnet.net>
Date: 1998/01/03
Message-ID: <68km6c$sib$1@comet3.magicnet.net>#1/1

You need to remove the ; from after the word dual;

Take Care,

Robert Clevenger

David Shi wrote in message <68k3v9$h5v$0_at_204.179.92.104>...
>I am trying to test a very simple pass-through query from MS Access to
Oracle server:
> select sysdate from dual;
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00911:invalid charater.
(#911) Received on Sat Jan 03 1998 - 00:00:00 CST

This message: [ Message body ]
Next message: Mark Graham: "Here is a solution to transpose a table efficiently (columns to rows)"
Previous message: David Shi: "can't do ODBC pass-through from Access to Oracle"
In reply to: David Shi: "can't do ODBC pass-through from Access to Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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