In article <1110795918.983440.102990_at_f14g2000cwb.googlegroups.com>,
kengie99_at_hotmail.com says...
> 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
>
>
Your code seems to be:
- Create new connection object
- Close the connection
- Open the connection
Just like the error message says, you are closing a connection that's
not open. Maybe you meant to switch steps 2 and 3?
Received on Mon Mar 14 2005 - 06:17:22 CST
