I think the minimum I'd want to see to investigate a problem like this would be the exact text of the connect() call, the values $ORACLE_HOME and $TNS_ADMIN ___as set by the web server___, and the contents of the tnsnames.ora and sqlnet.ora files those environment variables point to.
Send them to the list, not me. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. ----- Original Message ----- From: "Gary Fletcher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 18, 2001 09:28 Subject: Problems with loging on to the correct database using DBI. > I am running the latest version of DBI on Linux. The Linux server has 3 > Oracle 8.1.6 databases running on it. From perl CGI I am attempting to > connect to one of these databases. This is when strange things seem to be > hapenning. > > Instead of Connecting to the local database (dbname = bille, ORACLE_SID = > ORCL) DBI is connecting to another database on a remote server (dbname = > bille, ORACLE_SID = ORCL). I have checked and double checked tnsnames.ora > and the IP address entry for the local billie is correct and there is no > entry for the remote database. > > Is this a bug in DBI? If so is there a patch or a cunning way around this? > > Gary Fletcher > Senior Analyst Programmer > Ticscali UK > Work: 0870 7400977 > Mobile: 07764212838 >
