DBI:Oracle failure ORA-12154
I run locally a client script which fails with the following message:
ORA-12154: TNS:could not resolve service name (DBD ERROR:
OCIServerAttach) at ...
called at ...
The datasource seems ok to me, and I checked from 'tnsnames.ora' that
the port is set up to the default 1521 and the name is 'abc'.
Any idea of what could be the problem?
Content-Type: text/plain; charset=ISO-8859-1
Con...test DBD::Oracle DBI connect('','user/password@database',...) failed: ORA-12154
Content-Type: text/plain; charset=us-ascii
I can connect to the database using sqlplus as user oracle, but not as root.
I can compile DBD::Oracle but not complete the test.
I tried to set variables properly:
Hello, I have a problem to access to oracle database with asp.net 1.1.
I have a database server Oracle 8i on a machine.
I have an other machine with a IIS server and Oracle CLIENT 9i. I try to access with the Oracle Data Provider (ODP 9.2) OR whith system.data.oracleclient but i have alway the same error message:
ORA-12154: TNS Symbolic adress could not be resolved
I can log on database with SQLPlus or with VB.net application but not with asp.net.
I give to IUSR, IWAN and ASPNET user right on ORACLE920 directory.
code part:Dim con As New Oracle.DataAccess.Client.OracleCo...RE: Identifying the server connected to via DBI->connect("dbi:Ora cle:")
The output from tnsping (or tnsping80) contains the host name.
TNS Ping Utility for 32-bit Windows: Version 188.8.131.52.0 - Production on
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=db3serv)(Port=1521))
OK (100 msec)
Also, in the later version of Oracle:
select HOST_NAME from v$instance;
From: Jeff Holt [mailto:firstname.lastname@example.org]
Sent: Thursday, July 12, 2001 12:30 PM
Cc: Tim.Bunce@ig.co.uk; Cary Millsap
Sub...ORA-12638 DBI->connect(nirvana) failed: ORA-12638: Credential r etrieval failed (DBD ERROR: OCIServerAttach)
ORA-12638 DBI->connect(nirvana) failed: ORA-12638: Credential retrieval
failed (DBD ERROR: OCIServerAttach)
Can anyone help me with the above error message? (Environment describe
I am trying to run this Perl script. MAOtestORA.pl
At this point I'm just trying to get the connect to work, not trying to do
anything with the data retrieved.
use CGI::Carp qw(carpout);
$dbh = DBI->connect("dbi:Oracle:nirvana", "system", "umntest") or
die "Cannot Connect"...ORA-12154 message
Since I can't get Oracle Client 9i ot 10g, I just down grade my PERL to
5.6.1 Build 638, and try to connect to ORACLE 8i. However, I get the
"DBI connect('MAIN01','owner',...) failed: ORA-12154: TNS:could not resolve
the connect identifier specified (DBD ERROR: OCIServerAttach) at con_db.pl
Does anyone know to solve this problem? Thanks
The following is my perl program:
$dbh_target = DBI->connect(&...Error
Here is my code:
<%@ Page CompilerOptions='/R:"C:\Program Files\Microsoft.NET\OracleClient.Net\System.Data.OracleClient.dll"' %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OracleClient" %>
<%@ Import Namespace = "System.Web.UI" %>
dim myConnection as new OracleConnection("user id=intcor;password=pscor03;data source=hrprod.corp.int.digex.com;")
dim myCommand as new OracleDataAdapter ("sele...ORA-12154: TNS...
I'm preparing an application for the use of a new database. The current MySQL Database will be replaced by a Oracle Database. I'm trying to make the connection, but no success so far.
I installed the Oracle Client software on my W2K machine, which is also running IIS and ASP.NET framework 1.1.
A connection with the database on remote server MSR_LAMORAL can be made trough SQL Plus, TNSPING MSR_LAMORAL also works.
However, when I try to connect trough my aspx page, I get this message:
ORA-12154: TNS:kan opgegeven verbindings-ID niet herleiden (= Dutch, something like "...The dbi-dev list
Just a gentle reminder...
Please folks, don't cross-post to dbi-dev and dbi-users, or even
post to dbi-dev at all, without good reason. The dbi-dev list is
very low traffic (sometimes nothing at all for long periods :) but
is intended only for the developers of DBD::* drivers and closely
related modules. If it becomes heavy with questions from users then
it'll have a negative impact on development.
I am trying to write something which opens this file called abstract.sql:
select city, date from weather where temp_lo < ?
and have it $sth->execu...[perl5-dbi/DBI-Test] a2d1b2: create separate tests for DBI and DBI::Mock ...
Date: Wed, 31 Jul 2013 10:17:25 -0700
Author: Jens Rehsack <email@example.com>
Date: 2013-07-31 (Wed, 31 Jul 2013)
Changed ...ORA-12154 COnnection Error
I have a VB.NET application that was developed by someone else and I am working on fixing it. I think I am missing oracle drivers. When I run the application in Debug it fails and gives me ORA-12154 error TNS:Could not resolve service name.
Can someone suggest where to look for what and such.
This is the code where the error occurs.
m_CachedConnection = New OleDbConnection
m_CachedConnection.ConnectionString = "Provider=""ORAOLEDB.Oracle"";Database = ""PROD"";User ID=user;Data Source=""ECCWorld"";Passw...ORA-03113 Error from DBI
I am trying to resolve a horrible error I am getting, and I really don't know
where to start! I have created a Database link in Oracle and created a view
to one of the tables in it. Now when I run the SQL statement, I get:
ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute)
I really have no idea where to begin on this one.
Hope you can help
This message is for the sole use of the intended recipient. If you received
this message in error please dele...ORA-12154 error msg
Trying to use a TSQLConnection with Oracle 10g Express Edition, and I get a 12154 error message. I CAN connect to the database using TOAD.
Particulars: Embarcadero RAD Studio XE running on a Windows 7 (64 bit) machine.
I found something that suggested I add the following lines to sqlnet.ora, but alas it did not help:
NAME.DEFAULT_ZONE = world
NAMES.DEFAULT_DOMAIN = world
Just for the hell of it I also installed MySQL to this machine and tried to connect using a TSQLConnection, but I got a similar error message.
Date: Fri, 05 Apr 2013 01:45:43 -0700