tim.bu...@pobox.com>>
Sent: Monday, September 5, 2022 3:16 AM
To: dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: Fwd: please help with DBD-Oracle-1.76
Begin forwarded message:
From: Daniel Chmielewski
mailto:daniel.chmielew...@gmail.com>>
Subject: Fwd: please help with DBD-Oracl
download and install it to satisfy what is in your post
Regards,
Kevin
From: Tim Bunce
Sent: Monday, September 5, 2022 3:16 AM
To: dbi-users@perl.org
Subject: Fwd: please help with DBD-Oracle-1.76
Begin forwarded message:
From: Daniel Chmielewski mailto:daniel.chmielew
> Begin forwarded message:
>
> From: Daniel Chmielewski
> Subject: Fwd: please help with DBD-Oracle-1.76
> Date: 5 September 2022 at 10:03:15 IST
> To: t...@cpan.org
>
> Tim, please help.
> Regards,
> Daniel
>
>
> -- Forwarded mes
]
Gesendet: Sonntag, 28. Januar 2018 14:44
An: Andreas Mock
Cc: dbi-users@perl.org
Betreff: Re: Need help with an unexpected behaviour
On Fri, Jan 26, 2018 at 04:47:35PM +0100, Andreas Mock wrote:
> Hi all,
>
> 9 my %attr = (
> 10 'AutoCommit' => 1,
> 11 '
On Fri, Jan 26, 2018 at 04:47:35PM +0100, Andreas Mock wrote:
> Hi all,
>
> 9 my %attr = (
> 10 'AutoCommit' => 1,
> 11 'RaiseError' => 1,
> 35 sub doit {
> 36 my $dbh = shift;
> 37
> 38 local $dbh->{'AutoCommit'} = 1;
> 39
> 40 $dbh->begin_work;
> 41 $dbh->do("
Hi all,
today I stumpled on a behaviour that I didn't expect
this way. And currently I haven't found an explanation.
That's the reason why I want to ask you whether you can
give me the right hints.
Environment:
SL Linux 6.7 64bit
MySQL Community Server 5.5.40
perl 5.10.1
DBI 1.633
DBD::mysql 4.03
ot;, but have diverged. You may have more luck
> trying DBD::ODBC. See also
> http://search.cpan.org/~mjevans/DBD-ODBC-1.52/FAQ#How_do_I_access_a_MS_SQL_Server_database_from_Linux/UNIX
> ?
>
> Hope that helps
>
> Alexander
>
> On 15.05.2016 05:32, sumanth ramesh wrote:
>
>
, sumanth ramesh wrote:
>> Dear Experts,
>>
>> I am new to perl and I really need your help. I need your help for a perl
>> DBD:sybase module i am using.
>>
>> I am trying to connect to a MS SQL Server from a linux server. Below are the
>> detai
Linux/UNIX?
Hope that helps
Alexander
On 15.05.2016 05:32, sumanth ramesh wrote:
Dear Experts,
I am new to perl and I really need your help. I need your help for a
perl DBD:sybase module i am using.
I am trying to connect to a MS SQL Server from a linux server. Below
are the details and
Hi Bruce, David,
thank you both for your help. I think I might read carefully the link Bruce
provided and already set the NLS_LANG to the appropriate value.
Best regards,
Jefferson ELIAS
Service Applications Informatiques
Database Administrator
Tel.: +32 4 366 83 56
Fax
Dear Experts,
I am new to perl and I really need your help. I need your help for a perl
DBD:sybase module i am using.
I am trying to connect to a MS SQL Server from a linux server. Below are
the details and the error message.
Request you to let me know how I can fix it. I will provide any more
Hi Bruce, Meir,
thank you for your help.
The file was already saved without BOM and it wasn't working at all when adding
the BOM descriptor into the file.
Bruce's suggestion about NLS_LANG settings solved the problem of connection : I
changed it temporarily from
On Thu, 12 May 2016 13:12:41 +0200 (CEST)
Jefferson Elias wrote:
> The password (which is normally the good one) contains several special and
> accented characters as follows: _é+#à.
>
Hi,
I work with Postgres and mod_perl; when DBD::Pg moved to UFT8 by default, I had
to modify my mod_perl
Are you sure Oracle is expecting UTF8 for the password? Because it works
without accented chars in the password, the simplest thing might be to
change to a password without encoding issues.
On Thu, May 12, 2016 at 10:38 AM, Bruce Johnson <
john...@pharmacy.arizona.edu> wrote:
>
> > On May 12, 201
> On May 12, 2016, at 4:12 AM, Jefferson Elias
> wrote:
>
> Hi,
>
> I've been trying many differents things with the following error, but nothing
> seems to be working.
>
>
> Let me start to explain my problem from the beginning.
>
> (Perl version: v5.10.)
>
> I use a configuration file
Hi,
I've been trying many differents things with the following error, but nothing
seems to be working.
Let me start to explain my problem from the beginning.
(Perl version: v5.10.)
I use a configuration file that I parse using Config::General::ParseConfig.
This file is encoded in UTF8 as
On 2/7/2016 3:12 AM, Martin J. Evans wrote:
You need to install a C compiler - the one your Perl was built with is
most likely to work.
the perl that comes with solaris is built with Oracle Studio C (formerly
Sun Forte C) ...
but I seem to recall there was a solaris perl make script that worke
On 05/02/2016 20:35, Tim Bunce wrote:
Hi. I don't provide support for DBD::Oracle directly. Please email
dbi-users@perl.org or, if you'd rather not just yet, then something here
will probably help:
https://www.google.com/search?q=dbd-oracle+/usr/ucb/cc:++language+optional+software+p
Hi. I don't provide support for DBD::Oracle directly. Please email
dbi-users@perl.org or, if you'd rather not just yet, then something here
will probably help:
https://www.google.com/search?q=dbd-oracle+/usr/ucb/cc:++language+optional+software+package+not+installed
Tim.
On Fri, Feb 0
Hi!
> > > There's a newer linux-oracle-instantclient-sdk available in the
> > > ports (10.2.0.3), and maybe it helps to compile and link a newer
> > > DBD::Oracle.
> >
> > I have that one (actually, those three), but they are nine
> > years old as well: 20061115_5 is coded into the ports name.
>
Hi!
> > There's a newer linux-oracle-instantclient-sdk available in the
> > ports (10.2.0.3), and maybe it helps to compile and link a newer
> > DBD::Oracle.
>
> I have that one (actually, those three), but they are nine
> years old as well: 20061115_5 is coded into the ports name.
The API did n
According to Kurt Jaeger on Thu, 06/04/15 at 09:38:
>
> My guess: no-one had the need, time and skills to fix it.
>
> There's a newer linux-oracle-instantclient-sdk available in the
> ports (10.2.0.3), and maybe it helps to compile and link a newer
> DBD::Oracle.
I have that one (actually, thos
Hi!
> According to Kurt Jaeger on Thu, 06/04/15 at 02:50:
> > DBD::Oracle no longer supports Oracle client versions before 9.2
> > Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271.
> >
> > and there is no oracle9-client port on FreeBSD.
>
> Thanks. That makes sense.
According to Kurt Jaeger on Thu, 06/04/15 at 02:50:
>
> DBD::Oracle no longer supports Oracle client versions before 9.2
> Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271.
>
> and there is no oracle9-client port on FreeBSD.
Thanks. That makes sense. What doesn't ma
Hi!
> What is confusing to me is why FreeBSD _still_ contains
> DBD::Oracle 1.19 in their "ports" tree! After all these years!
Because:
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271.
and there is no
in message <20150603172207.gf2...@itcom245.staff.itd.umich.edu>,
wrote William Bulley thusly...
>
...
> My focus now is trying to install DBD::Oracle 1.74 from CPAN (from
> April of 2014) on my system.
...
> What is confusing to me is why FreeBSD _still_ contains
> DBD::Oracle 1.19 in their "ports"
According to "Howard, Chris" on Wed, 06/03/15 at 13:09:
>
> I was hoping you could share the actual code
> with us. But no problem. Sounds like you have
> some good clues.
>
> Using Oracle 8 client and ancient DBI libraries
> probably isn't helping, but also seems unlikely to hurt.
>
> I'm le
cat scriptname | od -bc | more
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Wednesday, June 03, 2015 11:13 AM
To: William Bulley
Cc: dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
> On Jun 3, 2015, at 9:44 AM, Will
> On Jun 3, 2015, at 9:44 AM, William Bulley wrote:
>
> Martin thinks the parsing in the dbd_preparse() function within the
> dbdimp.c file (part of DBD::Oracle) has issues so that it cannot deal
> with the second question mark given the preceding single quote(s).
>
> It seems plausible, yet od
To: Howard, Chris
Cc: Martin J. Evans; dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Howard, Chris" on Wed, 06/03/15 at 12:30:
>
> Thanks!
> And what does $query contain?
That is the issue! Martin has worked with me off-line and clearly
th
According to "Howard, Chris" on Wed, 06/03/15 at 12:30:
>
> Thanks!
> And what does $query contain?
That is the issue! Martin has worked with me off-line and clearly
the query contained some quote characters. I've attempted to either
remove those or quote them the DBI quote() way, but since so
Thanks!
And what does $query contain?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 9:14 AM
To: Howard, Chris
Cc: Martin J. Evans; dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Howard,
On 03/06/15 14:06, William Bulley wrote:
Environment Perl script trying to query Oracle 11g database:
FreeBSD 9.3-STABLE
DBI 1.633
oracle8-client 0.2.0
DBD::Oracle 1.19
It seems I missed this ^
A 9 year old DBD::Oracle. I can well believe the preparse code has changed o
On 03/06/15 17:12, Bruce Johnson wrote:
On Jun 3, 2015, at 7:19 AM, William Bulley wrote:
According to Bruce Johnson on Wed, 06/03/15 at
10:10:
Make sure your original $query is delimited by double quotes, not single.
I've tried _everything_!!
Single quotes. Double quotes. q{} and
> On Jun 3, 2015, at 7:19 AM, William Bulley wrote:
>
> According to Bruce Johnson on Wed, 06/03/15
> at 10:10:
>>
>>
>> Make sure your original $query is delimited by double quotes, not single.
>
> I've tried _everything_!!
>
> Single quotes. Double quotes. q{} and qq{} (using the lat
According to "Howard, Chris" on Wed, 06/03/15 at 10:44:
>
> Can you post a copy of your prepare statement?
Sure. Here it is:
$sth = $dbh->prepare ($query) or die "Couldn't prepare statement: " .
$dbh->errstr;
Regards,
web...
--
/"\ ASCII RIBBON / William Bulley
\ / CAMP
Can you post a copy of your prepare statement?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 7:57 AM
To: Martin J. Evans
Cc: dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Martin J. Evans&quo
According to Bruce Johnson on Wed, 06/03/15 at
10:10:
>
>
> Make sure your original $query is delimited by double quotes, not single.
I've tried _everything_!!
Single quotes. Double quotes. q{} and qq{} (using the latter now).
But no matter what I try DBI complains about the darn questio
> On Jun 3, 2015, at 6:57 AM, William Bulley wrote:
>
> Yep, I've been all over the net looking for this issue. I am not
> doing anything wrong -- the "invalid string" is the darn "?"!!!
Make sure your original $query is delimited by double quotes, not single.
if you do $sth->prepare(‘selec
from the above that the question mark is back
in the mix.
> http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm#ora_verbose
>
> Can be set in the connect attributes.
Thanks. :-)
> If I were you I'd try and simply the original case down as much as
&g
If I were you I'd try and simply the original case down as much as possible but
getting a trace with ora_verbose might help identify the problem.
Martin
According to "Martin J. Evans" on Wed, 06/03/15 at 09:15:
>
> So, when this fails, what is the value of $value.
I just ran it again. The value is 547.
> Assuming you have RaiseError set, you can just put an eval
> around the execute and if $@ is set, print out $value.
I don't. I have a print
instead the
execute statement generated the error:
DBD::Oracle::st execute failed: called with 1 bind variables
when 0 are needed [for Statement ... ] at script.pl line xxx.
Either because you omitted the value from execute but more likely because you
need to associate $value with the NA
r Statement ... ] at script.pl line xxx.
Can any one help me figure out this confusing situation? BTW, I
have been using Perl for twenty years and DBI for perhaps ten,
and I have used this query/prepare/bind/execute methodology in
the past with success. Something is different, but I don't know
uot;People.HouseID" is an undefined column.
Any clues would help.
Thanks
David
I would actually suggest you don't use a trigger for this and also
that you don't store the count of people in a house in a column in the
house table. You can always calculate how many people there are
On 2015-02-26 06:42:33 -0800, david wrote:
> This may be the wrong mailing list for this question, so I apologize in
> advance for breaking some rule.
Strictly speaking yes. The trigger syntax is independent of the method
used to access the database (DBI in our case).
> I'm trying to get a trigg
On Thu, 26 Feb 2015 15:31:56 +
"Martin J. Evans" wrote:
> I would actually suggest you don't use a trigger for this and also
> that you don't store the count of people in a house in a column in
> the house table. You can always calculate how many people there are
> in a house but if you us
e days but in Oracle that would be something like "where
houseid = :new.houseid".
The trigger gets "triggered", but a diagnostic says that "People.HouseID" is an
undefined column.
Any clues would help.
Thanks
David
I would actually suggest you don't us
useID;
END
The trigger gets "triggered", but a diagnostic says that
"People.HouseID" is an undefined column.
Any clues would help.
Thanks
David
t; outside. :-|
>
> Cheers
> Alberto (aka ambs)
>
>
>
> On Tue, May 7, 2013 at 1:36 PM, Alberto Simões wrote:
>
>> Hello
>>
>> I am experiencing a behavior when using DBI inside Dancer that seems to
>> result on SCALAR leaks, but only when running in
ehavior when using DBI inside Dancer that seems to
> result on SCALAR leaks, but only when running inside Dancer.
>
> To help diagnosing I did a couple of tests that I try to explain below.
>
> First, I developed a sample small application in Dancer. It is available
> (temporaril
Hello
I am experiencing a behavior when using DBI inside Dancer that seems to
result on SCALAR leaks, but only when running inside Dancer.
To help diagnosing I did a couple of tests that I try to explain below.
First, I developed a sample small application in Dancer. It is available
On Sun, 28 Apr 2013 15:30:05 -1000
syed khalid wrote:
> 2.The code that is failing on the install is this.
>
> #*
> -
> #*- Create a database after checking if it exists
> #*-
>
> I apologize if this is not the right forum to ask question.
>
> Background
> =
>
> I am running Ubuntu 12.04 on my laptop. it is the desktop version.
>
> I am aslo running MYSQL server version 5.5.29
>
> I am running into some problems which seem fairly basic and could be
> related to o
trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
does not work for root@localhost (for some reason appends
localhost
compile as 'root', you'll have to reset root's path to
include /usr/vac/bin.
Good luck.
On Thu, Apr 11, 2013 at 4:56 PM, Manimegalai Visvanathan <
mvisvanat...@wsgc.com> wrote:
> Dear Team,
>
> I need your help installing DBI on AIX Server. It's may be a comp
Dear Team,
I need your help installing DBI on AIX Server. It's may be a compiler issue.
But, am able to find cc and cc_r installed under /usr/vac/bin path. GCC -4 is
also installed on this server. Eventhough, am unable to install dbi. Kindly
help me to fix this issue.
$ cd DBI-1.625
$
successfully getting
data over ODBC.
This time, when I run cpan test DBD::ODBC, I get an undefined symbol
error (SQLFetch) from dynaloader trying to load ODBC.so. I have
attached the full build and test trace from the cpan session.
Thanx for any help
time, when I run cpan test DBD::ODBC, I get an undefined symbol error
(SQLFetch) from dynaloader trying to load ODBC.so. I have attached the full
build and test trace from the cpan session.
Thanx for any help.
_
From: Martin J. Evans [mailto:martin.ev...@easysoft.com]
Sent
dbi-users@perl.org
> Subject: Re: Help please with DBD::ODBC on SUSE-Linux
>
> On 15/08/2012 18:25, Jeff Tate wrote:
> >
> > Step 1) added ODBC trace information to odbcinst.ini (made my own
> > copy (system file)) and change $ODBCINST to address
> >
> >
On 15/08/2012 18:25, Jeff Tate wrote:
Step 1) added ODBC trace information to odbcinst.ini (made my own
copy (system file)) and change $ODBCINST to address
NO output produced in trace file
That suggests you are NOT using unixODBC as the ODBC driver manager.
Therefore this
On 15/08/2012 18:25, Jeff Tate wrote:
Step 1) added ODBC trace information to odbcinst.ini (made my own copy
(system file)) and change $ODBCINST to address
NO output produced in trace file
Step 2) running test under gdb
Linux:puTest> gdb `which perl`
GNU gdb (GDB) SUSE
6) exited with code 035]
(gdb) bt
No stack.
(gdb)
Thanx
-Original Message-
From: Martin J. Evans [mailto:martin.ev...@easysoft.com]
Sent: Wednesday, August 15, 2012 10:50 AM
To: Jeff Tate
Cc: dbi-users@perl.org
Subject: Re: Help please with DBD::ODBC on SUSE-Linux
On 15/0
On 15/08/12 15:32, Jeff Tate wrote:
Couldn't find odbcinst. Compiled test code as instructed. Result of a.out
is:
size of SQLLEN is 8
Ok, so this /should be/ good. It means that compiling DBD::ODBC with those
header files means SQLLEN and SQLULEN are 8 bytes in size and one /would hope/
if
Checked at unixodbc.org, and there is no mention of Teradata, so perhaps
that's why it's not installed.
-Original Message-
From: Jeff Tate [mailto:jt...@mindspring.com]
Sent: Wednesday, August 15, 2012 10:33 AM
To: 'Martin J. Evans'
Cc: dbi-users@perl.org
Subject:
t: Re: Help please with DBD::ODBC on SUSE-Linux
On 14/08/12 19:05, Jeff Tate wrote:
> I am trying to build a private perl with ODBC connection to a Teradata
> database on SUSE-Linux. Perl build with no errors, DBI installed
> clean, DBD::ODBC compiles seemingly cleanly, but fails
On 14/08/12 19:05, Jeff Tate wrote:
I am trying to build a private perl with ODBC connection to a
Teradata database on SUSE-Linux. Perl build with no errors, DBI
installed clean, DBD::ODBC compiles seemingly cleanly, but fails
almost all the tests. So, help will be gratefully accepted.
The
I am trying to build a private perl with ODBC connection to a Teradata
database on SUSE-Linux. Perl build with no errors, DBI installed clean,
DBD::ODBC compiles seemingly cleanly, but fails almost all the tests. So,
help will be gratefully accepted.
The attached shows:
. Relevant
On 27/06/12 09:01, Martin Hall wrote:
On 26/06/2012 21:51, Richie wrote:
On 6/24/2012 6:25 AM, Martin J. Evans wrote:
https://rt.cpan.org/Ticket/Display.html?id=69059
Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001
Symbol OCIPing was referenced
I don't have access to
On 26/06/2012 21:51, Richie wrote:
On 6/24/2012 6:25 AM, Martin J. Evans wrote:
https://rt.cpan.org/Ticket/Display.html?id=69059
Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld:
0712-001 Symbol OCIPing was referenced
I don't have access to AIX or an Oracle 10 and op gone quiet
On 26/06/2012 21:51, Richie wrote:
On 6/24/2012 6:25 AM, Martin J. Evans wrote:
https://rt.cpan.org/Ticket/Display.html?id=69059
Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld:
0712-001 Symbol OCIPing was referenced
I don't have access to AIX or an Oracle 10 and op gone quiet
On 6/24/2012 6:25 AM, Martin J. Evans wrote:
https://rt.cpan.org/Ticket/Display.html?id=69059
Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld:
0712-001 Symbol OCIPing was referenced
I don't have access to AIX or an Oracle 10 and op gone quiet.
This looks like Oracle Bug 57598
el someone else might be able to help with:
https://rt.cpan.org/Ticket/Display.html?id=72432
bind_param for ORA_..._TABLE use previous size of array if it is empty
problem with ORA_VARCHAR2_TABLE - test case supplied. I don't use
varchar tables and I'm totally unfamiliar with the code wh
Hi There,
I am stuck at a serious problem. I am new to PERL so any help will be deeply
appreciated. I have written below code to get a successful response from a WEB
Service using strawberry PERL. It worked fine.
Now my next requirement is to connect to Oracle DB from the Perl script. I
wrote
quot; error when we try to encrypt traffic
between client and server.
It will be very helpful if someone can explain why this happens and how
do we resolve this issue?
Thanks a lot for your help.
-- Vishal Gandhi --
test-script.pl
Description: Perl program
en client and server.
It will be very helpful if someone can explain why this happens and
how do we resolve this issue?
Thanks a lot for your help.
On 21/10/11 16:53, James Freire wrote:
Hi All,
I've been banging my head against the desk trying to get DBD::Oracle to
compile on Redhat (Linux 2.6.18-238.1.1.el5 #1 SMP Tue Jan 4 13:32:19 EST
2011 x86_64 x86_64 x86_64 GNU/Linux). Oracle version 10.1.0.5 (10.1)
I read through the supporting do
Hi All,
I've been banging my head against the desk trying to get DBD::Oracle to
compile on Redhat (Linux 2.6.18-238.1.1.el5 #1 SMP Tue Jan 4 13:32:19 EST
2011 x86_64 x86_64 x86_64 GNU/Linux). Oracle version 10.1.0.5 (10.1)
I read through the supporting documents and I cannot find anything that I
Hi All,
I've been banging my head against the desk trying to get DBD::Oracle to
compile on Redhat (Linux 2.6.18-238.1.1.el5 #1 SMP Tue Jan 4 13:32:19 EST
2011 x86_64 x86_64 x86_64 GNU/Linux). Oracle version 10.1.0.5 (10.1)
I read through the supporting documents and I cannot find anything that I
>> If you use DBD::Pg and also use PostgreSQL arrays, you should be aware
>> there is an open bug with quoting works. A bug report about the issue is
>> here, including some related test cases and work on some patches:
>>
>> https://rt.cpan.org/Public/Bug/Display.html?id=58552
>
> I'd appreciate
ting behavior should be.
I'm probably missing something but I'd say the 'correct quoting' is
whatever works to get any random data from the app to the database.
> I'm affected by the issue and would personally appreciate the help.
I'd appreciate a summary of the key issues.
Tim.
fix is not passing all the test cases. The
solution will need someone with XS skills, who also has confidence about
exactly what the correct quoting behavior should be.
I'm affected by the issue and would personally appreciate the help.
Thanks!
Mark
Jeff,
The script worked. Thank you so much.
($database_connect = DBI->connect('DBI:ODBC:DSNInfo', 'userid',
'password',{PrintError => 0,RaiseError => 1, })) ;
On Thu, Sep 29, 2011 at 11:04 AM, Perl developer
wrote:
> Jeff,
>
> The following perl script is used to connect to SQL server dat
Jeff,
The following perl script is used to connect to SQL server database using
DBI and DBD::ODBC modules.
*my *$dbh = DBI->*connect*("DBI:ODBC:Driver={SQL
Server};Server=$db_instance;Database=$db_name;UID=$db_user;PWD=$db_pass") or
*die*("\n\nCONNECT ERROR:\n\n$DBI::errstr");
I used the same s
I am attempting to run through as many DBDs as possible producing a list
of those that support Unicode, how they support it (driver flags and
caveats etc) and any issues with it. So far I'm working my way through
DBD::SQLite, DBD::CSV, DBD::ODBC, DBD::Oracle and DBD::Pg (because those
are ones
Mostly there are multiple perl, DBI, ... on your box.
Check which perl is used; what is its version; what library paths are under
this Perl; where is your DBI, where is the DBD::Oracle under the DBI. And then
you need set the environment before call the script; or have the environment
set in th
You have module Apache::DBI which ain't DBI. You need to install DBI (and
DBD::Oracle), probably after compiling them.
JL
--Original Message--
From: Chokhani, Khushboo
To: dbi-users@perl.org
Subject: Need help with DBI connect
Sent: Sep 12, 2011 08:18
Hi,
I have been stuck
ld use the instant client which you can get here
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
CheersJohn
> Subject: Need help with DBI connect
> Date: Mon, 12 Sep 2011 10:18:05 -0500
> From: khushboo.chokh...@bestbuy.com
> To: dbi-
Hi,
I have been stuck with this error since long now, and have tried almost
everything available on web but no luckL
Any help would be greatly appreciated.
When I try to execute a PERL scripts I am getting an error:
ORACLE_HOME=/u01/app/oracle/product/10.2.0
TNS_ADMIN=/usr/local/tns
Jeff Tate schrieb am 08.08.2011 um 17:01 (-0400):
> I have developed a program suite on Windows that talks to a Teradata
> over ODBC and works fine. I need to port it to DBD::Teradata on an AIX
> box, as ODBC is not installed. I have built a local perl (5.14) (cc_r
> is missing, so I had to compile
I have developed a program suite on Windows that talks to a Teradata over
ODBC and works fine. I need to port it to DBD::Teradata on an AIX box, as
ODBC is not installed. I have built a local perl (5.14) (cc_r is missing, so
I had to compile a copy with gcc) and I have installed DBI ver 1.6.16 and
tall both (if I need to) DBI and DBD-mysql?
Thanks for the help,
Nick. . .
perl -MDBI -le 'print $DBI::VERSION'
perl -MDBD::mysql -le 'print $DBD::mysql::VERSION'
You can probably download
I and DBD-mysql?
Thanks for the help,
Nick. . .
--
_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/
. . . . . . . .
The 'We' Tour USA started in March -
o:ganesh.b.ben...@gmail.com]
> Sent: Thursday, June 02, 2011 9:48 AM
> To: dbi-users@perl.org
> Subject: Need Help with DBI for oracle
>
> Hi,
>
> I am using the following code for fetching some data.
> but not able to connect
>
> *CODE:*
> #!C:/Perl/bin/perl.exe
&g
Simple connection problem.
Try to connect SQLPlus if you can do that then you can use DBD::Oracel
Try the same connection string in DBD:Oracle
Hope this helps
cheers
John
> CC: dbi-users@perl.org
> From: jona...@gmail.com
> Subject: Re: Need Help with DBI for oracle
> Date
error when i try to run the above code
> **
> *Error:*
> DBI connect('$database:in-gh01:1521','dba',...) failed: ORA-06401: NETCMN:
> id driver designator (DBD ERROR: OCIServerAttach) at exequery2.pl line 21
> Can't call method "prepare" on an undefined value at exequery2.pl line 25.
> *Error END*
>
> *I have installed *
> *DBD::Oracle*
> *DBI*
> **
> **
> *i am stuck with this for almost one week
> Please help me out*
> **
> *Ganesh.*
> **
iled: ORA-06401: NETCMN:
id driver designator (DBD ERROR: OCIServerAttach) at exequery2.pl line 21
Can't call method "prepare" on an undefined value at exequery2.pl line 25.
*Error END*
*I have installed *
*DBD::Oracle*
*DBI*
**
**
*i am stuck with this for almost one week
Please help me out*
**
*Ganesh.*
**
Thanks..so much...
-Original Message-
From: Owen [mailto:rc...@pcug.org.au]
Sent: Friday, April 29, 2011 11:38 AM
To: Rai, Vikrant (GIS, Technology Services India)
Cc: dbi-users@perl.org
Subject: Re: Help Needed for DBI
> Hello,
> I am really struggling to connect to datab
hout a trailing newline:
perl -MDBI -e "print $DBI::VERSION"
or if you just want to know if *any* version of DBI is installed:
perl -MDBI -e 1
(No error: DBI installed. "Could not find ..." error message: DBI not
installed. Works for any module.)
Also when I am exccuting a d
Apr 2011 20:38:12 +1000
> Subject: Re: Help Needed for DBI
> From: rc...@pcug.org.au
> To: vikrant@rbs.co.uk
> CC: dbi-users@perl.org
>
> > Hello,
> > I am really struggling to connect to database, I am not sure how to
> > ensure that I HAVE DBI sintalled and if
1 - 100 of 1462 matches
Mail list logo
