| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBLink to SQL Server problem
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 manpowerprofile_at_msql tdispach> select "mpp_id" from manpowerprofile_at_msql where "mpp_id" = 'LESS';
mpp_id
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
ineyman_at_perceptron.com
> 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: 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).Received on Wed Apr 02 2003 - 10:43:50 CST
 |
 |