Hi,
I'm trying to connect to an Oracle database using ASO and Kerberos5. The
connection through SQL*Plus works properly but I couldn't find any
documentation/hints on how to connect through DBI/DBD.
Is there anybody who know how to connect?
Thanks for any hint
Felix
I have installed the following SW on Solaris 2.6:
perl 5.6.1
DBI-1.21
DBD:Oracle-1.12
DBD:Sybase-0.94
freetds-0.53 (connecting to MS-SQL 7.0 with TDS_VER 7.0)
Because I'm new to DBI, I tried to write some programs (copies/modifications
of examples found i
Thank you for a comment.
> I trust the docs describe explicitly any and all differences between
> DBD::mysql and DBD::mysqlPP.
I agree with the necessity for the information. It
arranges based on the information on perldoc DBD::mysql.
After this work finishes, it posts to CPAN.
__
H
> Useless use of a variable in void context at ...DBD/mysqlPP.pm line
> 11.
>
> in cleanup) Driver has not implemented DESTROY for
> DBI::db=HASH(0x1d32eb4) at ...
These problems were corrected. Since there was a problem
also in quote() of bind_param(), it corrected.
Probably, if it change
if this is a single query in a web page, at least he avoids the hassle of
trying to install DBI and DBD.. :)
we all know how many hundreds of messages we see from people who can't get
their DBD drivers to make properly.
what kind of overhead does DBI and DBD add to your script in a plain cgi
envi
At 04:28 PM 4/3/02 -0500, Kevin Old wrote:
>Hello all,
>
>I am a consultant brought in to manage and restructure some Perl scripts that
>were written some time ago. The programmer at that time was using the
>following code to do a query from within a CGI page.
>
> ${query} = "SELECT ccyymmdd
Wow, that's some silly code:-) Yes, you can do this and in some instances
running through mysql command might be faster, but the portability, design,
expandability of this sucks. You can use placeholders, long column queries,
etc... Did this guy write this years and years ago or something, or w
Hello all,
I am a consultant brought in to manage and restructure some Perl scripts that
were written some time ago. The programmer at that time was using the
following code to do a query from within a CGI page.
${query} = "SELECT ccyymmddhh FROM inventory ORDER BY ccyymmddhh ;" ;
Ah, I've just remembered the UTF8 patch kindly sent by Stefan Eissing!
I've appended his email and attached the attachments.
Please let me, and Stefan, know how it goes for you.
Tim.
--
Tim,
attached is the current diff against 1.03 of my utf8 port.
With Perl 5.6.0 patchlevel 6090, all tes
From: "Andhavarapu, Srinivas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 09:34
Subject: Need information about oraperl
> I am not sure if I am sending this email to the correct group. If not
> excuse me for my intrusion and if possible send me in the right direc
On Wed, Apr 03, 2002 at 06:11:33PM +0200, T. van Dyk wrote:
>
> -> prepare for DBD::Oracle::db (DBI::db=HASH(0x401e4e6c)~0x401c34f8 'select
>area_node.core_description,lab_user.log,
> lab_logon_session,
> lab_user_role,
>
> Hi,
I am not sure if I am sending this email to the correct group. If not
excuse me for my intrusion and if possible send me in the right direction.
> We are thinking of moving from Sybase to Oracle (for various reasons) and
> we would like to make use of the PERL/Sybperl code that we have. I
You must have Oracle client libs installed on your PC, then recompile
DBD::Oracle. Make sure Oracle lib dir is also in your LD_LIBRARY_PATH.
Ilya
-Original Message-
From: Yuriy Lebedyev
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 4/2/02 11:46 PM
Subject: bugs
Hello, my name is Yu
I'm trying out exec+placeholders with DBD::Sybase 0.94. I made the following
change to t/exec.t:
--- DBD-Sybase-0.94/t/exec.t~ Tue Jul 3 11:52:21 2001
+++ DBD-Sybase-0.94/t/exec.t Wed Apr 3 12:23:54 2002
@@ -59,13 +59,16 @@
}
} while($sth->{syb_more_results});
-$dbh->do("use tempdb")
Hello Bogdan Badiu, you asked about database connects and forks.
Well, I tried both your scripts out on a Linux machine and got no errors
at all. I was also able to get the fork to work on a Windows 2000 machine,
but I don't have the DBI installed on that box to try the combination. Is
it
poss
Hi! I am running ActiveState Perl 5.6.1 and using DBI 1.21 and
DBD-Mysql 1.2200.
I have a small problem with forks and database connections … I run
a simple script that connects to a mysql database , after that it
disconnects and after that is trying to fork! The forked process p
This is my first time trying a proxy connection. I am using the Perl DBI
book as a guide. The DB is hosted on a NT server and I started the service
with
dbiproxy --localport --debug
which is running. The client is on an old Unix box. I get a DBD::Proxy::db
STORE failed error (see detail b
I didn't think this was a problem. By default everything binds as varchar
and therefore truncates the bind value. You bind it as a CHAR to prevent
truncating?
Ilya
-Original Message-
From: Tim Bunce
To: T. van Dyk
Cc: 'Tim Bunce'; [EMAIL PROTECTED]
Sent: 4/3/02 6:45 AM
Subject: Re: Per
Bind it as CHAR.
Ilya
-Original Message-
From: Amr Awadallah
To: Bart Lateur; [EMAIL PROTECTED]
Sent: 4/3/02 3:06 AM
Subject: Re: BUG: Perl DBI truncates Trailing Spaces from Placeholder Bind
Variables.
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not w
On Wed, Apr 03, 2002 at 02:47:36PM +0200, T. van Dyk wrote:
>
> -> prepare for DBD::Oracle::db (DBI::db=HASH(0x401e4e84)~0x401c3510
> 'select area_node.core_description,lab_user.log,
> lab_logon_session,
> lab_user_role,
>
Forgot to mention one thing, if I turn the logging off
by "ontape -N pdqtest", then I have much much less memory
leaks, probably 3 megs after 50K of records updates.
I don't know I mentioned this or not, I need the logging on
because I need to do cascading delete on my db.
thanks.
yan
Jona
Tim, Thanks for your reply. Here is the complete trace output (starting
from the connect):
DBI 1.20-nothread dispatch trace level set to 2
Note: perl is running without the recommended perl -w option
logfile path: /home/advantex/server_stats
advx_stats_test.pl script databas
On Wed, Apr 03, 2002 at 12:54:50PM +0200, T. van Dyk wrote:
> I'm having a problem with selecting rows from a query which joins 6 tables.
> I'm sure its a buffer-related problem but I cannot figure out how to
> overcome this. The query returns about 60 rows with no problems, then fails
> with the
I'm having a problem with selecting rows from a query which joins 6 tables.
I'm sure its a buffer-related problem but I cannot figure out how to
overcome this. The query returns about 60 rows with no problems, then fails
with the Oracle truncation error ORA-24345.
Here's the trace output from DB
On 2002-04-03 02:06:15 -0800, Amr Awadallah wrote:
> yes, this works:
>
> Select * From Employee Where Name = 'Mario '
>
> but this does not work:
>
> $sth->prepare('Select * From Employee Where Name =
> ?');
This is a known behaviour of DBD::Oracle. There are several low-level
Oracle types wh
OK I think this is to do with the default type that the column is being
bound to. I assume that name is a varchar column.
By default varchar's remove trailing spaces so insead of the implicit bind
what if you do...?
$sth->bind_param(1,'Mario ', {TYPE => SQL_CHAR});
$sth->execute;
This should p
- Original Message -
From: "Amr Awadallah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 4:16 PM
Subject: BUG: Perl DBI truncates Trailing Spaces from Placeholder Bind
Variables.
>
> Can somebody please confirm/dis-confirm this bug. If
> it is indeed a bug
Does it work when using single quotes around the placeholder?
Instead of
$sth->prepare('Select * From Employee Where Name = ?');
try
$sth->prepare("Select * From Employee Where Name = '?'");
Cheers
+rl
Amr Awadallah wrote:
>
> yes, this works:
>
> Select * From Employee Where Name = 'Ma
yes, this works:
Select * From Employee Where Name = 'Mario '
but this does not work:
$sth->prepare('Select * From Employee Where Name =
?');
and then you $sth->execute('Mario ');
(no offense to Mario of course)
-- Amr
--- Bart Lateur <[EMAIL PROTECTED]> wrote:
> On Tue, 2 Apr 2002 23:16:
I suggest you also set the SHLIB_PATH environment variable to $ORACLE_HOME/lib. This
may sort out the problem.
-Original Message-
From: Yuriy Lebedyev [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 07:47
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: bugs
Hello, my name is Yuriy
On Tue, 2 Apr 2002 23:16:47 -0800 (PST), Amr Awadallah wrote:
>Diagnosis: DBI removes trailing spaces from values
>before passing them through hence the query becomes
>
> Select * From Employee Where Name = 'Mario'
>
>instead of the intended
>
> Select * From Employee Where Name = 'Mario '
Yo
Hello, my name is Yuriy Lebedeyev.
I've tried to run my small script ora.pl but got an error like following:
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.0/i386-svr5/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: dynamic linker : /usr/local/bin/perl : error
Can somebody please confirm/dis-confirm this bug. If
it is indeed a bug who to contact for fix?
Platforms Affected: Confirmed on FreeBSD, Linux and
WinNT/2K with Oracle (but I assume its a DBI problem,
hence does not matter which DBD)
Example: Select * From Employee Where Name = ?
If the ? p
33 matches
Mail list logo