Results 1 to 4 of 4

Thread: Odbc

  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Unanswered: Odbc

    We are using Oracle as the DB for our Financial System. As an additional report-writing tool, we use MS Access that connects to Oracle thru ODBC. My question is, where is the actual retrieving, extracting & manipulating of data done? Is it on the user's workstation or on the server?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If you are using Access ... It is probably pulling the data across the wire and changing it on the local machine ... I know that if you do queries in Access
    and have condition statements, the entire result set is set across and "conditioned" out in the local machine ...

    HTH
    Gregg

  3. #3
    Join Date
    Jun 2004
    Posts
    2
    I thought that Access will send a SQL statement (based on the Query with several conditional parameters) and send it to the Oracle Server. Oracle will then return just the results of the query to MS Access. So, I thought wrong?

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Quote Originally Posted by THizon
    We are using Oracle as the DB for our Financial System. As an additional report-writing tool, we use MS Access that connects to Oracle thru ODBC. My question is, where is the actual retrieving, extracting & manipulating of data done? Is it on the user's workstation or on the server?
    Hi,

    It would depend on your setup...
    If you have linked tables and your query-ing them from there using regular querys the processing is mostlikely beeing done on the local machine.

    If you are using pass-through querys, processing will be done on the server

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •