Solved

Error connecting to Oracle database from .Net windows forms

Posted on 2007-12-04
3
2,333 Views
Last Modified: 2013-12-18
I am trying to connect to Oracle database from .Net Windows forms and I get "OCIEnvCreate failed with return code -1 but error message text was not available".

OracleConnection _oraConnection = new OracleConnection();
string connectionString = "Data Source=mydatabase.co.karu.com;User ID=tempuser;Unicode=True; password=pass123";
 _oraConnection.ConnectionString = connectionString;
_oraConnection.Open();
System.Windows.Forms.MessageBox.Show("Login Success");

Open in new window

0
Comment
Question by:Karuppaiah
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 20525103
hi,

This is most likely caused by one of:
1. Not having the .net Oracle client library installed
2. Not having the correct version of .net Oracle client library installed
3. Not having the Oracle Client installed/configured at all

is this happening in development, or on an installed client?
0
 

Author Comment

by:Karuppaiah
ID: 20794156
Need to install Oracle client for vista
0
 

Author Comment

by:Karuppaiah
ID: 20794174
thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Developer 6 75
Oracle dataguard 5 61
Oracle encryption 12 60
join a table with user_tab_columns in oracle 3 69
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question