hi,
does anyone know how to connect to an oracle database on a remote server 
using asp.net, if so can you please give me an example how to.
Thank you.

Hi Soni,

Well there are couple of ways by which you can conect to oracle database on
remote server.
You can use DOT OLEEDB DRIVER FOR THE SAME. .

1) You can use Ether the Microsoft oledb provider for oracle

OR

2) You can even make an ODBC connection and connect it with  using
OLEDB PROVIDERS FOR OLEDB DRIVERS.

Its pretty easy process by right clicking on your data connection and adding
a new connection.

Hope it helps.
Manuj


----- Original Message -----
From: <soni29@h...>
To: "ASP+" <aspx@p...>
Sent: Thursday, April 18, 2002 2:34 PM
Subject: [aspx] asp.net and oracle


> hi,
> does anyone know how to connect to an oracle database on a remote server
> using asp.net, if so can you please give me an example how to.
> Thank you.
>

I do not know how to do Oracle but have done it with MARGINAL results to
Informix - here is the short version of what it took:

1) Get the latest drivers from Informix. Informix does NOT support .NET yet
so these drivers have to be installed very carefully (yes it was a very
great PAIN...)
2) Run a script (provided by Informix) to upgrade my database to support the
oledb connection
3) Create the Link to the database using there utilities so that I get all
of the connect strings, c:\winnt\system\etc\services file stuff setup
correctly
4) Setup the ODBC driver.
5) Steal the ODBC connection string
6) Modify the string to work with oledb since it is faster than odbc - all i
did was change the provider string
7) My Informix Connection string that I use is :

Get_Database.ConnectionString = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Initial Catalog=AMCTRANSDA;Data Source=localhost;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False"



8) Informix has  several problems with .NET particulary with inserting
columns in a date field. If anyone has any pull with Informix tell them to
GET THERE STUFF UP TO DATE!



I hope that the above was helpfull.



----- Original Message -----
From: <soni29@h...>
To: "ASP+" <aspx@p...>
Sent: Thursday, April 18, 2002 2:34 PM
Subject: [aspx] asp.net and oracle


> hi,
> does anyone know how to connect to an oracle database on a remote server
> using asp.net, if so can you please give me an example how to.
> Thank you.
>

hi manuj,
if possible can you give me the syntax (sp?) the code, like in an example, 
i need to do a project for school and the prof. wants oracle but hasn't 
shown us how to connect.


> Hi Soni,

Well there are couple of ways by which you can conect to oracle database on
remote server.
You can use DOT OLEEDB DRIVER FOR THE SAME. .

1) You can use Ether the Microsoft oledb provider for oracle

OR

2) You can even make an ODBC connection and connect it with  using
OLEDB PROVIDERS FOR OLEDB DRIVERS.

Its pretty easy process by right clicking on your data connection and 
adding
a new connection.

Hope it helps.
Manuj


----- Original Message -----
From: <soni29@h...>
To: "ASP+" <aspx@p...>
Sent: Thursday, April 18, 2002 2:34 PM
Subject: [aspx] asp.net and oracle


> hi,
> does anyone know how to connect to an oracle database on a remote server
> using asp.net, if so can you please give me an example how to.
> Thank you.
>