Devart Forums

Evclid

Ok, I'll do it.
Very thank's for support.

Evclid

Unfortunatelly, closing of connections doesn't help. I forced to restart application.

Evclid

I think this is a problem of oracles clients, but I hope somebody could find a workaround or maybe standart resolve exists.

Evclid

By light Oracle 10gXE Client, I mean Oracle Database 10g Express Client
I used installation file OracleXEClient.exe (30,943,220 bytes)

1. What I can use as some standart tool?
If I use SQL*Plus of XEClient, connection is ok.
SQL> conn user1/user1@XE2
Connected.
SQL>
2. I created folder \network\admin in C:\XEClient and placed tnsnames.ora into.
XE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = spb9879.prod.quest.corp)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

Evclid

It is my settings:

Evclid

I try use last versions...
I have Devart.Data.dll version 5.0.51.0
and Devart.Data.Oracle.dll version 5.55.90.0

I installed Oracle 11g Server with client but then I removed Server. It is home 'OraClient11g_home1'
Then I installed Oracle 10g Express server. It is client 'XE'
At the last I Installed light Oracle 10gXE Client. It is home 'XEClient'. I think it is default now.

Is it chaos?

Evclid

Hello!
I have three Oracle clients.

I try this code:

Code: Select all

var c1 = new OracleConnection("User Id=user1;Password=user1;Server=SPB9879_10G_XE;Home=OraClient11g_home1;");
var c2 = new OracleConnection("User Id=user1;Password=user1;Server=XE2;Home=XEClient;");
c1.Open();
c2.Open();

This homes is not default.
c2.Open() raised Exception:
ORA-12154: TNS:could not resolve the connect identifier specified

If I will replace c1.Open() with c2.Open():

Code: Select all

var c1 = new OracleConnection("User Id=user1;Password=user1;Server=SPB9879_10G_XE;Home=OraClient11g_home1;");
var c2 = new OracleConnection("User Id=user1;Password=user1;Server=XE2;Home=XEClient;");
c2.Open();
c1.Open();

then c1.Open() raise Exception:
Can not load Oracle client. Check your PATH environment variable and registry settings.

But connection with default home or direct=true I can use in any time and it is not raise exceptions.

I could open connection with another Home only after restart Application. How I can resolve this problem?
Thank you.

Devart Forums

Search found 7 matches

Could I use 2 connections with diff homes?