Pass-Through Query Error

I am trying to setup a pass-through query with the below SQL

SELECT FIN_CUR_CURE_CYCLE_SIDE_DATA.MOLD_REV_NUM
FROM FIN_CUR_CURE_CYCLE_SIDE_DATA;

When I run this as a select query I am prompted to log into the Microsoft
ODBC for Oracle connection and when I do the query returns the correct
results. When I set this up as a pass-through query and run it I get the
following error

ODBC--call failed.
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid character (#911)

What am I doing wrong?

jutlaux wrote:
I am trying to setup a pass-through query with the below SQL

SELECT FIN_CUR_CURE_CYCLE_SIDE_DATA.MOLD_REV_NUM
FROM FIN_CUR_CURE_CYCLE_SIDE_DATA;

When I run this as a select query I am prompted to log into the
Microsoft ODBC for Oracle connection and when I do the query returns
the correct results. When I set this up as a pass-through query and
run it I get the following error

ODBC--call failed.
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid
character (#911)

What am I doing wrong?

Unless it's the semicolon at the end, you will probably need to ask in an
Oracle group

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"