<div>
I have tried both ways. &nbsp;If within, the query returns the column is unknown. &nbsp;If outside, then the query fails to return and timesouts. <br />
<br />
Glass
</div>


I have tried both ways.  If within, the query returns the column is unknown.  If outside, then the query fails to return and timesouts.

Glass

<div>
htarlow,<br />
<br />
You pointed me in the right direction... <br />
<br />
Thanxs,<br />
Glass
</div>


htarlow,

You pointed me in the right direction...

Thanxs,
Glass

<div>
<div class="content wysiwyg-content">
Would like help to query a view for data using openquery on a machine running Win2k server and SQL server 2000. &nbsp;The remote machine is running Oracle 816. &nbsp;<br />
<br />
My general download query works:<br />
<br />
select * from openquery(LinkServer, 'select * from tbl_name')<br />
<br />
Would like to add a where clause-&gt; &nbsp; &nbsp;where col_name like &quot;2003%&quot; &nbsp;but erroring out with doesn't recognize column. &nbsp;Have tried various combinations of naming but to no avail. &nbsp; <br />
<br />
Oracle DB<br />
Schema -&gt; Enterprise<br />
table owner for remote db -&gt; unknown<br />
userid for remotedb -&gt; user_id<br />
table name -&gt; tbl_name<br />
column name -&gt; col_name<br />
<br />
Thanxs,<br />
Glass<br />
<br />
<br />

</div>
</div>


Would like help to query a view for data using openquery on a machine running Win2k server and SQL server 2000.  The remote machine is running Oracle 816.  

My general download query works:

select * from openquery(LinkServer, 'select * from tbl_name')

Would like to add a where clause->    where col_name like "2003%"  but erroring out with doesn't recognize column.  Have tried various combinations of naming but to no avail.   

Oracle DB
Schema -> Enterprise
table owner for remote db -> unknown
userid for remotedb -> user_id
table name -> tbl_name
column name -> col_name

Thanxs,
Glass




Openquery and where clause

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.