Connect to oracleDB

[DuckFace]

Hi! I'm new to oracle and i'm trying to connect to a remote oracle db server. I use the following connection string: string strConn = "Provider=OraOLEDB;DataSource=;User ID=;Password="; I get the error: The provider OraOLEDB is not registered on the local machine. What does this means? The provider is installed on the server. Do I have to install it on the local machine too? Can someone please help me...

[Michael P Butler]

DuckFace wrote: Do I have to install it on the local machine too? Yes, if this is a desktop application. No, if you are talking to a web page. Michael CP Blog [^]

[DuckFace]

Thx for response. Now i have installed the oracle provider for oledb on my local machine. I have the following method for connecting to the db: public void createOLEDBConn() { string strConn = "Provider=OraOLEDB.Oracle;Data Source=;User Id=dummy;Password=dummy"; OleDbConnection myOleDbConn = new OleDbConnection(strConn); MessageBox.Show("Just before open!"); myOleDbConn.Open(); MessageBox.Show( myOleDbConn.ServerVersion.ToString(), "Test Conn"); myOleDbConn.Close(); } The first messagebox is being showned, but when I call the open method, the application just waits and I have to stop it myself. I don't know why. Do you?? The dummy user is one I created on the server