RE: ODBC through server side 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.
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

<P>Hi Guys,</P>
<P>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&nbsp;data into excel files and then do whatever reporting on that excel data. Now management wants&nbsp;all these sql scripts to be on database server only. Management&nbsp;says user should not have access to sql scripts. They should just click icons of their PCs and data should be there.</P>
<P>Can somebody&nbsp;help. I haven't&nbsp;worked much on ODBC. Is it
possible to execute server side sql scripts through ODBC connection and get data ? </P>
<P>Thanks in advance for help.</P>
<P>Regards,</P>
<P>~Dilip&nbsp;&nbsp;<BR></P>
<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_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).