Absolutely true !!!
That's why I want to keep most of the things in the database and minimum at users end.
It will be easy for us to maintain and control.
Microsoft tools must be kept away from oracle otherwise our life will be hell. Let's
hope somebody will write a book. (Before that let's
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.
gt;Have you considered a reporting tool like Brio or Crystal Reports? You can
gt;define reports that users can run whenever they like or have those reports
gt;pushed out to them on a schedule when database activity is lower. You can
gt;present the reports as HTML, or download them as CSV's
Dilip - I think you are on the right track. I saw your post to Justin, and
that is what what we often run into -- we give the users a report tool and
hope they'll go away, but they come back and ask IS to create the reports.
Here are the issues as I see them:
1. Users are developing more
Hi Dennis,
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
Hi Guys,
One simple ODBC question. Our management wants a set-up where user from remote
location will access oracle database through ODBC connection, execute some sql
scripts, download data into excel files and then do whatever reporting on that excel
data. Now management wants all these sql
Dilip
Sounds as if your management is deciding to get things under control. You
can move your SQL into PL/SQL stored procedures and use ODBC to execute the
stored procedure.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, February 11,