Linked Server [Oracle] error

Hi,
I've created a linked server to an Oracle 8.1.7 database
successfully, and can see the list of tables and views.
However, when I try to issue a select against one of the
tables I get the following error:
============================================ Server: Msg 7356, Level 16, State 1, Line 1
...
OLE DB error trace [Non-interface error:
Column 'TRANS_ID' (compile-time ordinal 1) of
object '"KOP_ADMIN"."PP_TRANSPORT"' was reported to have a
DBTYPE of 130 at compile time and 5 at run time].
============================================
Has anyone successfully solved this error?
TIA,
SJTYou might check out MSKB 280106:
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"SJT" <scott.taylor@.pwcs.com.au> wrote in message
news:054b01c36ad9$f41489a0$a501280a@.phx.gbl...
> Hi,
> I've created a linked server to an Oracle 8.1.7 database
> successfully, and can see the list of tables and views.
> However, when I try to issue a select against one of the
> tables I get the following error:
> ============================================> Server: Msg 7356, Level 16, State 1, Line 1
> ...
> OLE DB error trace [Non-interface error:
> Column 'TRANS_ID' (compile-time ordinal 1) of
> object '"KOP_ADMIN"."PP_TRANSPORT"' was reported to have a
> DBTYPE of 130 at compile time and 5 at run time].
> ============================================>
> Has anyone successfully solved this error?
> TIA,
> SJT