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).
