Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ODBC through server side sql

RE: ODBC through server side sql

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 13 Feb 2003 06:24:05 -0800
Message-ID: <F001.0054BBD0.20030213062405@fatcity.com> 





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 computer skills, but that only means they can
dream of more than they can accomplish, which puts more pressure on IS.
  
  2.   You need to understand your user community, what their interests and
skills are. If you can, support the power users and hope they will support
and train the others.
  
  3.   It is good if all users can use the same tool. As a DBA you get to know
when it produces bad SQL so you can fix problems quickly.






We have used what you are proposing quite a bit. Beyond views we have often
created special tables either on Oracle or down on Access (even better) that
pre-digest the data for the users. 


   I always try to keep the Microsoft tools away from Oracle if possible.
Someone on this planet probably understands how Microsoft really interacts
with Oracle, but they haven't written a book, or if they have I haven't
found it but I would buy that book in a minute. 



Dennis Williams


DBA, 40%OCP



Lifetouch, Inc.


dwilliams_at_lifetouch.com 




-----Original Message-----


Sent: Thursday, February 13, 2003 1:24 AM
To: Multiple recipients of list ORACLE-L




--=_MAILER_ATTACH_BOUNDARY1_200321341253542145174067

Content-Type: text/plain; charset=us-ascii



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




Any better ideas ????




Thanks,




~Dilip


   


ORACLE-L_at_fatcity.com wrote:





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.


dwilliams_at_lifetouch.com 




-----Original Message-----


Sent: Tuesday, February 11, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L




--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434

Content-Type: text/plain; charset=us-ascii



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 scripts to
be on database server only. Management says user should not have access to
sql scripts. They should just click icons of their PCs and data should be
there.




Can somebody help. I haven't worked much on ODBC. Is it possible to execute
server side sql scripts through ODBC connection and get data ? 




Thanks in advance for help.




Regards,




~Dilip 



Get Your Private, Free E-mail from Indiatimes at
http://email.indiatimes.com


Buy the best in Movies at http://www.videos.indiatimes.com
Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to
http://airsahara.indiatimes.com and Bid Now !



--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434

Content-Type: text/html; charset=us-ascii






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
scripts to be on database server only. Management says user should not
have access to sql scripts. They should just click icons of their PCs and
data should be there.





Can somebody help. I haven't worked much on ODBC. Is it
possible to execute server side sql scripts through ODBC connection and get
data ? 





Thanks in advance for help.





Regards,





~Dilip  





Get Your Private, Free E-mail from


Indiatimes at 


face="Arial" size="2"&gt;http://email.indiatimes.com
Buy the best in


Movies at 


href="http://www.videos.indiatimes.com"&gt;http://www.videos.indiatimes.com



Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to



href="http://airsahara.indiatimes.com"&gt;http://airsahara.indiatimes.com
and Bid Now !



--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434--



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: dilip7772002
INET: dilip7772002_at_indiatimes.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

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


Get Your Private, Free E-mail from Indiatimes at
http://email.indiatimes.com
Buy the best in Movies at http://www.videos.indiatimes.com
Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to
http://airsahara.indiatimes.com and Bid Now !

--=_MAILER_ATTACH_BOUNDARY1_200321341253542145174067
Content-Type: text/html; charset=us-ascii



<P>Hi Dennis,</P>

<P>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.&nbsp;So that they don't need to
access database full day. </P>


<P>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&nbsp;'select * from view_name' and get data in excel and carry
on.</P>


<P>Any better ideas ????</P>

<P>Thanks,</P>

<P>~Dilip</P>

<P>&nbsp;&nbsp; <BR><B><I>ORACLE-L_at_fatcity.com</B></I> wrote:<BR><BR></P>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px;

PADDING-LEFT: 5px"><BR>Dilip<BR>Sounds as if your management is deciding to
get things under control. You<BR>can move your SQL into PL/SQL stored
procedures and use ODBC to execute the<BR>stored procedure.<BR><BR>Dennis
Williams<BR>DBA, 40%OCP<BR>Lifetouch, Inc.<BR>dwilliams_at_lifetouch.com


<BR><BR><BR>-----Original Message-----<BR>Sent: Tuesday, February 11, 2003

5:59 AM<BR>To: Multiple recipients of list
ORACLE-L<BR><BR><BR>--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434<BR>C
ontent-Type: text/plain; charset=us-ascii<BR><BR>Hi Guys,<BR><BR><BR>One
simple ODBC question. Our management wants a set-up where user
from<BR>remote location will access oracle database through ODBC connection,
execute<BR>some sql scripts, download data into excel files and then do
whatever<BR>reporting on that excel data. Now management wants all these sql
scripts to<BR>be on database server only. Management says user should not
ha!
!
ve access to<BR>sql scripts. They should just click icons of their PCs and
data should be<BR>there.<BR><BR><BR>Can somebody help. I haven't worked much
on ODBC. Is it possible to execute<BR>server side sql scripts through ODBC
connection and get data ? <BR><BR><BR>Thanks in advance for
help.<BR><BR><BR>Regards,<BR><BR><BR>~Dilip <BR><BR>Get Your Private, Free
E-mail from Indiatimes at<BR>http://email.indiatimes.com<BR>Buy the best in
Movies at http://www.videos.indiatimes.com<BR>Bid for Air Tickets @ Re.1 on
Air Sahara Flights. Just log on to<BR>http://airsahara.indiatimes.com and
Bid Now
!<BR><BR>--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434<BR>Content-Type
: text/html; charset=us-ascii<BR><BR>


<P>Hi Guys,</P><BR>

<P>One simple ODBC question. Our management wants a set-up where user

from<BR>remote location will access oracle database through ODBC connection,
execute<BR>some sql scripts, download&nbsp;data into excel files and then do
whatever<BR>reporting on that excel data. Now management wants&nbsp;all
these sql<BR>scripts to be on database server only. Management&nbsp;says
user should not<BR>have access to sql scripts. They should just click icons
of their PCs and<BR>data should be there.</P><BR>


<P>Can somebody&nbsp;help. I haven't&nbsp;worked much on ODBC. Is

it<BR>possible to execute server side sql scripts through ODBC connection
and get<BR>data ? </P><BR>


<P>Thanks in advance for help.</P><BR>

<P>Regards,</P><BR>

<P>~Dilip&nbsp;&nbsp;<BR></P><BR>

<HR>

<FONT face=Arial size=2><B>Get Your Private, Free E-mail from<BR>Indiatimes

at </FONT><A href="http://email.indiatimes.com/"><FONT<BR>face="Arial"
size="2"&gt;http://email.indiatimes.com</A></B><BR>Buy the best in<BR>Movies
at


<A<BR>href="http://www.videos.indiatimes.com"&gt;http://www.videos.indiatime

s.com</A><BR><BR>Bid for <B>Air Tickets @ Re.1</B> on Air Sahara Flights.
Just log on
to<BR><A<BR>href="http://airsahara.indiatimes.com"&gt;http://airsahara.india
times.com</A><BR>and Bid Now
!</FONT><BR><BR>--=_MAILER_ATTACH_BOUNDARY1_20032112172951610515434--<BR><BR
>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>--


<BR>Author: dilip7772002<BR>INET: dilip7772002_at_indiatimes.com<BR><BR>Fat

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


<hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from

Indiatimes at  </font><a href="http://email.indiatimes.com"><font
face="Arial" size="2">http://email.indiatimes.com</a></b><br>Buy the best in
Movies at <A
href="http://www.videos.indiatimes.com">http://www.videos.indiatimes.com</A>


<br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to

<a

href="http://airsahara.indiatimes.com">http://airsahara.indiatimes.com</a>
and Bid Now !</font>

--=_MAILER_ATTACH_BOUNDARY1_200321341253542145174067--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dilip
  INET: dilip7772002_at_indiatimes.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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


Received on Thu Feb 13 2003 - 08:24:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US