sub select_url($current_time) {
my $dbh = DBI->connect("DBI:mysql:database=saint;host=localhost","user","password",
{'RaiseError' => 1});
my $select_query = "SELECT url_id, chk_freq, url_timeout, UNIX_TIMESTAMP(lc_epoch)
FROM monitor_check
WHERE (
Hi Paul, you wrote:
> Did all the prerequisites and every thing went fine until
> installing the DB2
> module.
> It's barking about "No such file or directory" for three
> objects on the
> make command.
Maybe you missed a prerequisite, perhaps The files it is complaining
about are part o
Did all the prerequisites and every thing went fine until installing the DB2
module.
It's barking about "No such file or directory" for three objects on the
make command.
Configuring DBD::DB2...
Remember to actually read the README and CAVEATS files!
Using DB2 in "/db2/SI1"
System: perl5.006001
Hi, Tim:
My name is Pei and I work for the comany Lightbridge in Fremont, California.
I have problems to install DBI and DBD::Oracle modules to my solaris machines. On
those machines, we don't have C/C++ development environment setup, no compilers at all
on those machines. Everythin we do is o
Title: [blib/arch/auto/DBI/DBI.so] Error 1
I am having trouble installing DBI-1.201. The following is a screen print of the problem P-L-E-A-S-E HELP.
Thanks!
bash-2.03$ perl Makefile.PL
*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use t
If the tables were exactly the same this will work You may need to tweak for
your purpose.
$sdbh ## is your sybase database handle.
$odbh ## is your oracle database handle.
$ssth = $sdbh->prepare("select * from table_name");
$ssth->execute();
$osth = $odbh->prepare("insert into table_name (
Well probably that is why. Here is where you get it from...
http://technet.oracle.com/software/content.html
You have to sign up with them to in order to download. All you need is the
client install, once you get there, 8i or what ever your db is.
You can also just use DBD::ODBC and just set u
Ok Sterin, thanks a lot. But about the sentence:
Remember you must also have the Oracle client libs installed on your pc in
order for this to work, and ORACLE_HOME must be set.
What are these Oracle client libs? Where do I find them?
Really, I try to rum my script, and now other error occurred
You can install it using the ppm utility, like this...
In command prompt...
ppm install http://www.xmlproj.com/PPM/DBI-1_20.ppd
and then after it installs DBI...
ppm install http://www.xmlproj.com/PPM/DBD-Oracle-1_12.ppd
I don't have the latest version 1.21 of DBI up, but this one is just a
v
Yes, DBD::Oracle :-)
It will work.
Ilya
-Original Message-
From: NEWMAN, SCOTT (SBIS)
To: [EMAIL PROTECTED]
Sent: 4/5/02 11:13 AM
Subject: Question about Perl DBI DBD's
Any DBD for Oracle 9i
Scott Newman
SBC Internet Services, Network
Hi, I am Adriano, a System Specialist of a Brazilian Company.
I have to learn Perl and how to connect Perl with Oracle Database.
I am working with a Windows 2000, I've installed the ActivePerl and a
web-server, the OmniHTTPD.
It's everything ok with trivials cgi scripts, i.e., when I send data by
Sauer (ext_evosoft) Martin writes:
> I'm sorry, I also found this rollback handling error and now its working for
> Oracle. But still not for DBD::Sybase!!
>
> I tried V 0.91 and V 0.94 - both the same. All servermessages get printed to
> stderr and I get an undef in the program.
> That's a
I wish to do a bulk insert into select from of all rows.
I have my connection to Oracle (source) and Sybase (destination) set up and
working.
What is the BEST and FASTEST way to do something like this:
insert into OraX select * from SybY Note: the col names are the same
and datatypes as
Any
DBD for Oracle 9i
Scott
Newman
SBC Internet
Services, Network Operations Tools Development 1701 Alma
Dr. Room 1S-141, Plano, TX 75075
phone:
214-495-2521
pager: 888-270-9719mobile:
214-478-9316
fax: 214-495-2253
Well, perhaps if you posted some code we could have a little better
chance of seeing what the problem was.
On Fri, 2002-04-05 at 06:33, Bogdan Badiu wrote:
>Hello !
>I want to use Windows 98 /2000 , perl 5.6.1 and DBI and DBD-mysql
>
Using just forks is ok, using just DBI a
From: "Zhao, David [PRDUS Non J&J]" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 17:26
Subject: retrieve column names in the result set
> How can I retrieve the column names in the result set using DBI?
It's in the fine manual. Run 'perldoc DBI' and look for the N
The server executes the script as web/www/nobody or something similar,l has
nothing to do with anonymous or your user account. You need to make sure
that the scripts are executable by everyone. In win2k you can change that
in the properties of a folder/file. You can just set it for the folder a
Hi, all.
I'm having a hard time trying to put a site on web. It
was all created using PERL (Active Perl), and an
Oracle Database. For acessing this database, i used
DBI, and DBD::Oracle.
The problem is: I don't know which are the permissions
i have to give on the server (Win NT) to the anonymous
I'm sorry if I didn't mention this but I cannot use ActivePerl because I
will be running my script in a dos environment. I have a boot disk with a
command.com and autoexec.bat and some network drivers establishing a
connection between a system and the network which contains the perl compiler
and p
Well, "Programming the Perl DBI" by Tim is a great start. Should be the
first book to get if you already have good Perl knowledge.
The DBI FAQ is also a good think to read. I'm not fully done with it yet,
but you can take a look at a draft at http://xmlproj.dyndns.org/dbi/faq.html
I would reco
Hello to all,
I want to install DBI on Solaris 2.6,
I have difficulty with the compilation because the pre installed Perl (Nortel)
(I don't have the permission to replace it by a another one) was built with a compiler
that I don't have (error : optional langage package is not
installed),
and I d
I can't recommend more and more, use ActivePerl from www.activestate.com.
It comes with lots of modules preinstalled, plus lot's of binaries are
available for install through the ppm utility, if you don't have a compiler
(Visual C++) available on your system.
Ilya
-Original Message-
From
> I have problem installing the DBI::Interbase in WIndows 2000. I have
downloaded the DBD-InterBase-0.28.4 and compiled with >nmake 1.5 but have
not happenned. Please see the attachment file and give me a consultation.
Thank you very much.
> A new DBI user.
> Nguyen Tran Quoc Vinh
Hello !
I want to use Windows 98 /2000 , perl 5.6.1 and DBI and DBD-mysql
… Using just forks is ok, using just DBI and DBD-Mysql is ok , but when
I try to combine this “concepts” … I get an Windows error … “This
program has performed an illegal operation “ and the following mess
I found the problem.
It was related due to a byte swap error on big endian machines in freetds V
0.53.
Now everything is working as expected.
Martin
> -Ursprüngliche Nachricht-
> Von: Sauer (ext_evosoft) Martin
> Gesendet am: Freitag, 5. April 2002 08:35
> An: '[EMAIL PROTECTED]'
Hi Tim
you're the greatest ... DBD was not compiled on this platform - after doing
it it works ...
Thanks a lot
Felix
PS: Also thank you VERY much for DBI and DBD-Oracle
-Ursprungliche Nachricht-
Von: Tim Bunce [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 5. April 2002 11:42
An: Cast
On Fri, Apr 05, 2002 at 07:07:11AM +0200, Castillo, Felix wrote:
> Hi Tim,
>
> the configuration is just like using the 'identified externally' feature. In
> fact you have to use this for connecting through Kerberos.
>
>'sqlplus /' for IPC connections or 'sqlplus /@sid' for remote
> connect
Hello,
This is my first post to this list. I need to be able to run PL/SQL and
oracle stored procedures using the perl DBI. I am using the DBD::Proxy
driver to connect to the oracle server on another host. I cannot get
the following simple code to work.
my $p1;
my $csr = $dbh->prepare(q{
beg
Ilya, please recomment the best books for me
Thank you very much
"Sterin, Ilya" wrote:
> Please read perldoc DBD::Oracle before starting any development with
> this module.
>
> Ilya
>
> > -Original Message-
> > From: Vu Van Toan [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, April 05, 2002
Go thru this URL, you will find an example of how to execute a stored
prcedure using perl
http://www.saturn5.com/~jwb/dbi-examples.html
Regards
Amarnath.K.Habib
Aquila TEchnologies
Bangalore
India
Vu Van Toan wrote:
> Hi All,
> How to execute a stored procedure in ORACLE using DBD::Oracle?
livepes# make install
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Writing
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ODBC/.packlist
Appending installation info to
/usr/local/lib/perl5/5.6.1/sun4-solaris/perllocal.pod
then I ran t
Hi there,
How can I retrieve the column names in the result set using DBI?
Thanks,
David
I've just installed Dos perl 5.005 from
http://www.perl.com/CPAN/ports/msdos/LMOLNAR/. I installed it to a network
drive I have mapped to z: (Z:\DELLSFTW\DIAGS\dfs\Perl to be exaclt) I have
the Z:\DELLSFTW\DIAGS\dfs\Perl\bin directory in my path and it works.
I then got the DBI module from http
I have problem installing the DBI::Interbase
in WIndows 2000. I have downloaded the DBD-InterBase-0.28.4 and compiled with
nmake 1.5 but have not happenned. Please see the attachment file and give me a
consultation. Thank you very much.
A new DBI
user.
Nguyen Tran Quoc
Vinh
34 matches
Mail list logo
