Class::DBI is a simple database-object mapping system. Simply point
it at your database, set up some classes to represent your tables,
tell it the relationships between your tables, and let it handle all
the 'simple' SQL for you (more complex queries can be written in SQL).
[See
Yes, I have substitued -fPIC. but i have another error:
gcc -c -xO3 -xdepend -DVERSION=\1.18\ -DXS_VERSION=\1.18\ -fPIC
-I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c
gcc: language depend not recognized
gcc: Perl.c: linker input file unused since linking not done
/bin/perl
On Sun, 23 Jun 2002 21:41:28 -0700 (PDT), Clarence Snivellwitz wrote:
Can someone tell me who authored the DBI module? I'm
trying to locate the documentation on CPAN, and I come
up with too many results when I use just use DBI for
the search.
You shouldn't bother the author of such a widely
Attached is my entire perl script, and the DBI-trace(2) output that I
created with it.
Just as a reminder, I am running Red Hat 7.3, and oracle client 8.1.7.
I installed all of the compatibility libraries and set ORACLE_HOME,
ORACLE_SID, and LD_ASSUME_KERNEL=2.2.5
before I set any of those, I
Hi,
starting the following Perl-Script located in cgi-bin-directory through
a web browser a problem with the dbd::Oracle module occurs:
#! /usr/bin/perl
use DBI;
$dbhp = DBI-connect('DBI:Oracle:host=billix;sid=phoenix',
'username', 'password',
I think it's the other way round:
On the client side (perl cgi) set
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1;export NLS_LANG
(syntax: NLS_LANG = language_territory.charset)
Yes, indeed. Like this it worked. Thanks for your help.
Thomas
On Sun, Jun 23, 2002 at 09:41:28PM -0700, Clarence Snivellwitz wrote:
Can someone tell me who authored the DBI module? I'm
trying to locate the documentation on CPAN, and I come
up with too many results when I use just use DBI for
the search.
Giving a search engine a single word rarely
And it wouldn't happen to be Tim Bunce would it? Oh, and some fellow by the name of
Alligator Descartes??
You are too modest Tim! I have been using the DBI for at least 5 years now and it is
the one module I totally rely upon to get my work done. Maybe it doesn't get said
often enough, but
On Mon, 24 Jun 2002 11:23:51 -0400, [EMAIL PROTECTED] wrote:
i have the following
problem: can't locate object method connect via package
DBI.
Does your script even do:
use DBI;
?
--
Bart.
German,
Estoy apesadumbrado. No tengo ninguna experiencia con el perlcc.
--Thunder
dbi-users,
TRANSLATION:
When I execute with Perl, I don't have any problems. When I do an
executable with perlcc, at the moment I execute the archive, I get the
message 'Can't locate object method connect via
1.. Have you made the scripts executable? by using CHMOD 755 or something similar. You
can often do this in your ftp client.
2.. Who is your provider, so we may all studiously avoid them in the future?
John Day
Words Images
Toronto, Canada
At 11:07 AM 6/24/2002 -0400, Nick Hoffman [UWO]
My domain is being hosted on an NT server, so I can't chmod it
unfortunately. As for my hoster, they're called NEXTwebhosting.
Thanks,
Nick
-Original Message-
From: John Day [mailto:[EMAIL PROTECTED]]
Sent: June 24, 2002 11:52 AM
To: DBI-Users
Subject: Re: need execute
Muchas gracias de todas maneras, si sabes algo por favor te le
agradeceré...
Muy atentamente,
Germán Marambio Vargas
PARLEY,JON
On Mon, 2002-06-17 at 10:00, Jeff Boes wrote:
We are experiencing a fairly predictable lock-up in the overnight VACUUM
ANALYZE maintenance script. The VACUUM gets to the pg_class table and
then stops, obviously waiting for something else to give up control of
the table. The VACUUM script
I did not know what 'perlcc' was and so had to read a bit about it.
Given that your scenario is OK with 'perl', there is no need to question
your installation of DBI and DBD-Oracle modules.
Instead, the focus must be on perlcc and how it might have different
requirements than perl.
I searched
unixODBC isn't usually installed in /usr/bin. It's usually in /usr/local.
I'm guessing that the output of Makefile.PL will help, but it could be that
you have remnants of udbc in there which could be causing the problem.
Save the output of Makefile.PL and forward it to me (and please copy
[EMAIL
Are you certain that you have the correct path to the perl executable?
Try changing your shebang line to:
#!perl
and see if they are then executable.
On Mon, 2002-06-24 at 11:52, John Day wrote:
1.. Have you made the scripts executable? by using CHMOD 755 or something similar.
You can often
It was written --- AUTHORS DBI by Tim Bunce. This
pod text by Tim Bunce, J. Douglas Dunlop, Jonathan
Leffler and others. Perl by Larry Wall and the
perl5-porters. ---
Thank you.
BTW, I have no intent to bother the author directly
with my questions; I know that is what this list is
for.
All
Jeff,
I think there are two questions here,
1.. What version of PERL is installed
2.. What web server is being used? Apache? IIS? or something else?
normally NT/W2K does not even read the shebang, but the file extension .pl is
registered to the perl executable and so if the script is invoked
Looks like you forgot to add the { Columns={} } part ...
-Original Message-
From: Randall Perry [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 5:03 PM
To: Tim Bunce
Cc: [EMAIL PROTECTED]
Subject: Re: Upgrade to 1.27 causes script failure
Ok, here's text from
Hello
i am new to the Unix and Perl both.
I got a script to write which connects to the database.
how should i proceed further to get started. I am aware of coding, database sql's all
basic things, need to know how to do in Perl on Unix.
Thanks
Ajay
=
A man is not finished when he is
Actually, on the hoster's website, it says that to run Perl scripts on their
server, you don't need to include a shebang line. They do, though, give the
path to Perl. I've tried both (their shebang line and no shebang line), and
neither work. I gave your suggestion of #!perl a try and it also
Doesn't there have to be an entry in the mime type to specify that .pl is executable.
All my scripts are .cgi.
-Original Message-
From: Nick Hoffman [HWA-Inc] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 2:21 PM
To: DBI-Users
Subject: RE: need execute perms?
Actually, on
Do they mention what extention your script must have? .cgi .pl and where it
is supposed to be placed in order to be executable?
Anton
-Original Message-
From: Nick Hoffman [HWA-Inc] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 11:21 AM
To: DBI-Users
Subject: RE: need execute
Using:
perl 5.6.1,
DBI 1.2.7,
DBD::Oracle 1.12
sgi_n32_oracle_client_toolkit
demo_n32.mk -- http://misdev.fnal.gov/~dbox/n32/
I was able to finally build DBD::Oracle after installing the client
toolkit and issuing this make command: perl Makefile.PL -p -m
demo_n32.mk Generic tests pass, however,
Has anyone been able to get the DBI architecture running on a Sharp Zaurus
Linux PDA? I don't own one, and haven't tried... but it could be a very
interesting and powerful platform if DBI were available for it. I'm in
the wings contemplating purchases...
-Rick
Rick Osterberg wrote:
Has anyone been able to get the DBI architecture running on a Sharp Zaurus
Linux PDA? I don't own one, and haven't tried... but it could be a very
interesting and powerful platform if DBI were available for it. I'm in
the wings contemplating purchases...
And while
Ajay Kumar wrote:
Hello
i am new to the Unix and Perl both.
I got a script to write which connects to the database.
how should i proceed further to get started. I am aware of coding,
database sql's all basic things, need to know how to do in Perl on
Unix.
First you'll have to learn
All,
My Environment is...
NT 4.0
MS SQL 6.5
ActivePerl v5.6.1
I am trying to run a select statement but one of the fields that I'm trying
to get is a Text datatype.
If I remove that field from my select statement everything works fine.
the error message I get is...
DBD::ODBC::db
There is a quick beginner's class at http://www.cgi101.com Click on
Learn CGI at the top of the page and you can go through some
tutorials.
To learn MySQL, go to www.MySQL.org. Check out the Documentation
section, this also contains tutorials and a background of MySQL.
I found them both very
On Mon, Jun 24, 2002 at 05:02:48PM -0400, Rick Osterberg wrote:
Has anyone been able to get the DBI architecture running on a Sharp Zaurus
Linux PDA? I don't own one, and haven't tried... but it could be a very
interesting and powerful platform if DBI were available for it. I'm in
the wings
I have cron script that runs fine on a bsd machine, but returns this output
on the linux machine.
i have version 1.21 on the linux machine.
DBD::Oracle::db do failed: ORA-0: normal, successful completion (DBD
SUCCESS_WITH_INFO: OCIStmtExecute) at
On Mon, Jun 24, 2002 at 10:10:52AM -0400, John Day wrote:
And it wouldn't happen to be Tim Bunce would it?
Aparrently.
Oh, and some fellow by the name of Alligator Descartes??
That would be the Programming the Perl DBI book - which we co-authored.
Alligator didn't write the DBI module -
On Mon, Jun 24, 2002 at 04:21:16PM -0400, [EMAIL PROTECTED] wrote:
Using:
perl 5.6.1,
DBI 1.2.7,
DBD::Oracle 1.12
sgi_n32_oracle_client_toolkit
demo_n32.mk -- http://misdev.fnal.gov/~dbox/n32/
I was able to finally build DBD::Oracle after installing the client
toolkit and issuing this
I've just spent the last 15 minutes looking at CPAN for a module to
query a MS Access database.
Which modules do I need to download?
Can someone throw me a hint? :)
DBD::ODBC.
John
[EMAIL PROTECTED]
On Mon, 24 Jun 2002 16:22:38 -0700, Erick Nelson wrote:
I've just spent the last 15 minutes looking at CPAN for a module to
query a MS Access database.
Which modules do I need to download?
You need DBD::ODBC.
Can someone throw me a hint? :)
Well: first create a DSN for the database using the
jingyuan wang wrote:
Yes, I have substitued -fPIC. but i have another error:
gcc -c -xO3 -xdepend -DVERSION=\1.18\ -DXS_VERSION=\1.18\ -fPIC
-I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c
gcc: language depend not recognized
gcc: Perl.c: linker input file unused
38 matches
Mail list logo