Your system has two versions of perl installed and DBD::mysql is not
installed for the version your shebang is pointing at.
Either install DBD::mysql to the version of perl you want to use or
change the shebang.
You could of course alter @INC to include the required directories but
this is
Leesa, the DBI module contains a DBD::Proxy module which allows
you to use DBI to interact with a database on a server from a
client - even if that client does *NOT* have database software
installed on it. But in order to use it, you must have other
optional modules installed - these modules are
DBI provides the interface for database access. To do any work, you also
need to install the DBD module for your database (e.g., DBD::Oracle for
Oracle). Follow the instructions through 'make install' for DBI and then
build and install your DBD modules the same way.
Once you have both
Froggatt, S. wrote:
Thanks for the info Simon.
However
1.How do I find which version I am pointing at
2.Where do I find DBI for the version of perl I am running. Excuse my
ignorance but when I download DBI-1.14 I thought that was for all
version.
Best Regards
Steve
Looking
From the sql syntax I'm guessing you're using MySQL - ? Could you tell us
what DBMS you are using - That makes a difference. Or have you tried
printing the SQL statement that has been generated after your if-elsif-else
that builds the statement? If you can print that (maybe even to logfile) you
Actually, you don't even need to set up the DSN ahead of time. Something
like this will make the connection to an MS Access file on a Windows platform.
use DBI;
require DBD::ODBC;
my $source_file = "i:\\Data\\Hanford\\Databases\\Hanford.mdb";
my $con_str =
What are your source and target databases? As long as you have DBI and
DBD::xxx properly installed, you should be able to open a connection to both
and read from one and write to the other using DBI. The details depend on
what RDBMS you are using.
--
Mac :})
** I normally forward private
I've run into the same problem on RedHat 6.2 running perl 5.6.0. I am
trying to set up a Proxy server, but I can't get PlRPC to make it through
the test. If I install it, start the Proxy Server, and try to connect I
get the same message below. I ran it in the debugger and followed down to
Adam Backstrom [EMAIL PROTECTED] writes:
I'm having a problem...
Connect error: Cannot log in to DBI::ProxyServer: Usage:
Sys::Syslog::_PATH_LOG() at /usr/lib/perl5/i386-linux/Sys/Syslog.pm line
277.
So there's a bug in Sys::Syslog and it's even kind enough to tell you
_exactly_ what's
Hi there ..
trying to install DBD::Informix on a solaris machine. I've done it on the
test server which (at least from my point if view) have an indentical
environment and that worked ok. And the perl scripts run fine.
Output from perl Makefile.PL on test server:
---OUTPUT START---
perl
Hi perl guru:
Oracle DBD error: installed DBI, DBD-Oracle using ppm, everything runs well till
yesterday. Get this error:
D:perl test_connect1.pl
install_driver(Oracle) failed: Can't load
'I:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:Access
is denied at
Please ignore my previous e-mail for help - I was able to successfully
decompress unpack the DBD::Oracle stuff onto my IBM OS390 2.9 Unix system
after following the CPAN install modules instructions. Thanks.
Wayne Bileci, Eaton Corporation
Phone: 440-954-5539
Adnet: 621-5539
E-Mail:
There are two DBD-Oracle packages for Windows, DBD-Oracle and DBD-Oracle8. When
I first installed I made the mistake of installing DBD-Oracle instead of
DBD-Oracle8. I had a similar problem. Reinstalling with DBD-Oracle8 solved the
problem. Also the current version is 1.06, 1.03 had some
Hello,
I was recently shown this undocumented syntax to use DBI:
$DBH-selectall_arrayref("SELECT * from FOO",{
dbi_fetchall_arrayref_attr = {} });
That returns a reference to an array of hash references, which is very
useful in some cases, such as passing it to an HTML::Template object.
I'm wondering about persistent DBI connections to Oracle -
the DBI perldoc warns that connect_cached could change in
future versions, so I wanted to see if there are changes
in the works, or is it OK to use connect_cached as-is?
Any gotcha's or things to be aware of?
TIA.
--
Hardy Merrill
On Mon, Mar 19, 2001 at 07:59:33PM -0700, Warren Pollans wrote:
Ron Savage wrote:
I was able to get the script to work by explicitly adding a record
separator ('^M' in vi) at the end of each line - didn't have to define
the column names. I got here by creating a table and seeing what was
I was recently shown this undocumented syntax to use
DBI:
It's not undocumented. First we look up
selectall_arrayref. We see:
$ary_ref = $dbh-selectall_arrayref($statement, \%
attr);
This utility method combines /prepare, /execute and
/fetchall_arrayref into a single
[EMAIL PROTECTED] wrote:
It's not undocumented. First we look up
selectall_arrayref. We see:
$ary_ref = $dbh-selectall_arrayref($statement, \%
attr);
This utility method combines /prepare, /execute and
/fetchall_arrayref into a single call. It returns a
reference to an
Dear Sir,
You much set the environment values DBD_INFORMIX_USERNAME and DBD_INFORMIX_PASSWORD .
Leesa
[EMAIL PROTECTED]
- Original Message -
From: Brd Kregnes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 1:43 AM
Subject: problems installing
Is there a way to specify a timeout parameter for a dbi-connect call? I
know TNS has a timeout limit, but is there a way to specify a timeout in the
connect call? This is so that the script doesn't have to wait forever for a
response from the connect call.
TIA,
Gerardo
Hi!
You wrote:
I am running Oracle 8.1.5 and am using many stored procedures. We
use returned cursors, and individual values. The problem is
Please, send me example of using %subject%. I need retrive multiple rows from stored
procedure.
Thanks for advice.
Alex
PS: I'm beginner in perl,
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 20, 2001 1:23 PM
Subject: Re: Problems posting to [EMAIL PROTECTED]
Michael do you think you can forward, these questions to the user
community. I would appreciate your help. I can't seem to send
I already knew how to do this using fetchall_arrayref, but I don't
believe there is any documentation on how to do this one fell swoop:
return $sth-fetchall_arrayref($slice);
Which is documented eg. fetchall_arrayref({}).
the selectall functions and the like are only utility methods
DBD::Chart 0.30 is now available from either
CPAN or at http://home.earthlink.net/~darnold/dbdchart/.
Changes from 0.20:
- strip newlines from SQL for prepare()
- add BACKGROUND property to set background color,
incl. transparent background
- add FORMAT property to select
Installing DBI on windows just failing.
Where can I get a ppd file for DBI?
Here is the error I am getting:
=
Error installing package 'DBI': Could not locate a PPD file for package DBI
=
Any help please ?
Do you have internet connection? If yes you must be behid firewall, see ppm
docs.
Ilya Sterin
-Original Message-
From: Perl [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 12:58 AM
To: dBI MAIL USERS
Subject: installing DBI on windows
Installing DBI on windows just
now ,I am installing DBD-Informix-0.95, but I don't how to set up the setting
DBD_INFORMIX_USE_EPRINTF_CODE and DBD_INFORMIX_DISABLE_ASSERT
in the environment before running 'perl Makefile.PL'.
Could you help me?
Leesa
[EMAIL PROTECTED]
Not really a DBI problem but ...
All the ftp methods return undef on error, at which point
you can use standard Perl error checking to do whatever.
put() and get() return the filename on success (remote or
local) if you need that info.
See the Net::FTP docs. They're pretty clear.
There is
28 matches
Mail list logo