RE: DBI:ORACLE with Oracle XE

From: pgriffin@xxxxxxxxxxxxxxxxxxxx (Paul Griffin)
Date: Mon, 10 Jul 2006 00:05:38 -0400

Gerard,

Tnsping does work.

I have also managed to connect using the code below. But I'm unable to
connect any other way. I'm missing something obvious so if any one can tell
me what this is it would really be appreciated

$dbh = DBI->connect('dbi:Oracle:', q{uid/pwd@(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LDPM2001AUS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)},"") or die DBI::errstr;

@tables = $dbh->tables();

foreach $table (@tables) {
print "Table : $table\n";
}

Regards Paul...

-----Original Message-----
From: Gerard [mailto:GerardHoran@xxxxxxxxx]
Sent: Monday, 10 July 2006 12:59 PM
To: Paul Griffin
Subject: Re: DBI:ORACLE with Oracle XE

Does tnsping work?

What OS are you on?

gerard
Paul Griffin wrote:

I can connect to an Oracle XE database with dbi:ODBC using :

$dbh = DBI->connect("dbi:ODBC:PSTORA01", "uid", "pwd") or die DBI::errstr;

But am unable to connect with dbi:ORACLE using :

$dbh = DBI->connect("dbi:Oracle:PSTORA01", "uid", "pwd") or die

DBI::errstr;

Each time I get the following error :

DBI connect('PSTORA01','system',...) failed: ORA-12154: TNS:could not
resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at
C:\Projects\PST-Repository\Perl\oracle_01.pl line 10

ORA-12154: TNS:could not resolve the connect identifier specified (DBD
ERROR: OCIServerAttach) at C:\Projects\PST-Repository\Perl\oracle_01.pl

line

10.

*** Process "C:\Perl\bin\perl.exe" terminated. Return code=255

med>

I'm using XP SP2 with Perl v5.8.8 and DBD-Oracle v1.17.

Any suggestions/help appreciated.

Regards Paul...

------_=_NextPart_001_01C69FB3.69C5A240
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Google-AttachSize: 4849

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40";>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

I can connect to an Oracle XE database with dbi:ODBC =
using :<o:p></o:p>

<o:p> </o:p>

$dbh =3D =
DBI->connect("dbi:ODBC:PSTORA01", "uid",
"pwd") or die DBI::errstr;<o:p></o:p>

<o:p> </o:p>

But am unable to connect with dbi:ORACLE using =
:<o:p></o:p>

<o:p> </o:p>

$dbh =3D =
DBI->connect("dbi:Oracle:PSTORA01",
"uid", "pwd") or die =
DBI::errstr;<o:p></o:p>

<o:p> </o:p>

Each time I get the following error =
:<o:p></o:p>

<o:p> </o:p>

DBI connect('PSTORA01','system',...) failed: =
ORA-12154:
TNS:could not resolve the connect identifier specified (DBD ERROR:
OCIServerAttach) at C:\Projects\PST-Repository\Perl\oracle_01.pl line =
10<o:p></o:p>

ORA-12154: TNS:could not resolve the connect =
identifier specified
(DBD ERROR: OCIServerAttach) at =
C:\Projects\PST-Repository\Perl\oracle_01.pl
line 10.<o:p></o:p>

*** Process "C:\Perl\bin\perl.exe" =
terminated.
Return code=3D255<o:p></o:p>

med><o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

I’m using XP SP2 with Perl v5.8.8 and =
DBD-Oracle v1.17.<o:p></o:p>

<o:p> </o:p>

Any suggestions/help =
appreciated.<o:p></o:p>

<o:p> </o:p>

Regards
Paul…<o:p></o:p>

</div>

<u1:PersonName u2:st=3D"on">
</body>

</html>

------_=_NextPart_001_01C69FB3.69C5A240--

Prev by Date: LAST_INSERT_ID and Global Variable
Next by Date: Re: Using DBD::ODBC in a CGI script under Apache
Previous by thread: Re: DBI:ORACLE with Oracle XE
Next by thread: RE: sth->do()
Index(es):
- Date
- Thread

Relevant Pages

Re: tnsping working; sqlplus not
... | Used TNSNAMES adapter to resolve the alias ... | ORA-12154: TNS:could not resolve the connect identifier specified ... | just telling me that "it's your PC, if tnsping works, sqlplus should ...
(comp.databases.oracle.tools)
Re: OracleXE and Designer connection problem
... Used TNSNAMES adapter to resolve the alias ... OK, my output for "tnsping XE" matches exactly this one, except that in my ...
(comp.databases.oracle.tools)