Pass Thru Query

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?
 
L

Les

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.
 
G

Guest

-----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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-Through Query Error 1
Using Bind Variables in pass-thru query to Oracle DB. 1
Setting ODBC Connection string of Pass thru query dynamically 1
SQL Pass Thru from normal qry 2
Incorrect date in pass-thru query 1
ODBC Pass-Through Queries 2
Pass Thru Query / Criteria 1
Pass Parameter to stored procedure in pass thru query 7

Top