Re: Newbie question....

Rauf Sarwar <rs_arwar_at_hotmail.com> wrote in message news:<3069301.1057186533_at_dbforums.com>...
> Originally posted by dreimer
> > Please bear with the newbie questions I am about to ask...
> >
> > I have an Oracle 8.1.7.3.0 on an HP-UX box, and am familiar with
> > running what I need to run from the SQL*Plus command line....
> >
> > What I would LIKE to do (please don't critisize)is write a small
> > select query for use in an ASP page running on a Win2K server. I have
> > checked the sqlnet.ora and tnsnames.ora files, and have run sqlplus
> > from the windows box, and am able to get what I need, but have no idea
> > how to get the connection to work in an ASP page, or get the query to
> > work....I have tried using tools like Dreamweaver, but it seems to not
> > like the drivers...
> >
> > Any short HOWTO's on basic VB script or ASP connections to Oracle? Or
> > do I need to buy a book and start reading?
>
> You have to use ODBC/ADO etc to connect to the database. I don't know
> the exact syntax but you can search in comp.lang.visual.basic NG.
>
> Another suggestion.... dump VB script/ASP and go with Java.
>
> Regards
> /Rauf Sarwar

IMO Java is equally worse as VB and ASP. Especially as most Java developers don't know a damn thing about SQL and Oracle, and *NEVER* use bind variables.

Sybrand Bakker
Senior Oracle DBA Received on Thu Jul 03 2003 - 09:52:25 CEST