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:DFarnsworth_at_Ashleyfurniture.com]
> 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 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: Jeremy Pulcifer
INET: Jeremy.Pulcifer_at_kadiri.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).
Received on Wed Apr 02 2003 - 11:19:22 CST
