Where clause query does not give correct result

Moazzam munir <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I have installed freetds ( 0.82 ) on Linux machine.

I am trying to access SQLSERVER (installed on different machine) tables from
oracle ( installed on the same Linux machine ) SQLPLus editor.

Now when i execute the following SQL statement from Oracle

select table_schema,table_name
from information_schema.tables@sqlserver
where upper(table_name) not like '%_CHANGES%'

Then query returns me ???????? in the both columns.

This does not always happen. Some times it gives me correct result when i
disconnect and reconnect.

One more thing, this problem happens only when i use where clause in the
query Otherwise it works fine.

Can anybody please help me?
-- 
Thanks,
Moazzam Munir
Senior Software Engineer
Strategic Systems International
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.