RE: DBLink to SQL Server problem

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: root_at_fatcity.com [mailto:root_at_fatcity.com]On 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
> ineyman_at_perceptron.com
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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 manpowerprofile_at_msql;
> >
> > 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 manpowerprofile_at_msql;
> > select mpp_id from manpowerprofile_at_msql
> > *
> > 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: DFarnsworth_at_Ashleyfurniture.com
> >
> > 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: ListGuru_at_fatcity.com (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: ineyman_at_perceptron.com
>
> 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: ListGuru_at_fatcity.com (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: grant_at_towersoft.co.uk

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: ListGuru_at_fatcity.com (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).