>
> I have Active State Perl 5.6. I've used PPM install DBI. I'm using
> this code:
>
>
>
>
> #
> # Perl script that talks with the Northwinds database using
> an # ODBC DSN of Northwind. #
>
> use DBI;
> use Data::Dumper;
>
> my $dbh = DBI->connect( "dbi:ODBC:Northwind", "Admin", "",
>
This distribution has been tested as part of the cpan-testers
effort to test as many new uploads to CPAN as possible.
See http://testers.cpan.org/.
Please cc any replies to [EMAIL PROTECTED] to keep other
test volunteers informed and to prevent duplicate effort.
--
all tests passed after running
On Mon, Dec 02, 2002 at 09:37:58PM -0600, jad wrote:
> I have Active State Perl 5.6. I've used PPM install DBI. I'm using
> this code:
Did you install DBD-ODBC?
> #
> # Perl script that talks with the Northwinds database using an
> # ODBC DSN of Northwind.
> #
>
> use DBI;
> use Data::Dumper;
I have Active State Perl 5.6. I've used PPM install DBI. I'm using
this code:
#
# Perl script that talks with the Northwinds database using an
# ODBC DSN of Northwind.
#
use DBI;
use Data::Dumper;
my $dbh = DBI->connect( "dbi:ODBC:Northwind", "Admin", "",
{RaiseError => 1, PrintError =
Someone reported the following error occuring w/ DBI 1.32 and
DBD::Chart:
> [Tue Dec 3 00:55:57 2002] nul: DBD::Sponge::db do failed: No rows
> attribute supplied to prepare at c:/Perl/site/lib/Deakin/Base.pm line
> 2822.
> [Tue Dec 3 00:55:57 2002] nul: DBD::Sponge::db prepare failed: No
> r
You could, in the loop, do something like:
next if ($tablename =~ /^MSys/);
Regards,
Jeff
> -Original Message-
> From: Brad Smith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 8:54 PM
> To: [EMAIL PROTECTED]
> Subject: table names worked... but...
>
>
> Ok, I m
On Mon, Dec 02, 2002 at 08:39:17PM -0500, Brad Smith wrote:
> foreach $i (@tables) {
> print "$tables[$i]";
> }
Hmmm ... surprised you get anything here. @tables is an array.
@tables = qw/a b c/;
foreach $i (@tables) {
first time in the loop $i == 'a';
So $tables[$i] == $tables[
#!/usr/bin/perl -w
use DBI;
print "$DBI::VERSION\n";
my $dbh = DBI->connect() or die "unable to connect: ", $DBI::errstr;
my @tables = $dbh->tables() or die "Tables failed: ", $DBI::errstr;
foreach my $table (@tables) {
print "table: $table\n";
}
$dbh->disconnect;
exit;
Resu
Ok, I managed to get the table names of an Access database. One
question, though: what is all the information in the first few variables of
a scalar that read something similar to MSysAccess...? Do I just need
to offset by 5~6 each time I want to display the table names?
Thanks in advance.
Reading over the mailing list archives, I found some information about
getting table names. Unfortunately, the information that I retrieve
includes a lot of stuff, none of which are the names of the tables.
Here is the code:
my $dbh = DBI->connect('dbi:ODBC:database_name) || die DBI::errstr;
@
Right you are. No problems with DBD::Pg.
Thanks,
anton.
On Monday, December 2, 2002, at 01:43 PM, Anton Pitts wrote:
I'm actually using DBD::PgPP at version 0.40; I can't say I'm sure
why I picked that one over DBD::Pg. Although I just tried
installing DBD:Pg v 1.20, and it failed at ma
See perldoc DBI
view methods tables, table_info, column_info (meta data).
On Mon, Dec 02, 2002 at 06:29:20PM -0500, Brad Smith wrote:
> Is there some place online that lists the acceptible commands to
> retrieve information about a database? For instance, I would like to be
> able to ask an Ac
On Monday, December 2, 2002, at 01:43 PM, Anton Pitts wrote:
I'm actually using DBD::PgPP at version 0.40; I can't say I'm sure why
I picked that one over DBD::Pg. Although I just tried installing
DBD:Pg v 1.20, and it failed at make test with :
t/01connect.Can't locate Test/More.pm
Is there some place online that lists the acceptible commands to
retrieve information about a database? For instance, I would like to be
able to ask an Access database which tables are available, then, within
each table, what the names of the columns are. I guess this is again
one of those an
I'm actually using DBD::PgPP at version 0.40; I can't say I'm sure
why I picked that one over DBD::Pg. Although I just tried installing
DBD:Pg v 1.20, and it failed at make test with :
t/01connect.Can't locate Test/More.pm in @INC (@INC contains:
blib/arch blib/lib /System/Library/Perl
Dear Mike,
I can reproduce your problem with DBI 1.20 and DBD::Informix 1.04.PC1 on
Solaris 8 with Perl 5.6.1. I will investigate further, but my immediate
reaction is that maybe the problem is that I have included a change that
requires a newer version of DBI than 1.20, but didn't set the pre-r
The -KPIC wasn't the problem. Updated my DBI to DBI-1.32 and it now works.
Some parse error on line 102 with the "->" operator.
Christopher S. Cosby
SciCare Software Services
770.236.1128
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Novem
Thanks for the suggestions.
That's definitely a bug. For now, try to escape it with \?
Escaping with \? inserts \NULL into the db. Same for "? (inserts
"NULL) which a friend suggested trying.
, or if that
doesn't work, then try using a placeholder ? and then bind 'val?' to it.
I'm not sure
On Sunday, December 1, 2002, at 10:16 PM, Anton Pitts wrote:
I'm running postgresql 7.3, perl 5.6.0, DBI 1.30 on mac os x 10.2 and
am having trouble with inserting values ending in a question mark.
What version of DBD::Pg are you using? If it's older than 1.20, please
give 1.20 a try.
Thanks
Hi all,
I've been using DBI::Proxy with DES encryption to connect a bastion host
web server
through a firewall to some internal Oracle DBs. All has been well for a
couple of years
with a mix of Oracle 8.0.5 and 8.1.5 on their side and DBI 1.14 and
DBD:Oracle 1.06
on mine. Over the holiday the
Title: Problem installing DBI on HPux 11.00
I am having trouble installing DBI-1.30 on my HPUX Unix system.
I attach a file with the details of the 'make' failure. I did manage to install it on my test machine (which should be identical, but obviously isn't quite !!)
I would appreciate any
On Mon, Dec 02, 2002 at 11:19:41AM -0500, Jeff Urlwin wrote:
> >
> > I've deleted the lines as you said, and the following error appeared:
> >
> > make: *** No rule to make target ` > `miniperlmain.o'. Stop.
>
> I do not believe the dbi-users mailing list is the best place to get
> help on
>
> I've deleted the lines as you said, and the following error appeared:
>
> make: *** No rule to make target ` `miniperlmain.o'. Stop.
>
I do not believe the dbi-users mailing list is the best place to get
help on building perl itself for HP-UX. There are other places where
the suppor
Something looks fairly broken. Send me (directly) a copy of your
generated Makefile.
Tim
On Mon, Dec 02, 2002 at 03:27:08PM -, Carlos Barroso wrote:
> I've deleted the lines as you said, and the following error appeared:
>
> make: *** No rule to make target ` `miniperlmain.o'. Stop.
>
I've deleted the lines as you said, and the following error appeared:
make: *** No rule to make target `
So I deleted them too.
After deleting the lines and doing "make" again, the follownig error
appeared:
( ... )
AutoSplitting perl library
SHLIB_PATH=/tmp/perl_dbi/perl-5.6.1 ./miniperl
On Mon, Dec 02, 2002 at 01:56:42PM -, Carlos Barroso wrote:
> In the makefile it has lines like the following:
>
> av$(OBJ_EXT):
>
> I don't know what are they for!?
> How can I correct this problem?
Try just deleting those lines.
Tim.
p.s. The README says don't email me directly, a
In the makefile it has lines like the following:
av$(OBJ_EXT):
I don't know what are they for!?
How can I correct this problem?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 2 de Dezembro de 2002 13:23
To: Carlos Barroso
Cc: [EMAIL PROTECT
On Mon, Dec 02, 2002 at 12:30:04PM +0100, H.Merijn Brand wrote:
> On Mon 02 Dec 2002 12:28, "H.Merijn Brand" <[EMAIL PROTECTED]> wrote:
> > On Mon 02 Dec 2002 02:32, David Wheeler <[EMAIL PROTECTED]> wrote:
> > > Tim,
> > >
> > > Got just one warning with the new 1.32 release on Mac OS X 10.2.2:
>
Possibly due to errors in Oracle's own Makefile' (which DBD::Oracle
copies chunks of). What do those lines in the generated Makefile
say (and pay special attention to whether lines start with spaces
or tabs).
Tim.
On Mon, Dec 02, 2002 at 12:35:52PM -, Carlos Barroso wrote:
> Hy.
> I'm trying
Hy.
I'm trying to compile and install perl 5.6.1 on HP-UX.
When I run "make" it gives me the following error:
Bad character > (octal 76), line 679Make: . Stop.
I thought it was because of the "make" binary. So I installed
the depot "gmake", and now it gives me the following error:
Hi,
I'm running MySQL and Perl 5.6 on a Win32 machine. I'm a very
unexperienced Perl programmer, but I need to build a serach engine for a
MySQL database which parses the values entered in a text field (in
simple and advanced query sintaxes similar to those used in Yahoo or
Altavista) and buil
On Sun, Dec 01, 2002 at 05:41:42PM -0800, Jared Still wrote:
>
> It can be. Even a soft parse requires a latch in the database SGA,
> and since all latches are serialized, it could be a problem in a busy
> system.
>
> I am far from the expert in parsing and latching, but i do plan to run
> some
32 matches
Mail list logo