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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
dbd::firebirdembedded
FirebirdEmbedded(3pm) User Contributed Perl Documentation FirebirdEmbedded(3pm)
NAME
DBD::FirebirdEmbedded - embedded Firebird server (and client)
SYNOPSIS
use DBI;
$dbh = DBI->connect("dbi:FirebirdEmbedded:db=$dbname", undef, undef);
# See the DBI module documentation for full details
DESCRIPTION
DBD::FirebirdEmbedded is a variant of DBD::FirebirdEmbedded, linked with the Firebird embedded library, libfbembed. In addition to the
ability to work with remote Firebird servers (which DBD::FirebirdEmbedded has, being linked with the Firebird client library, libfbclient),
DBD::FirebirdEmbedded can be used to work with Firebird databases without the need of a dedicated Firebird server.
The following things should be set up first:
Username/password
These should be unset. Both in the "DBI->connection(...)" call and in the environment ("ISC_USER", "ISC_PASSWORD", "DBI_USER",
"DBI_PASSWORD" variables).
Firebird lock directory
The "FIREBIRD_LOCK" environment variable should be set to some place where the process can write. Note that if you plan for several
processes to access the database file directly, they all should have "FIREBIRD_LOCK" set to the same directory, or else database
corruption will occur.
No "host" in the DSN
Obviously, do not set any host when calling "DBI->connection(...)", not even "localhost".
Permissions to read/write the database
Obviously, the process needs to be able to read/write the database file.
COMPARISON WITH DBD
::FIREBIRD
DBD::FirebirdEmbedded provides exactly the same functionality as the Firebird server of the same version as the libfbembed library. It
still can work with remote datases, in which case the use is exactly the same (DSN, environment) as with the regular DBD::FirebirdEmbedded.
Pros
Standalone work with Firebird databases
No need to setup/administer a Firebird server. All the server functionality is available via the libfbembed library. Shared access to
databases is still possible (but read "Firebird lock directory" above).
No network latency
Working directly with the database file elliminates possible network delays (even if the server is on the local host).
Cons
Memory footprint
The libfbembed library contains a fully functional Firebird server and is therefore bigger than the ordinary client library,
libfbclient.
Setup complexity
It is very important to make sure that all processes that access a given database use the same lock directory. See "Firebird lock
directory" above.
SEE ALSO
DBD::FirebirdEmbedded
perl v5.14.2 2011-11-15 FirebirdEmbedded(3pm)