Well, with that stance, somewhere C libraries are still required somewhere
to get a DBD driver compiled. However, I would find the argument more
convincing if it'd s/Proxy/JDBC/ -- i.e. using DBD::JDBC seems to be a
reasonable way to connect to oracle, postgres, etc with no oracle OCI
or postgre
"Mahdi A. Sbeih" wrote:
> I have a static Perl+DBI+DBD::Informix Compiled statically
> on a Solaris 2.6 machine with Informix 7.x server.
Why? Of all the platforms I can think of, this is the one you won't
need to use static linking.
> DBD::Informix was compiled statically; and I used
> the D
Oops there.
Not an array of arrays. That would be just one big array.
Troy
> -Original Message-
> From: Troy Sniff [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 7:03 PM
> To: [EMAIL PROTECTED]
> Subject: Grabbing specific number of random rows
>
>
> Here is what I am t
Below, is a message that Michael Brown posted back in January, which
I found in the archives, but I saw no response from the list. I have tried
to contact him directly, but he had a no-spam reply addy. I would be
interested in hearing whether anyone can offer a solution at this time.
Earlier
Here is what I am trying to do.
I will be running a prepare statement on a table. That query might
return any number of rows from the table.
>From those rows, I want to randomly grab a certain number of them to be
used.
For example, let's say my query returns 134 rows. I want to then
randomly
Here is what I am trying to do.
I will be running a prepare statement on a table. That query might
return any number of rows from the table.
>From those rows, I want to randomly grab a certain number of them to be
used.
For example, let's say my query returns 134 rows. I want to then
randomly
On Fri, Mar 22, 2002 at 03:01:17PM -0800, Stephen Keller wrote:
> Hello All:
>
> I wrote:
>
> > > the version of DBI for a given version of the DBD driver. When
> > > these don't match up, the driver doesn't always work correctly.
>
> Tim asked:
>
> > Why not, exactly?
>
> Most of the probl
On Fri, Mar 22, 2002 at 02:59:00PM -0800, Jeff Zucker wrote:
> Tim Bunce wrote:
>
> > And it's not good I'm afraid. You've effectively hardwired a specific
> > driver in place of the DBI.
>
> What I sent you is a proof of concept, not a final product (tho it works
> for its one driver).
>
> > It
Tim Bunce wrote:
> And it's not good I'm afraid. You've effectively hardwired a specific
> driver in place of the DBI.
What I sent you is a proof of concept, not a final product (tho it works
for its one driver).
> It only emulates the DBI in the narrowest
> sense. You can't use it to load and
Hello All:
I wrote:
> > the version of DBI for a given version of the DBD driver. When
> > these don't match up, the driver doesn't always work correctly.
Tim asked:
> Why not, exactly?
Most of the problems we had were compile failures. Features in the
DBI that weren't present in the DBD:
DBD::Proxy is bundled with DBI. It's a "thin" driver for any DBD.
Tim.
On Fri, Mar 22, 2002 at 01:43:43PM -0800, Ian Kallen wrote:
>
> If DBI were part of the Perl distribution and there were "thin" drivers
> for Oracle, Postgres, etc, it'd be a big win for Perl. I don't
> necessarily like the
On Fri, 22 Mar 2002, Kokarski, Anton wrote:
> Not to mention that before you can install particular driver module you have
> to have database libraries on the host as well. All drivers are dependent
> on those libraries.
When I said "thin driver" I had the oracle thin driver in mind, it doesn't
I have a field in a MySQL database that has a nuber of text strings
seperated by commas. I know how to retrieve a record field as a normal
scalar but how can i retrieve the record, search the comma delimited
strings and say 'if it is present, redirect here, if it is not, redirect
here.' the th
Not to mention that before you can install particular driver module you have
to have database libraries on the host as well. All drivers are dependent
on those libraries.
Anton
-Original Message-
From: Ian Kallen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 1:44 PM
To: Tim Bu
If DBI were part of the Perl distribution and there were "thin" drivers
for Oracle, Postgres, etc, it'd be a big win for Perl. I don't
necessarily like the jdbc api but it's nice to be able to get a jdk, get
the jar you need for a particular backend (w/o regard to linking against
client libs) an
On Fri, Mar 22, 2002 at 08:24:11AM -0800, Jeff Zucker wrote:
> Tim Bunce wrote:
> >
> > I'd appreciate it if anyone who may be interested in a pure-perl
> > DBI emulation could explain why. Just so I can get some idea of the
> > real-world issues that a pure-perl DBI emulation might address.
>
>
> On Fri, 22 Mar 2002 16:10:24 +, Tim Bunce <[EMAIL PROTECTED]> said:
TB> I'd appreciate it if anyone who may be interested in a pure-perl
TB> DBI emulation could explain why. Just so I can get some idea of the
TB> real-world issues that a pure-perl DBI emulation might address.
TB> I'd a
On Fri, Mar 22, 2002 at 09:39:30AM -0800, Stephen Keller wrote:
> Hello all, Tim asked about making DBI part of the main Perl
> distribution. I'm not sure this is such a great idea because
> of the interdependencies between the DBD drivers and the DBI.
> In the case of DB2 it can be a problem b
Hi
Have you tried running this in Win NT. I've had similar problems and I
don't think that there is a solution - but it works ok on Win 95 and Win NT
but not Win 98 and 2000. I've got a machine with Win XP but haven't had a
chance to try it.
Good luck and I'd love to know what the problem is
> I'd appreciate it if anyone who may be interested in a pure-perl
> DBI emulation could explain why. Just so I can get some idea of the
> real-world issues that a pure-perl DBI emulation might address.
I'd like to be able to make use of the 'use lib' function and package
DBI::Lite (or whatever i
Bill McClintock writes:
> > Are you positive that this user can access each of these databases?
> Yes...When the script is run on a Win32 platform using DBD::ODBC I can
> specify the username and password and get the specified data from the
> specified database. with the DBD::Sybase driver
> Are you positive that this user can access each of these databases?
Yes...When the script is run on a Win32 platform using DBD::ODBC I can
specify the username and password and get the specified data from the
specified database. with the DBD::Sybase driver all data for all
combinations come
Vicky,
Go to the DBI home page at http://dbi.symbolstone.org/
There, you will find a FAQ, and everything else you need to get
started.
You will need these packages:
* DBI
* DBD::Oracle
As long as your Oracle 9i is installed and working, install DBI
first, and then DBD::Oracle. DBD::Oracl
Hi Iam new to DBI and DBD but I guess I will need them.
Iam working with following systems:
Oracle 9i on Red Hat Linux 7.1
Tell me as u would a kid how to start with DBI and DBD/Oraperl.
I know Linux and Oracle well.
regards
vicky
-
Do You Yahoo!?
Yahoo! M
Has anyone seen this error and if so how can the problem be corrected
OS = Solaris
Database = Mysql
Can't locate object method "connect" via package "Apache::DBI" at
/opt/gnu/perl5.005_03/lib/site_perl/5.005/sun4-solaris-thread/DBI.pm
line 416.
Thanks
--
Wolfgang Schwurack
Unix System Administr
On Fri, 22 Mar 2002, Jeff Seger wrote:
> The main reason that I see for a DBI::Lite/pure perl distribution is
It would also cut down on all of the Solaris questions.
Q: I downloaded perl-5.6.1 from www.sunfreeware.com
I get errors about "gcc: command not found" when trying to install DBI/D
Hello all, Tim asked about making DBI part of the main Perl
distribution. I'm not sure this is such a great idea because
of the interdependencies between the DBD drivers and the DBI.
In the case of DB2 it can be a problem because IBM specifies
the version of DBI for a given version of the DBD d
Hi all,
I have a static Perl+DBI+DBD::Informix Compiled statically
on a Solaris 2.6 machine with Informix 7.x server.
DBD::Informix was compiled statically; and I used
the DBD_INFORMIX_RELOCATABLE_INFORMIXDIR also.
So when I want to run Perl scripts I need to set
the environment variable LD_LIB
Hello,
I'm new to the list (& DBI) and am trying to load DBI-1.20 on Solaris
2.6.
Unfortunately I'm running into one or 2 problems -
I ran 'perl Makefile.PL' & all was fine. When I did 'make' I got the
following complaints -
cp DBI.pm blib/lib/DBI.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Perl
> You mean DBI as part of the standard core distribution? I can't see how
> that could be a bad thing.
I agree. In fact it would be nice to have DBI and DBD::AnyData bundled with
core perl - in that way the perl community would be guaranteed a working
relational database on all platforms, muc
Tim Bunce wrote:
>
> I'd appreciate it if anyone who may be interested in a pure-perl
> DBI emulation could explain why. Just so I can get some idea of the
> real-world issues that a pure-perl DBI emulation might address.
Precisely the question that has kept me from releasing this. OTOH it's
pr
I'd appreciate it if anyone who may be interested in a pure-perl
DBI emulation could explain why. Just so I can get some idea of the
real-world issues that a pure-perl DBI emulation might address.
I'd also like to know if those real-world issues could be
better addressed by bundling the DBI with
Michael Peppler writes:
> Rainer Brandt writes:
> > t/autocommitld.so.1: /opt/SXperl/bin/perl: fatal: relocation error: file
>/opt/syb_version/V12.0/OCS-12_0/lib/libtli.so: symbol comn_yield: referenced symbol
>not found
>
> This is almost certainly an LD_LIBRARY_PATH problem - usuall
Rainer Brandt writes:
> DBD::Sybase make test fails with the following messages:
>
> PERL_DL_NONLAZY=1 /opt/SXperl/bin/perl -Iblib/arch -Iblib/lib
>-I/opt/SXperl/5.6.1/lib/5.6.1/sun4-solaris -I/opt/SXperl/5.6.1/lib/5.6.1 -e 'use
>Test::Harness qw(&runtests $verbose); $verbose=0; runtests @
Here, at least for reference, is an exerpt from the RDB documentation.
-
SQL provides three floating-point numeric data types:
o FLOAT
Specifies that the column is a 32-bit (REAL) or 64-bit (DOUBLE
PRECISION) floating-point number, depending on the precisi
I'd like to get a copy of the DBI::Lite to look at.
I might have a project that would be perfect for it.
Troy
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 7:58 AM
> To: Jeff Zucker
> Cc: [EMAIL PROTECTED]; Tim Bunce
> Subjec
I'd like to see a copy too. Sounds quite a bit like a workaround I
was tooling around with in my head. Thanks.
Nick Hendler
[EMAIL PROTECTED]
_
From:Jeff Zucker <[EMAIL PROTECTED]>
Date:Thursday, March 21, 2002
Time:2:45:41 PM
Subject: U
Thanks.
I found the LongReadLen a little after I posted this message.
I set it to a higher value as well as my LongTruncOk to 1 and all is
well.
Troy
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 4:24 AM
> To: Troy Sniff
> Cc: [EMAIL
Read up on the LongReadLen attribute.
What driver are you using?
What's the value of the LongTruncOk attribute?
Tim.
On Thu, Mar 21, 2002 at 07:22:37PM -0700, Troy Sniff wrote:
> I have an access db with a table that contains a few memo fields.
>
> Whenever any of those memo fields have more t
Any while(<...>) loop will trample on $_, DBD::Oracle needs to add
local($_); in the block that has the while loop. Thanks.
Tim.
On Thu, Mar 21, 2002 at 06:39:22PM -0600, [EMAIL PROTECTED] wrote:
>
> This looks like a problem with 5.6.1 or XS stepping on
> $_ somewhere.
>
> If I change the cod
On Wed, Mar 20, 2002 at 06:42:11PM -0800, William R Ward wrote:
> [EMAIL PROTECTED] (Tim Bunce) writes:
> > Do this and rummage around in what itside what it defines:
> >
> > require auto::DBD::Oracle::mk; # defines $dbd_oracle_mm_opts and
>$dbd_oracle_mm_self
>
> I think it already changed.
I am getting this error. What am I doing wrong ??
BEFORE: error=999return=TEST
AFTER: error=999 STH2= DBI::ProxyServer::st=HASH(0x28a420)
AFTER: STH1= DBI::db=HASH(0x1ca124)
Can't locate object method "fetchrow_array" via package
"DBI::ProxyServer::st" a
t ./test.pl line 42.
--
- Original Message -
From: Bob T
To: [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 11:08 PM
Subject: DBI w/ DBD:ODBC or DBD:mysql or DBIx-AnyDBD
I am new to Perl DBI programming it is fairly simple..Except I am not
sure I am set up correctly or am using the correct module combina
I have an access db with a table that contains a few memo fields.
Whenever any of those memo fields have more than 81 characters, the
fetchrow_hashref does nothing.
Basically the code looks like this:
while ( $ref = $sth->fetchrow_hashref() ) {
print "Notes: $ref->{notes}";
}
If the va
Troy,
The problem is that you could have two people calling this at
approximately the same time and then you might (?) not get the correct row
for one of them. What about using a sequence and grabbing the nextval from
it at the beginning of the process, this way you have a unique value and ca
On 2002-03-18 10:47:33 -0500, Jason Erickson wrote:
> are you saying that FLOAT(16,3) is not a valid declaration for Mark's
> 'float_col', or that there's something in MySql that won't do it??
Mark didn't say how he defined the columns exactly, just "float" and
"double", so I assumed that he didn
46 matches
Mail list logo
