Oracle .Net Problem

From: <kengie99_at_hotmail.com>
Date: 14 Mar 2005 02:25:19 -0800
Message-ID: <1110795918.983440.102990@f14g2000cwb.googlegroups.com>

Dear All,

I am getting an "ORA-6413: Connection not open" when using Oracle's .Net Data Provider. Before I was getting an ORA-12154 but that is resolved when I have add the code from tnsnames.ora, but I am getting "ORA-6413. I can't see anything wrong with the Coding. Please help. Many Thanks!

My code is:

connectionString = "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = XXXX)))(CONNECT_DATA=(SERVICE_NAME = XXX)));User Id=XXX;Password=XXX;"

                OradatabaseCon = New
Oracle.DataAccess.Client.OracleConnection(connectionString)
                Debug.Write(OradatabaseCon.ConnectionString)
                OradatabaseCon.Close()
                OradatabaseCon.Open()    'FAILED TO OPEN LINK

Regards,
Kengie Panda Received on Mon Mar 14 2005 - 04:25:19 CST