|
 |
asp_databases thread: ASP and Oracle
Message #1 by "Puskar Adhikari" <puskar@h...> on Thu, 21 Sep 2000 12:55:16 EDT
|
|
Hi Everyone,
I am having to work with ASP and using Oracle as the datdabase server.
I have worked using SQL Server and Access before but this is the first time
i am working with oracle.
Working with oracle I have some questions like
1) is oracle very compatible with ASP
2) will I be able to use the functionality's provided by ADO as I did
with SQL Server
3) Any good books or article on ASP with Oracle
Thanks in advance for any help,
Have fun,
Puskar :)
Message #2 by "Abhijit Natu" <natuu@h...> on Fri, 22 Sep 2000 14:35:48 IST
|
|
Hi
Oracle as a backend with asp is very much posinle and we are using it with
ADO technology.
Use "MS ODBC for Oracle" as driver.
If u are conversant with ADO with access or SQL it will be no problem with
oracle.
Cheers
Abhjit
>From: "Puskar Adhikari" <puskar@h...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] ASP and Oracle
>Date: Thu, 21 Sep 2000 22:32:37 -0700
>
>Hi Everyone,
>
>I am having to work with ASP and using Oracle as the datdabase server.
>I have worked using SQL Server and Access before but this is the first time
>i am working with oracle.
>
>Working with oracle I have some questions like
>
>1) is oracle very compatible with ASP
>2) will I be able to use the functionality's provided by ADO as I did
> with SQL Server
>3) Any good books or article on ASP with Oracle
>
>Thanks in advance for any help,
>
>Have fun,
>Puskar :)
>
>
Message #3 by "Rod Aubertin" <mcountry@n...> on Fri, 22 Sep 2000 08:15:46 -0400
|
|
I've only been into ASP for about 6 months now and the project I'm working
on right now is using Oracle 8.05.
I have found that one little quirk is that you should use the Microsoft
Driver for Oracle because some query results were wrong when I used the
Oracle driver. The Microsoft Driver is a little bit slower but effecient.
Rod Aubertin
-----Original Message-----
From: Puskar Adhikari [mailto:puskar@h...]
Sent: 2000/mm/22 1:33 AM
To: ASP Databases
Subject: [asp_databases] ASP and Oracle
Hi Everyone,
I am having to work with ASP and using Oracle as the datdabase server.
I have worked using SQL Server and Access before but this is the first time
i am working with oracle.
Working with oracle I have some questions like
1) is oracle very compatible with ASP
2) will I be able to use the functionality's provided by ADO as I did
with SQL Server
3) Any good books or article on ASP with Oracle
Thanks in advance for any help,
Have fun,
Puskar :)
Message #4 by "Bhanu" <cbpr2@y...> on Fri, 22 Sep 2000 14:44:31 +0530
|
|
Hello puskar ,
you wont find any difference in using oracle with
ASP. Just creating tables, and configuring the client machine to database
require some oracle knowledge. Remaining all will be familiar to you. Just
you have to use oracle provider while accessing the database which you
might be knowing.
----- Original Message -----
From: Puskar Adhikari <puskar@h...>
To: ASP Databases <asp_databases@p...>
Sent: Friday, September 22, 2000 11:02 AM
Subject: [asp_databases] ASP and Oracle
> Hi Everyone,
>
> I am having to work with ASP and using Oracle as the datdabase server.
> I have worked using SQL Server and Access before but this is the first
time
> i am working with oracle.
>
> Working with oracle I have some questions like
>
> 1) is oracle very compatible with ASP
> 2) will I be able to use the functionality's provided by ADO as I did
> with SQL Server
> 3) Any good books or article on ASP with Oracle
>
> Thanks in advance for any help,
>
> Have fun,
> Puskar :)
>
>
>
Message #5 by =?iso-8859-1?q?chadive=20bhanu?= <cbpr2@y...> on Fri, 22 Sep 2000 08:41:08 -0700 (PDT)
|
|
yes you will be very much be able to do. you seem to
be more worried about it. Just see the following
sample code which needs to be used to handle oracle.
set con=server.createobject("ADODB.Connection")
con="Provider=MSDAORA.1;UserID=some;password=some;Data
Source=some;Persist Security Info=False"
sqltemp=" sql statement here"
set rstemp=Server.CreateObject("ADODB.Recordset")
Ok
Thanks a lot,
will i be able to use ADO functionality same way
thanks,
Puskar
>
>Hello puskar ,
> you wont find any
difference
>in using oracle with ASP. Just creating tables, and
>configuring the client machine to database require
>some oracle knowledge. Remaining all will be familiar
>to you. Just you have to use oracle provider while
>accessing the database which you might be knowing.
>----- Original Message -----
>From: Puskar Adhikari <puskar@h...>
>To: ASP Databases <asp_databases@p...>
>Sent: Friday, September 22, 2000 11:02 AM
>Subject: [asp_databases] ASP and Oracle
>
>
> > Hi Everyone,
> >
> > I am having to work with ASP and using Oracle as
the
>datdabase server.
> > I have worked using SQL Server and Access before
but
>this is the first time
> > i am working with oracle.
> >
> > Working with oracle I have some questions like
> >
> > 1) is oracle very compatible with ASP
> > 2) will I be able to use the functionality's
>provided by ADO as I did
> > with SQL Server
> > 3) Any good books or article on ASP with Oracle
> >
> > Thanks in advance for any help,
> >
> > Have fun,
> > Puskar :)
> >
>
|
|
|
View Cart
