Re: ODBC through server side sql

At 12:23 AM 2/13/2003, Dilip wrote:

>Actually lots of users are connecting to this database from remote
>locations and connections are very slow because of network. So these
>clever people wants some sqls/reports to be run from ODBC connection and
>get data into excel and then work on that data. So that they don't need to
>access database full day.
>
>Now I am suggesting them that we should create views in the database.
>Views definition will take care of report logic. And then through ODBC,
>they will just do 'select * from view_name' and get data in excel and carry on.

Have you considered a reporting tool like Brio or Crystal Reports? You can define reports that users can run whenever they like or have those reports pushed out to them on a schedule when database activity is lower. You can present the reports as HTML, or download them as CSV's for Excel. It's a little more work up front, but it's well worth it IMHO, particularly for non-technical users.

Justin Cave
Distributed Database Consulting

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).