Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle - heterogeneous services - SQL server
Forgot to mention..
The datatype of "FailureData" column is "bit" in SQL server.
"DGK" <Ganesh.Kamath_at_in.bosch.com> wrote in message
news:cjm4ct$8ov$1_at_ns1.fe.internet.bosch.com...
> Hello all,
>
> I have set up the heterogeneous services in my Oracle Db (8.1.7) to
connect
> to SQL server db located in another server. The connectivity and query
works
> fine for all the tables in SQL server except for few.
>
> e.g: select FailureData from sqltableATsqldb.world gives a error
ORA-00904:
> invalid column name. (here AT = @)
>
> Even select "FailureData" from sqltableATsqldb.world gives the same error.
>
> Could anybody let me know why it happens like this?
>
> thank you,
> GK
>
>
Received on Sat Oct 02 2004 - 06:53:30 CDT