Generic Connectivity

Hi,
i'm using a 8.1.7 DB on w2k machine to connect to a sqlserver 2000 also on a w2k machine.
i've managed to create a database link to the sqlserver using HS(Heterogeneous Services).
my problem certain selects returns to me with an error. i'm trying to run the next select :
select "name" from syscolumns_at_ppp where "id" = 357576312;

the error i get is :
select "name" from syscolumns_at_ppp where "id" = 357576312

       *
ERROR at line 1:
ORA-00904: invalid column name

for some reason i can't select a column of type sysname (that is what i saw the type is in sqlserver) using odbc and HS. did anyone ever encounterd a problem like this before ? any way around this ?

Thanks in advance.
Sagy Received on Wed Jan 16 2002 - 12:22:51 CET