I'm running it from command prompt right now... from web server later.
I'll check the TNS_ADMIN variable. That one is new to me.
L
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]
Sent: Friday, December 30, 2005 12:32 PM
To: Mitchell, Louise M
Cc: dbi-users@perl.org
Subje
The connection is correct. We use nameserver naming protocols. That is
the sqlnet name, not the sid. We don't use TNSNAMES. And I've been
connecting to this db for years in this manner and it works on other
machines with older versions of perl and the dbi.
I agree it's not a DBD or DBI error.
On Thu, 29 Dec 2005 16:02:55 -0600, Garrett Caudle wrote:
Hi Garrett
See:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
And, have you considered upgrading MySQL? It won't be as much work as you may
fear.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 31/12/2005
http://savage.net.au/index.h
This is most likely not a DBD::Oracle nor DBI error. From oerr:
$ oerr ora 12514
12514, 0, "TNS:listener could not resolve SERVICE_NAME given in
connect descriptor"
// *Cause: The SERVICE_NAME in the CONNECT_DATA was not found in
// the listener's tables.
// *Action: Check to make sure that
Are you running the PERL script in command prompt? Or via web server?
Check if you set the TNS_ADMIN environment variable.
-Original Message-
From: Mitchell, Louise M [mailto:[EMAIL PROTECTED]
Sent: Friday, December 30, 2005 3:05 PM
To: Mitchell, Louise M; Kong, Alan
Cc: dbi-users@perl.o
On Fri, Dec 30, 2005 at 12:58:02PM +0100, wernerus sebastien wrote:
> Tim, I made the changes you suggested. Here is the code:
> ---
Thanks.
> ---
>
> But it gives exactly the same result, namely:
> connection ok
> test1:
> test2:
Umm. [.
wernerus sebastien wrote:
Tim, I made the changes you suggested. Here is the code:
---
package MySubDBI;
...
package Main;
try:
package main; #IE lowercase "M", not Main..
Also be sure to:
use strict;
use warnings;
in each package as that will likley tel
Typo below...
'now sure' should be 'not sure'
L
-Original Message-
From: Mitchell, Louise M
Sent: Friday, December 30, 2005 12:03 PM
To: Kong, Alan
Cc: dbi-users@perl.org
Subject: RE: :Oracle - with ora10g oci.dll
I can connect via sqlplus and sqlplusw.
We don't use tnsnames.ora beca
I can connect via sqlplus and sqlplusw.
We don't use tnsnames.ora because we run nameservers. We only have
sqlnet.ora files which contain nameserver info.
I was an oracle dba for a number of years, so am familiar with
configuring and setting up the oracle client and so far as I can tell
the 9.2.
Check to see if you can connect to sqlplus in the command prompt.
You should also check the tnsnames.ora entry.
-Original Message-
From: Mitchell, Louise M [mailto:[EMAIL PROTECTED]
Sent: Friday, December 30, 2005 2:57 PM
To: dbi-users@perl.org
Subject: DBD::Oracle - with ora10g oci.dll
Hi,
I am having some issues with the DBD::Oracle.
I'm running Perl 5.8.7 build 813 from active state on a win2k3 server.
I installed Oracle 9.2.0 client.
I then installed DBI and DBD::Oracle (1.16), which installs the oci.dll
as well as oraociei10.dll.
I can connect using sqlplus manually from
If you are using a Windows enviorment this may also be caused by not putting
the path to the oracle_home in windows format. If you are in Linux/unix you
might want to check you .profile for the user running the program it may not
have the correct home anme.
Tim, I made the changes you suggested. Here is the code:
---
package MySubDBI;
use strict;
use DBI;
use vars qw(@ISA);
@ISA = qw(DBI);
package MySubDBI::dr;
use vars qw(@ISA);
@ISA = qw(DBI::dr);
sub connect {
my ($drh, @args) = @_;
my $dbh = $drh->SUPER::c
On 12/29/05, Rui Sampaio (Whatevernet) <[EMAIL PROTECTED]> wrote:
> Is this ok or you recommended to install a higher version of gcc?
>
> >gcc --version
> 2.95.3
>
> >perl -V:gccversion
> gccversion='3.3.2';
> [EMAIL PROTECTED]:/working/software/DBI-1.50>
You should always build modules with XS co
14 matches
Mail list logo