Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-25 : 14:07:52
|
| Jeff writes "I have a linked server, Oracle 8i ;-(I see the tables, but am having difficulty writing queries to access the data.The servers' name, at least what I named it, is "FLEX_PM".Here's the query:select INSTANCE_ID from FLEX_PM..FLEXPM.ENT_TABLEWhen I try to run a query, I get the following message:Server: Msg 7356OLE DB Provider 'MSDORA' supplied inconsistant metadata for a column.The datatype of this column is NUMERIC(38) on the Oracle Server.I've even tried convert(int,INSTANCE_ID).Any ideas?ThanksJeff Motter " |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-04-25 : 18:31:35
|
| Does this link help? [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;251238[/url]------------------------------------------------------The more you know, the more you know you don't know. |
 |
|
|
|
|
|
Querying a linked server