Sponsored Content
Full Discussion: Perl DBI error
Top Forums Shell Programming and Scripting Perl DBI error Post 302781267 by elixir_sinari on Friday 15th of March 2013 11:02:25 PM
Old 03-16-2013
Which database are you trying to access?
Have you installed the DBD (database driver) module corresponding to that database?
E.g., if you are trying to access Oracle database, you also need to install DBD::Oracle.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl DBI - Bind Parameters Problem

I have a SQL statement that includes a UNION that I can't get to work when I bind the parameters. (I am binding the parameters to prevent SQL injection.) Does anybody have any suggestion on how I can use a SQL statement that includes a UNION and bind the params? Code would be something like... (1 Reply)
Discussion started by: mh53j_fe
1 Replies

2. Shell Programming and Scripting

PERL DBI module install

We ran into an issue trying to install DBI and DB2 modules for perl for AIX from the link http://www-306.ibm.com/software/data/db2/perl/ We tried to install the DBI module using bash# perl -MCPAN -e 'install DBI' command. However we ended up with the following error. Stop. ... (3 Replies)
Discussion started by: jerardfjay
3 Replies

3. Shell Programming and Scripting

perl DBI/DBD Module -in cygwin

Hi all, I am trying to install the DBI module in perl using perl -MCPAN -e shell install 'DBI' --It is installing into the nuild directory properly but when it try to make it is saying NOT OK -I tried to copy the module manually to the /lib/perl5/vendor_perl ... (3 Replies)
Discussion started by: jambesh
3 Replies

4. Programming

perl dbi to oracle getting disconnect_all for oracle dbi help

hi i am trying to connect to an oracle database using dbi and i get this :: Driver has not implemented the disconnect_all method. at /opt/perl/lib/site_perl/5.8.0/sun4-solaris/DBI.pm line 575 END failed--call queue aborted. for all i know, the script was working earlier, but has... (1 Reply)
Discussion started by: poggendroff
1 Replies

5. Shell Programming and Scripting

Installing Perl DBI and DBD

Hi, i have some queries on installing the Perl DBI and the DBD Oracle. I know that i have to install the DBI first. I have the source files in a folder in my home directory.The commands to install arecd /home/DBI Perl Makefile.PL make make installI would like to know, after executing these... (4 Replies)
Discussion started by: new2ss
4 Replies

6. Shell Programming and Scripting

perl DBI inserting date\time

hi there, my mysql database has a date/time field using the standard mysql date|time format of 2009-08-31 00:16:44 when inserting into this field using perl DBI, is there is an easy way to insert the current date/time in without having to preformat the date/time string in perl before... (3 Replies)
Discussion started by: hcclnoodles
3 Replies

7. Shell Programming and Scripting

connect to MySQL from Perl using DBI

Hi, I want to connect perl with the mysql to select and so on but the connection don't work code #!/usr/bin/perl BEGIN { # PERL MODULES WE WILL BE USING use DBI; $dbh = DBI->connect('DBI:mysql:C:\Program Files\MySQL\MySQL Server 5.0\data\db1','','pass') or die $DBI::errstr;} #... (1 Reply)
Discussion started by: eng_shimaa
1 Replies

8. UNIX for Advanced & Expert Users

Perl's DBI Module on OS X - uninstallable?

i've been struggling with installing the Perl DBI & DBD modules all weekend, and I'm getting close, but no cigar as of yet. When I run the perl script db.pl I get the following mismatch error: Mon Apr 19 09:43:29 EDT 2010 /Library/Perl/DBD-mysql-4.011 -> peterv@MBP17.local<515>$: db.pl | tee... (0 Replies)
Discussion started by: peterv6
0 Replies

9. Shell Programming and Scripting

perl: help with DBI

Hi there, I have a bit of code similar to below (which ive actually got from perldoc, but mine is similar enough) $sth = $dbh->prepare(q{ SELECT region, sales FROM sales_by_region }); $sth->execute; my ($region, $sales); # Bind Perl variables to columns: $rv =... (4 Replies)
Discussion started by: hcclnoodles
4 Replies

10. Shell Programming and Scripting

Perl Oracle DBI through Apache problem

Experts, I've been struggling with making a Perl Oracle DBI script to work through my Apache webserver. Mysql DBI scripts work fine, but I'm having issue's with Oracle. The oracle script works on command line, but I'm getting an "Internal Server Error" with apache Sourcing the oracle... (0 Replies)
Discussion started by: timj123
0 Replies
Jifty::DBI::Collection::Union(3pm)			User Contributed Perl Documentation			Jifty::DBI::Collection::Union(3pm)

NAME
Jifty::DBI::Collection::Union - Deal with multiple Jifty::DBI::Collection result sets as one SYNOPSIS
use Jifty::DBI::Collection::Union; my $U = new Jifty::DBI::Collection::Union; $U->add( $tickets1 ); $U->add( $tickets2 ); $U->GotoFirstItem; while (my $z = $U->Next) { printf "%5d %30.30s ", $z->Id, $z->Subject; } WARNING
This module is still experimental. DESCRIPTION
Implements a subset of the Jifty::DBI::Collection methods, but enough to do iteration over a bunch of results. Useful for displaying the results of two unrelated searches (for the same kind of objects) in a single list. METHODS
new Create a new Jifty::DBI::Collection::Union object. No arguments. add COLLECTION Add Jifty::DBI::Collection object COLLECTION to the Union object. It must be the same type as the first object added. first Return the very first element of the Union (which is the first element of the first Collection). Also reset the current pointer to that element. next Return the next element in the Union. last Returns the last item count Returns the total number of elements in the union collection goto_first_item Starts the recordset counter over from the first item. the next time you call "next", you'll get the first item returned by the database, as if you'd just started iterating through the result set. goto_item Unlike "goto_item" in Jifty::DBI::Collection, Union only supports going to the first item in the collection. is_last Returns true if the current row is the last record in the set. items_array_ref Return a reference to an array containing all objects found by this search. Will destroy any positional state. AUTHOR
Copyright (c) 2004 Robert Spier All rights reserved. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
Jifty::DBI, Jifty::DBI::Collection perl v5.14.2 2010-12-09 Jifty::DBI::Collection::Union(3pm)
All times are GMT -4. The time now is 06:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy