(Marcus B.) wrote:

>Hi all!
>
>I have a serious problem....(Who doesn´t...;)
>
>I have a SQL Server 2000 and a Oracle 8.1.7 Database. I have set up a
>number of views in SQL Server that are populated via a linked server
>connection. In almost all cases this works great, but for one view.
>The view displays OK, BUT one column from the source database
>table(Oracle) is missing.
>
>The syntax I am using to create the view is:
>CREATE VIEW TEST as SELECT * from (openquery('server','select * from
>sometable'))
>
>If i try to add the missing column name in the last section of the
>statement, i get a provider error, something like "Unknown error".
>
>The missing column is of type char(4) and can be null.
>
>Any ideas?
>
>/M