ASP.Net with Oracle

[meenakshidhar]

I m not able to connect ASP.Net with Oracle. The code is given below-

=========================================================
Dim oOracleConn As OleDbConnection = New OleDbConnection()
oOracleConn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=INDV;User ID=scott;Password=tiger"
oOracleConn.Open()
=========================================================

The error which i m getting is--
System.Data.OleDb.OleDbException: Class not registered

Can anyone pls help me out

Regards
Meenakshi Dhar

 

[ca8msm]

It seems you may have a problem with the .NET Framework. Are you having any other problems with any other classes?

If so, you could try running "aspnet_regiis -i" from the framework folder.

Also, there is an Oracle class for specifically working with Oracle databases. have a look at thread796-1065469 for more info.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[meenakshidhar]

Well, if i m connecting ASP.Net with SQL Server its wrking perfectly alright..I have oracle client installed on my machine..

how do we run "aspnet_regiis -i" from the framework folder. Could u pls explain it little further..

 

[ca8msm]

how do we run "aspnet_regiis -i" from the framework folder. Could u pls explain it little further..

Open a command prompt. Navigate to the .NET Framework folder. Type aspnet_regiis -i and press enter.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[meenakshidhar]

i m still getting this error...

System.Data.OleDb.OleDbException: Class not registered

 

[ca8msm]

Have you tried using the System.Data.OracleClient class like I suggested?

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[meenakshidhar]

ya i tried System.Data.OracleClient also..but still not able to connect..

 

[ca8msm]

And what does the System.Data.OracleClient class error with?

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ca8msm]

Also, post the whole connection code that you are using with the System.Data.OracleClient class.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[meenakshidhar]

this is the code--

Dim con As New System.Data.OracleClient.OracleConnection()
con.ConnectionString = "Password=tiger;User ID=scott;Data Source=INDV;"
con.Open()

and the error is--
OCIEnvNlsCreate failed with return code -1 but error message text was not available.

 

[ca8msm]

OCIEnvNlsCreate failed with return code -1 but error message text was not available.

I'm not sure what OCIEnvNlsCreate is...is this your own class? Also, you should be able to get an error message. Wrap the connection up in a Try/Catch and catch both a oracleclient exception as well (as you will then be able to see if the db has an error or if there is another error. e.g.

        Try

        Catch ex As Exception

        Catch exDb As OracleClient.OracleException

        End Try

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.