Last post Sep 01, 2013 06:47 AM by mamun22s
Sep 01, 2013 06:34 AM|sree1248|LINK
I am trying to connect to oracle 10 G Database, after install oracle client 10.2 i am able to connect to oracle Database by using ASP.Net, while running the in VS 2010 it is sucessfully connecting and display in variable, but while dispalying in browser
it is giving below error. ..
Error : OCIEnvCreate failed with return code -1 asp.net
Dim con As New OleDbConnection()
con.ConnectionString = "Data Source=XXX.XX.XXX.XXX/abcd;User ID=asd123;Password=abc123;Unicode=True;Provider=MSDAORA.1"
Dim checkdup As String = "select name from tbltest where username='test123'"
Dim commres As New OleDbCommand(checkdup, con)
Dim sg As String = commres.ExecuteScalar
Sep 01, 2013 06:47 AM|mamun22s|LINK
This error comes becasue of the user does't have the access of oracle bin folder. Further more you have to install ODAC on your development pc for connect oracle database through your .net application.