Probably, because without double quotes Oracle was converting them to upper-case (on Oracle side before sending SQL to SQLServer) as it usually does, and they are not defined as upper case in SQLServer. So, double quotes prevented implicit conversion.
Igor ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 02, 2003 11:43 AM > Thanks Igor. I figured it out. I need double quotes around the column name and it works. Didn't see that mentioned in TFM. > > 1* select "mpp_id" from [EMAIL PROTECTED] > tdispach> select "mpp_id" from [EMAIL PROTECTED] where "mpp_id" = 'LESS'; > > mpp_id > -------- > LESS > > Thanks, > > Dave > > -----Original Message----- > Sent: Wednesday, April 02, 2003 9:19 AM > To: Multiple recipients of list ORACLE-L > > > Dave, > > SQL Server is case-sensitive, when it comes to table names, column names. > When stored in SQL Server data dictionary, they aren't converted into > upper-case, as it is with Oracle (unless you use quotes around names). > So, try to use the exact "case" when specifying field names (as they are > stored in SQL Server data dictionary). > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, April 02, 2003 9:34 AM > > > > I created a DBLink to a SQL Server database following DocID: 114820.1. It > seemed to work fine until I tried a real query. If I do something like a > SELECT COUNT(*) or SELECT * it works fine; > > > > tdispach> select count(*) from [EMAIL PROTECTED]; > > > > COUNT(*) > > --------- > > 1207 > > > > But if I try to select on a specific field or have a WHERE clause > specifying a filed I get this; > > > > tdispach> select mpp_id from [EMAIL PROTECTED]; > > select mpp_id from [EMAIL PROTECTED] > > * > > ERROR at line 1: > > ORA-00904: invalid column name > > > > I know that the column name is correct so something else is not > translating properly. I tried a fully qualified column name of > MANPOWERPROFILE.MPP_ID and that got the same error. I don't see any setting > in my DSN that could effect this. Anyone have any ideas, hunches or clues? > > > > Thanks, > > > > Dave > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Farnsworth, Dave > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Igor Neyman > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
