It's more accurate to say SQL Server *can be* case sensitive ... or not, as desired and configured. The kicker is as you describe ... if it's set to be case sensitive instead of insensitive, all object names, column names, etc. are treated that way, not just strings in char, varchar and similar fields.
Ciao Fuzzy :-) > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Igor Neyman > Sent: Wednesday, April 02, 2003 16:19 > To: Multiple recipients of list ORACLE-L > Subject: Re: DBLink to SQL Server problem > > > 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: Grant Allen 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).
