Surround your column and table names with double-quotes (select "mpp_id" from...). I suspect that your SQL Server table was specified with lower-case columns.
> -----Original Message-----
> From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 02, 2003 6:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: DBLink to SQL Server problem
>
>
> 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).
>
