Hello Rajanath,
I am working with Mahesh on this project. We are interested in using the
Oracle DBD for Windows. Will the DBD-Oracle8 driver below work with
Windows?
Thanks for your help.
Regards,
Addison
"Rajanath Tadikonda" <[EMAIL PROTECTED]> on 05/09/2001 04:22:39 PM
To: [EMAIL PRO
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 2:29 PM
> To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED]
> Subject: RE: Problem with DBI and Access newbie
>
>
> Neil, not that I'm an Access expert, but I believe (almost
> sure) th
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 2:26 PM
> To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED]
> Subject: RE: Problem with DBI and Access newbie
>
>
> >>$SQL = qq|INSERT INTO Respondent (england, relativity,
> >> lotr
At 8:59 AM -0600 5/9/01, Sterin, Ilya wrote:
>Actually with DBD::Mysql you can use $sth->{insertid};
>with the statement handle to get the last autoincrement value.
insertid is deprecated now. Better to use $dbh->{mysql_insertid}.
>
>Ilya Sterin
>
>-Original Message-
>From: Paul Cotter
Neil, not that I'm an Access expert, but I believe (almost sure) that Access
supports transactions with Visual Basic ODBC and as macros, but are you
saying that Access does not support transactions through DBI?
Ilya Sterin
-Original Message-
From: Neil Lunn [mailto:[EMAIL PROTECTED]]
Sen
>>$SQL = qq|INSERT INTO Respondent (england, relativity,
>> lotr) VALUES =
>> ( '$england', '$relativity', '$lotr')|;
>And theres your problem. '$england' does not interpolate. You want
>"$england" and so forth.
$england would interpolate, since it's enclosed in double quotes qq | " ...
$en
I don't use ODBC, so I can only make some general observations (###).
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Jac
'?' placeholders get converted into ':1' style placeholders inside
DBD::Oracle, so there should be no reason that they wouldn't work. The
examples in DBD-Oracle-1.06/Oracle.ex/ use named placeholders like ':value'
because they are easier to keep straight, but they are not required.
The statement
Missed this before. My eyes hurt! Answer Below.
> -Original Message-
> From: Trevor Webster [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 5:03 PM
> To: [EMAIL PROTECTED]
> Subject: Problem with DBI and Access newbie
>
>
> Hello
>
> I am running a Perl script that is suppos
Jack,
Just as an extra check. What do you get if you fully qualify the DSN in the
dbi connect string?
(that is, a DSN'less connection) ie "dbi:ODBC:driver= 'etc'"
Neil
> -Original Message-
> From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 6:12 AM
> To: [EMA
Thanks, Tim. I totally agree. At least now there is an expected behavior,
PrintError and RaiseError if both are turned on, shouldn't be any confusion.
The reflected change in the docs is also very clear.
Ilya Sterin
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: We
It's on the Activestate site. When you install activestate perl from
www.activestate.com you can then go to the command prompt (while you are
connected to the internet) and say this.
>ppm install DBI
and then
>ppm install DBD::Oracle8
Ilya Sterin
-Original Message-
From: [EMAIL PROTE
have done this before and have no problems. I will
send you the snippet tomorrow if you want.
you have to do:
use DBD:Oracle(:ora_types);
and then say which column is the CLOB.
I don't have the syntax in front of me. But will send
it off list tomorrow if someone else doesn't answer.
Job
--- [E
> > As long and the words 'warn' and 'die' are listed in the
> documentation I
> > agree that this should be very clear.
> > Umm. Does that just mean in the docs or :
> >
> > -if (!raise_error || (diehook && SvOK(diehook)))
> > +if (!raise_error)
>
> The internal code is
On Thu, May 10, 2001 at 09:54:30AM +1000, Neil Lunn wrote:
> >
> > but now I've changed it to say:
> >
> > : If you turn C on then you'd normally turn
> > C off.
>
> I like that, it's an important statement to make.
>
> > : If C is also on, then the C is done
> > first (naturally).
> >
> >
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 7:07 AM
> To: Sterin, Ilya
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: executing atomic transactions in DBI
>
>
> but now I've changed it to say:
>
> : If you turn C on then yo
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 6:14 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: (Fwd) Oraperl Binary for Windows
>
>
> Thanks a lot for that 3 * 10 ** 8 m/sec response :)
Try this/You can find all these drivers and dbd's in Activestate.com
C:\>ppm
PPM interactive shell (2.1.2) - type 'help' for available commands.
PPM> search DBD
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:
PPMServer:
DBD-CSV [0.1025] DBI driver for CSV file
DBI v1.14, DBD::Oracle v1.06
All, I have a module containing methods I use all the time on IRIX and
Win32 boxes to pull data stored in CLOB fields from a table stored on a
Solaris DB machine. For the first time today I tried using this SAME method
in a perl CGI script and got nothing back.
No e
I'm trying to connect to an Oracle 8.1.6 database using perl 5.6.0. My
Oracle client is 8.0.5.My DBI/DBD version is 1.13.
Error message is given below:
install_driver(Oracle) failed: can't load
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle.so
for module DBD::Oracle: ld.s
Thanks a lot for that 3 * 10 ** 8 m/sec response :) , we dont see a binary
version for DBI and DBD ..are they available.? or should we have C compiler
and have to compile it..
-- Forwarded by Mahesh L Velapakam on 05/09/2001 01:08
PM ---
"Sterin, Ilya
Steve,
I believe the answers are yes and yes --
I do lots of stuff like this ---
my $sites_count_sth = $dbh->prepare( q(
BEGIN
getsitescount( :cnid, :sitecount, :pubsitecount );
END;
));
$sites_count_sth->bind_param(":cnid", $cnid);
$sites
The AutoCommit is an over-site that I need to fix. You may
/opt init_autocommit=0, but it doesn't turn autocommit off. It just sets
the value to 0.
For now, use the "dbi:Sybase(AutoCommit=>0):..."
perldoc DBI
"You can also define connection attribute values within
the "$data_sourc
At 5:34 PM -0400 5/9/01, Phillip Perkins wrote:
>Anybody care to give their thoughts on what the best/most stable
>DBI/Data combination is? Will it be MySQL, mSQL, Sybase, PostgreSQL, or
>what? I'm looking for a combination that will provide reliable
>performance and also give features such as l
Anybody care to give their thoughts on what the best/most stable
DBI/Data combination is? Will it be MySQL, mSQL, Sybase, PostgreSQL, or
what? I'm looking for a combination that will provide reliable
performance and also give features such as linking to other data or
something such as...
TIA
P
I had the same problem running the following version.
# perl -v
This is perl, version 5.005_03 built for sun4-solaris
Solaris 2.6
Thu Jan 13 17:22:49 2000: Module the DBI manpage
o install
On Wed, May 09, 2001 at 08:42:40AM -0600, Sterin, Ilya wrote:
> Now as I read it a few times, I can make sense out of it. Just a long day
> yersterday. Although it can be a little bit more clearly explained for
> challenged people like myself:-)
>
> I guess maybe reverse thinking...
>
> ***
>
With dbish in DBI 1.14, if you do
/option init_autocommit=0
/connect back_ to_ your_ datasource
AutoCommit will be turned off.
I don't know about the Sybase DSN...
- Original Message -
From: "Curt Russell Crandall" <[EMAIL PROTECTED]>
To: "Jones Robert Contr 81 CS/SCK" <[EMAIL
You are right. I looked into httpd error log and found the
"ct_cmd_alloc failed" entries.
Regarding the memory availability server has 512Mb Ram and I limited
the number of httpd childs to 20 (noticed that 20-22Mb is the largest
per child) I'll try to decrease/tune the MaxClients value to s
I don't think that'll work with dbish. Thanks anyway.
On Wed, 9 May 2001, Jones Robert Contr 81 CS/SCK wrote:
>
>
> Try ...
>
> $dbh->{AutoCommit} = 0;
>
>
>
> -Original Message-
> From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 1:57 PM
> To:
The end result I need is that I need to be able to connect to a MSSQL
server on a WinNT box from perl on my linux box. If someone can help me
make this happen, I'll buy you lunch (if you aren't in Austin, TX, I'll
send you a gift certificate). Here is what I currently have:
I have inst
I have not had a chance to try 1.15... it had some known other
problems and Tim will be releasing a new version soon.
Could you try to figure what the compile error is and then send that to the
list... (and to tim).
Once you have done that, I suggest you back down to perl 5.6.0
and DBI 1.14. Ha
I thought I read this in docs somewhere but can't find it:
Can Oracle SP's be prepared once and executed multiple times
using placeholder values? And, is '?' acceptable as a
placeholder?
The SP examples I have are all prepare once/execute once and
all use the :1 placeholder syntax.
Stev
- Original Message -
From: Mickey Mestel <[EMAIL PROTECTED]>
To: Dbi-Users@Perl. Org <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 9:58 PM
Subject: DBD:Oracle memory leak
> Oracle 8.1.7
>
> and the problem is back. my application runs forever as a daemon, and
> connects and disconn
Try ...
$dbh->{AutoCommit} = 0;
-Original Message-
From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:57 PM
To: [EMAIL PROTECTED]
Subject: dbish questions
There's a couple of things I'm having a proble with when trying to use
dbish. First, I wan
hi,
i posted a few weeks ago, and didn't get an answer, so i'm trying again. i
assume that if i'm seeing this problem, then someone else must be as well.
there was a memory leak in DBD::Oracle 1.2 (i'm pretty sure it was 1.2)
that came about on connect/disconnect. it was a runn
Dimulescu, Ovidiu writes:
> Hi all,
The problem appears to be that the ct_cmd_alloc() call fails:
> -> execute for DBD::Sybase::st (DBI::st=HASH(0x1c69cbc)~0x1c59c44)
> syb_st_execute() -> ct_command() failed (cmd=0, statement=SELECT
> ClientEmail From Domains Where DoaminName='test0
Oraperl is depricated interface. Use DBI and DBD::Oracle. You can download
and install from activestate. You must have ActiveState Perl installed.
Then use the ppm utility to install. See docs for instructions.
Ilya Sterin
-Original Message-
From: Tim Bunce
To: [EMAIL PROTECTED]
Cc:
- Forwarded message from [EMAIL PROTECTED] -
From: [EMAIL PROTECTED] ()
X-Server-Uuid: 1569d162-b3be-4edd-8d78-ab9187b54f11
Subject: Oraperl Binary for Windows
To: [EMAIL PROTECTED]
Date: Wed, 9 May 2001 11:50:43 -0700
X-MIMETrack: Serialize by Router on SV-GW1/Seagate Internet(Release 5.
I've got Perl 5.6.1 running on a HP-UX 11 machine and am now attempting to
install DBI 1.15. The log below shows what happens when I attempt to compile it
- the important part being "DBI.xs:696: parse error before `l'". Anyone have
suggestions, or is this a bug?
perl Makefile.PL
*** Note:
Th
There's a couple of things I'm having a proble with when trying to use
dbish. First, I want to turn autocommit off. So, according to the
perldoc on DBI::Shell, I'm supposed to type /option autocommit=0, but when
I do I get the message:
Unknown or ambiguous option name 'autocommit'
I do see an
>From: Michael Peppler <[EMAIL PROTECTED]>
>To: "David Sevier" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: DBD:Sybase and $sth->{SCALE}
>Date: Mon, 7 May 2001 14:24:36 -0700 (PDT)
>
>David Sevier writes:
> > When done using DBD:ODBC through the proxy, it works fine. But with
> >
hi,
this is an update to my previous post in this regard. I set a custom error
handler via $dbHandle->{syb_err_handler} = \&syb_err_handler and it is
not being called when the reported error occurs.
i've tried to generate an error with a wrong query and the handler was
called
as well as the err
Are there any data sources that don't begin with "dbi:"? If so, what? If
not, are there any plans to make DBI work with some?
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com
Hello
I am running a Perl script that is supposed to added a record to an MS Access database
using the DBI module.
I am testing the script using MS PWS on a Windows 2000 os with Activestate Perl 626.
Input into the script comes from parsed form informtion, which is working successfully.
When
Hi all,
I am having a problem while querying the database. What is strange is that
*errstr*, *err* and *state* are empty after the execute() call fails
returning undef
so I cannot figure out what the problem is. RaiseError is set to 1. Below
you'll
find the piece of code that triggers the err
Ray,
I did remove everything and sart all over, this is what I am having as
errors now.
Lamine Diatta
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI: ls
dbi-1.15.tar
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI:
lamine-[root] /PERL-DBI: tar
On Tuesday 08 May 2001 03:08, [EMAIL PROTECTED] wrote:
> You can do a DESC command in SQL, although most interfaces also provide
> a specific way of doing this.
Gregory,
DESC is an Oracle SQLPlus command; it won't work in a SQL statement.
Jared
Actually with DBD::Mysql you can use $sth->{insertid};
with the statement handle to get the last autoincrement value.
Ilya Sterin
-Original Message-
From: Paul Cotter
To: [EMAIL PROTECTED]
Sent: 05/09/2001 8:20 AM
Subject: Re: Auto increment - return value
Not on the ones I have used.
Make sure your ORACLE_HOME and LD_LIBRARY_PATH are correctly set for the
username you are running the script with and also for the username that the
server will be executing the script with, which is usually 'nobody'.
Ilya Sterin
-Original Message-
From: Tim Bunce
To: [EMAIL PROTECTED]
C
For DBI to work you must install DBI and then DBD drivers of your need.
Looks like you are using DBD::Proxy and it tells you that all the DBD::Proxy
requires have not been installed. Look at the Readme file for DBD::Proxy to
see what other modules need to be installed for it to work properly.
Il
For MySQL, you can use this:
"SELECT last_insert_id() FROM foo"
At 10:21 AM 05/09/2001, T.P.Afamdi Okeke wrote:
>Thanks for the quick responses,
>
> Yes, I should have mentioned I'm using a MySQL
>database (and of course PERL to access it).
>
>
>>From: Alessio Bragadini <[EMAIL PROTECTED]>
>>To
Now as I read it a few times, I can make sense out of it. Just a long day
yersterday. Although it can be a little bit more clearly explained for
challenged people like myself:-)
I guess maybe reverse thinking...
***
If `PrintError' is also on, then it will be skipped
since the 'die' will print
I could go along with a 'finish() called on a completed query' complaint,
but I've left code behind at client sites that uses $sth->finish() and is
unlikely to be updated or reviewed anytime in the foreseeable future.
--
Mac :})
** I normally forward private database questions to the DBI mail list
Not on the ones I have used. Normally (well my normal anyway) you have to
extract it from elsewhere.
For example, Sybase SQL anywhere you need "select @@identity" executed
immediately afterwards. One other way is to put the insert a stored
procedure and return the auto-increment value.
However i
Thanks for the quick responses,
Yes, I should have mentioned I'm using a MySQL
database (and of course PERL to access it).
>From: Alessio Bragadini <[EMAIL PROTECTED]>
>To: "T.P.Afamdi Okeke" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Auto increment - return value
>Date: Wed, 09
"T.P.Afamdi Okeke" wrote:
> If you perform an insert on a table with an auto-increment
> field, does DBI return the auto increment value of the row that
> was just inserted?
No, never. If you give us more details about the database you are using
we can tell you how to do it.
--
Alessio F. Brag
Hey guys,
If you perform an insert on a table with an auto-increment
field, does DBI return the auto increment value of the row that
was just inserted?
Paul
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotm
- Forwarded message from Joe Zimmerlin <[EMAIL PROTECTED]> -
Date: Tue, 08 May 2001 14:02:15 -0400
From: Joe Zimmerlin <[EMAIL PROTECTED]>
Organization: Parabon Computation, Inc.
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: Oracle DBD
Sorry about that last email, I'm running Linu
On Tue, May 08, 2001 at 11:06:58AM -0600, Sterin, Ilya wrote:
> In the docs shouldn't this be changed...
>
> ***
>If `PrintError' is also on, then the
> `PrintError' is done before the `RaiseError'
> ***
>
> to
>
> ***
>
>If `PrintError' is also on, then the
> `
Hi,
When I try to build DBD-Oracle 1.06 on SGI IRIX, I get the following
error on perl Makefile.PL:
Writing Makefile for DBD::Oracle
Argument "_ABIN32" isn't numeric in eq at
/usr/freeware/lib/perl5/site_perl/5.005/sys/types.ph line 11.
Argument "_ABIN32" isn't numeric in eq at
/usr/freeware/lib
Your perl installation is broken.
Tim.
On Wed, May 02, 2001 at 06:13:56PM -0400, Simon Yates wrote:
> Help please!
>
> I can execute perl Makefile.PL fine
> when I run make, I get a bunch of errors.
>
> So you could see what I was doing, I ran script. See file attached.
>
> <>
>
> my syste
On Fri, May 04, 2001 at 04:49:59PM -0600, Peter J. Schoenster wrote:
>
> eval {
> my $sql = qq|INSERT INTO company_profile
> (company_description,company_name,culture,employees,employer
> _id,growth_rate,leadership,mission,sec_fillings_url,type,url,year)
> VALUES(?,?,?,?,?,?,?,?,?,?,?,?)|
- Forwarded message from "Paul.Pslee" <[EMAIL PROTECTED]> -
From: "Paul.Pslee" <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: Please help
Date: Wed, 9 May 2001 12:35:15 +0800
X-SMTP-HELO: mail1.maxis.net.my
X-SMTP-MAIL-FROM: [EMAIL PROTECTED]
X-SMTP-RCPT-TO: [EMAIL PROTE
64 matches
Mail list logo
