Pass Thru Query

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

I want to write a pass thru query to an ODBC Oracle
table. How can I do this? Is there a resource to help
with this?
 
Hi,
I do this against a sybase database. It should be
fairly similar. First, set up your ODBC data source.
Data sources is located under control panel on your pc.
Then, create a new query, close the show table dialog
box. On menu bar, select query, then select sql specific,
then select pass-through. This will allow you to enter
your sql. Then, you need to click on properties, to enter
your odbc connect information.
Hope this helps.
 
-----Original Message-----
Hi,
I do this against a sybase database. It should be
fairly similar. First, set up your ODBC data source.
Data sources is located under control panel on your pc.
Then, create a new query, close the show table dialog
box. On menu bar, select query, then select sql specific,
then select pass-through. This will allow you to enter
your sql. Then, you need to click on properties, to enter
your odbc connect information.
Hope this helps.
I will give it a try. Thanks!
.
Click to expand...
 
Back
Top