Re: configure listener.ora and tnsnames.ora
From: ilbmbo <ilbimbo_at_gmail.com>
Date: Wed, 5 Aug 2009 08:23:58 -0700 (PDT)
Message-ID: <f6a8aded-9cae-4f54-809f-cff7e7802871_at_b15g2000yqd.googlegroups.com>
On 5 Ago, 17:19, usenet2..._at_zacek.de (Viktor Zacek) wrote:
> Ok... just for recapitulation:
>
> - Client: Windows: Connect via Visual C++ OK
> - Server: Linux: runs database OK
> - Client: tnsnames.ora not configured OK
> - Server: tnsnames.ora / listener.ora / sqlnet.ora configured OK but listener.ora is empty file.
>
> How do you connect with Visual C++? Directly with hostname + port +
> servicename? Or via alias (which would presume a working oracle client)
>
> Best regards,
> Viktor
Date: Wed, 5 Aug 2009 08:23:58 -0700 (PDT)
Message-ID: <f6a8aded-9cae-4f54-809f-cff7e7802871_at_b15g2000yqd.googlegroups.com>
On 5 Ago, 17:19, usenet2..._at_zacek.de (Viktor Zacek) wrote:
> Ok... just for recapitulation:
>
> - Client: Windows: Connect via Visual C++ OK
> - Server: Linux: runs database OK
> - Client: tnsnames.ora not configured OK
> - Server: tnsnames.ora / listener.ora / sqlnet.ora configured OK but listener.ora is empty file.
>
> How do you connect with Visual C++? Directly with hostname + port +
> servicename? Or via alias (which would presume a working oracle client)
>
> Best regards,
> Viktor
in my software in visual C++ use:
String^ connectionString = gcnew String ("Data Source=(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST= linux-gle)(PORT=1521))(CONNECT_DATA=
(SERVICE_NAME=AFTIDI)));User Id=XXXXXXXX;Password=XXXXXX");
System::Data::OracleClient::OracleConnection^ conn = gcnew
System::Data::OracleClient::OracleConnection(connectionString);
conn->Open();
so in this mode i can connect but sometimes i have error in TNS:listener Received on Wed Aug 05 2009 - 10:23:58 CDT