Re: Oracle .Net Problem

On 14 Mar 2005 02:25:19 -0800, kengie99_at_hotmail.com wrote:

You never showed the instaniation of a the connection object.

>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 Sun Mar 27 2005 - 14:15:51 CST