connect to Oracle DB in ASP.net application

Hot Topic

ExecuteNonQuery is not returning no of rows affected (Oracle Provider)
.Net Framework, compiled or translated?
Performing Search from database and showing result on same form in VB.NET & SQL envirnment
How to modify the <configSections> section programatically (.NET 2.0)?
Programatically add columns and then save back to database - how ?
XMLSchema - Defining XmlSchemaElements with sensible types
connections over internet
Processes + Sub Processes
UDPClient Slow Connection
is it possible to post files in an ip adress through windows application? how?

.NET Development

Sending Email problem (.NET 2.0)
How do you convert a Bitmap to an Icon
XSL Constants
DataSet and DataSet Designer
Forms question for a non-windows application
The wrong Principal is passed to my remoted object
Automatically detect a CD and read CD contents
Can Image or image file be an XML element or attribute?
lost Microsoft framework?
NetworkStream deserialization

connect to Oracle DB in ASP.net application

I try to connect to Oracle database in my .net web application but i have the following error:

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

I use this source code:

Dim strConnectionString As String = "driver={Microsoft ODBC for Oracle};data source=TEST;UID=pippo;PWD=pluto"

Dim Conn As New OdbcConnection(strConnectionString)

The "Conn.Open()" method causes the error.

Many Thanks
Maurizio

Answer this question

connect to Oracle DB in ASP.net application

  • access2reality

    Yes... you should use the Oracle DataProvider when connecting to Oracle database...

  • Camden Bainwright

    I noticed you're using ODBC for this data access. May I ask why you're not using the System.Data.OracleClient provider instead (available in .Net 1.1 and later only) It's much faster and more robust than ODBC and you'll probably have less problems too.

  • skywave

    hi

    i hope changing to OracleClient will solve the problem. If u find the problem again.. check the security tab in the web server. the read/write permision should b given to user ASPNET

    bye



  • connect to Oracle DB in ASP.net application
Answer this question