ADDRESS_LIST, CONNECT_DATA in OCILogon

I am porting an existing application to OCI. I have 200+ client computers.
Since the existing app already has a way to retrieve settings off another
server I am looking to bypass tnsnames.ora.

Of course I could just rewrite tnsnames before calling OCILogon, but I was
hoping to be able to pass a key/value list or similar in the dbname
parameter. Alternately, can OCILogon use environment variables for this?

DP

Jul 19 '05 #1

Subscribe Reply

5517

David Fitzjarrell

I can't see how that will help, since he's clearly wishing to bypass
the tnsnames mechanism altogether, and all the TNS_ADMIN variable does
is point one to a new or different location for a tnsnames.ora file.

I find nothing in the documentation offering any connection method
outside of the SQL*Net model, however I don't write enough OCI code to
have come across any workarounds for database connections. Possibly
someone else has some further insight into this; for now I can only
say there is no other method, outside of using the tnsnames.ora file,
to connect to an instance.

Of course, I could be wrong. :-)

David Fitzjarrell
rs******@hotmai l.com (Rauf Sarwar) wrote in message news:<92******* *************** ****@posting.go ogle.com>...

"DP" <dp****@mw-inc.com> wrote in message news:<UB******* *********@news. uswest.net>...
I am porting an existing application to OCI. I have 200+ client computers.
Since the existing app already has a way to retrieve settings off another
server I am looking to bypass tnsnames.ora.

Of course I could just rewrite tnsnames before calling OCILogon, but I was
hoping to be able to pass a key/value list or similar in the dbname
parameter. Alternately, can OCILogon use environment variables for this?

DP

Look at usage of TNS_ADMIN environment variable.

Regards
/Rauf Sarwar

Jul 19 '05 #2

Similar topics

10998

OCILogon problem - Oracle password expiry

by: Geoff Muldoon | last post by:

Hi all, Help please. Environment: Unix (Tru64) / Apache / PHP4.0.6 / Oracle8i Establish connection to Oracle: for ($I=0; $I<$max_attempts; $I++) {

PHP

2060

Problem related to OCILogon ()

by: arun.kumar.varma | last post by:

Hi, My objective is to try to connect to the oracle database and if an error occurs go to another page. The code follows $conn = OCILogon($user,$passwd,$db); // <---- Line 34 if (!$conn) { $err = OCIError(); header("Location: dbproblem.php?error=$err");

PHP

13416

Listener cannot read SERVICE_NAME in TNS-Descriptor

by: Axel Dachtler | last post by:

Hi, I have a listener problem. The listener cannot read SERVICE_NAME in TNS-Descriptor. The service-name I specified in Oracle Net Manager for this database is testdb as well. (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=axel-0560nntbn1) (PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb))) It is a local...

Oracle Database

25804

Error with ocilogon() : OCIEnvNlsCreate() failed

by: JuliouZ | last post by:

Warning: ocilogon() : OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /web/htdocs/test.php on line 6 Oracle Connect Error my file test.php : <?php PutEnv("ORACLE_SID=TEST"); PutEnv("ORACLE_HOME=/oracle/ora102");...

PHP

1389

Oracle Connection

by: rsrinivasan | last post by:

Hi all, I need to connect local database from oracle. When i give username and password and service name, it throws error "TNS name could not be resolved". What should i change in tnsnames file? Thanks in advance Srinivas r.

Oracle Database

17011

ORA-12224: TNS:no listener

by: Nitvar | last post by:

When i am trying to connect to oracle it is giving me these two errors ORA-12224: TNS:no listener ORA-01034: ORACLE not available I am new to oracle ,plz help I am using solaris 5.6 and oracle 8.0.5 version I am posting my listener.ora and Tnsname

Oracle Database

154

ADDRESS_LIST, CONNECT_DATA in OCILogon

by: DP | last post by:

I am porting an existing application to OCI. I have 200+ client computers. Since the existing app already has a way to retrieve settings off another server I am looking to bypass tnsnames.ora. Of course I could just rewrite tnsnames before calling OCILogon, but I was hoping to be able to pass a key/value list or similar in the dbname...

Oracle Database

4045

OCILogon Fails But OCIError Returns False.

by: Akino877 | last post by:

Hello, I am writing a simple PHP script to see if I can make a connection to my Oracle database. And it showed that my call to OCILogon() failed. But my call to OCIError() returned "False", which I believe meant to be "no error found". I wonder if you could please help me get additional information as to why my call to OCILogon()...

Oracle Database

6589

execute php from cmd (undefined function OCILogon)

by: ragonz | last post by:

i tried to execute php file from cmd line. i'm using xampp version 1.67 with windows server 2003 as the OS. it'll also include oracle as the database,which means OCILogon() will be called in my php file and so other functions. i already configured the php.ini so that it connects to oracle. in web page, i can access the database(oracle). But the...

PHP

7487

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7680

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7934

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7446

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7778

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5349

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3476

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

1908

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

731

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General