If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Pass-Through Query Error
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" |
Thread Tools | |
Display Modes | |
|
|