linkserver error
From: SQL Apprentice (mssqlworld_at_yahoo.com)
Date: 03/30/04
- Next message: Deepankar: "RE: Sending query results to a text file"
- Previous message: Deepankar: "Re: Deadlock error"
- Next in thread: Samir Pandit: "RE: linkserver error"
- Reply: Samir Pandit: "RE: linkserver error"
- Reply: chris: "RE: linkserver error"
- Reply: Sue Hoegemeier: "Re: linkserver error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Mar 2004 14:12:28 -0800
Hello,
I created a job that uses a linkserver to Oracle db for the past year.
It ran fine until a few days ago when Oracle db schema changed.
I modified my SQL schema to be the same as theirs but I am still getting an
error.
I ran the following on Query Analyzer.
SELECT *
FROM OracleServer..TableName
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'Col1' (compile-time
ordinal 13) of object '"OraDB"."TableName"' was reported to have a DBTYPE of
130 at compile time and 5 at run time].
However, when I user OpenQuery...Then it worked.
SELECT *
FROM OPENQUERY(OracleServer, 'SELECT * FROM OraDB.TableName')
Can you give me some advice on how to fix this problem...
I have SQL 2000 Ent on W2K Server with latest service packs.
thank again for your help.
- Next message: Deepankar: "RE: Sending query results to a text file"
- Previous message: Deepankar: "Re: Deadlock error"
- Next in thread: Samir Pandit: "RE: linkserver error"
- Reply: Samir Pandit: "RE: linkserver error"
- Reply: chris: "RE: linkserver error"
- Reply: Sue Hoegemeier: "Re: linkserver error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
