Re: PERL - DBI MODULE

2020-06-04 Thread Darren Duncan
team                Could you please let me know how to use the DBI module without a DBD module installed ? . can you suggest any alternative. -- Regards, Pramod M V

RE: [EXTERNAL] PERL - DBI MODULE

2020-06-04 Thread Fennell, Brian
/ From: Pramod Mv Sent: Wednesday, June 3, 2020 12:35 AM To: dbi-users@perl.org Subject: [EXTERNAL] PERL - DBI MODULE Hello team Could you please let me know how to use the DBI module without a DBD module installed ? . can you suggest any alternative. -- Regards, Pramod M V

RE: [EXTERNAL] PERL - DBI MODULE

2020-06-04 Thread Fennell, Brian
For further reading: https://metacpan.org/pod/DBI::DBD These links may help as well: (You can compare perl to other programing languages you may already know) https://rosettacode.org/wiki/Table_creation https://rosettacode.org/wiki/Table_creation/Postal_addresses https://rosettacode.org/wiki/SQ

Re: PERL - DBI MODULE

2020-06-04 Thread Jonathan Leffler
On Thu, Jun 4, 2020 at 13:32 Pramod Mv wrote: > Could you please let me know how to use the DBI module without a DBD > module installed ? . can you suggest any alternative. > For most practical purposes, you can't use the DBI without a DBD module — it's reason for exist

PERL - DBI MODULE

2020-06-04 Thread Pramod Mv
Hello team Could you please let me know how to use the DBI module without a DBD module installed ? . can you suggest any alternative. -- Regards, Pramod M V

RE: DBI Module installtion

2013-05-08 Thread Anoop Kumar Paramesweran
p.ku...@nawras.om | m +96895103659 twitter/nawras_oman | facebook/nawras -Original Message- From: Martin J. Evans [mailto:boh...@ntlworld.com] Sent: Wednesday, May 01, 2013 11:07 PM To: dbi-users@perl.org Cc: Anoop Kumar Paramesweran Subject: Re: DBI Module installtion On 29/04/2013 14:5

RE: DBI Module installtion

2013-05-05 Thread Anoop Kumar Paramesweran
m | m +96895103659 twitter/nawras_oman | facebook/nawras -Original Message- From: Martin J. Evans [mailto:boh...@ntlworld.com] Sent: Wednesday, May 01, 2013 11:07 PM To: dbi-users@perl.org Cc: Anoop Kumar Paramesweran Subject: Re: DBI Module installtion On 29/04/2013 14:55, Anoop

Re: DBI Module installtion

2013-05-01 Thread John R Pierce
On 4/29/2013 6:55 AM, Anoop Kumar Paramesweran wrote: Hi Support, I am receiving below error while installing (make ) DBI module in my AIX box. As I am new to Perl installations could you please help me to solve this.. xlc_r -q32 -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem

Re: DBI Module installtion

2013-05-01 Thread Martin J. Evans
On 29/04/2013 14:55, Anoop Kumar Paramesweran wrote: Hi Support, I am receiving below error while installing (make ) DBI module in my AIX box. As I am new to Perl installations could you please help me to solve this.. xlc_r -q32 -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1

DBI Module installtion

2013-05-01 Thread Anoop Kumar Paramesweran
Hi Support, I am receiving below error while installing (make ) DBI module in my AIX box. As I am new to Perl installations could you please help me to solve this.. xlc_r -q32 -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT

Re: regarding DBI module not working windows 2010

2012-01-15 Thread Mr. Puneet Kishor
> Op zo 15 januari 2012 om 23:57:38 (+0530) schreef > sridhar.dachepe...@gmail.com (Sridhar Dachepelly): >> Hello, >> >> I am trying to use DBI module in Windows 2010 server, i have installed perl >> 5,14 version (64-BIT). DBI module is not working and giving er

Re: regarding DBI module not working windows 2010

2012-01-15 Thread Reinier Post
Op zo 15 januari 2012 om 23:57:38 (+0530) schreef sridhar.dachepe...@gmail.com (Sridhar Dachepelly): > Hello, > > I am trying to use DBI module in Windows 2010 server, i have installed perl > 5,14 version (64-BIT). DBI module is not working and giving errors. > Could you pleas

Re: regarding DBI module not working windows 2010

2012-01-08 Thread Alexander Foken
Hi, On 08.01.2012 19:27, Sridhar Dachepelly wrote: Hello, I am trying to use DBI module in Windows 2010 server, i have installed perl 5,14 version (64-BIT). DBI module is not working and giving errors. Could you please look into the below errors and suggest what we can do for the same. C

regarding DBI module not working windows 2010

2012-01-08 Thread Sridhar Dachepelly
Hello, I am trying to use DBI module in Windows 2010 server, i have installed perl 5,14 version (64-BIT). DBI module is not working and giving errors. Could you please look into the below errors and suggest what we can do for the same. C:\intranet\integration\cards>perl label2.pl Use of :uni

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Bruce Johnson
On Sep 21, 2011, at 8:55 AM, Curtis Leach wrote: > Here's a way that might speed things up for you considerably by > eliminating a DB hit. > >> 4. Perl script from (3) constantly reads in the /var/log files using >> the Tail module. It does the following: >> >> a. When a connection is opene

RE: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Curtis Leach
x27;t remember how to do this off hand. Curtis -Original Message- From: Roode, Eric [mailto:ero...@barrack.com] Sent: Wednesday, September 21, 2011 8:38 AM To: dbi-users@perl.org Cc: Brandon Phelps Subject: RE: Tail Module + DBI Module, can\'t keep up! On Wednesday, Septe

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread tiger peng
ilar to Oracle's "insert all", but you can write a (stored) procedure do all the DML, cannot you? From: Brandon Phelps To: tiger peng Cc: Tim Bunce ; John Scoles ; "dbi-users@perl.org" Sent: Wednesday, September 21, 2011 9:49 AM Sub

RE: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Roode, Eric
On Wednesday, September 21, 2011 10:04 AM, Brandon Phelps [mailto:bphe...@gls.com] wrote: > Subject: Re: Tail Module + DBI Module, can\'t keep up! [...] > 4. Perl script from (3) constantly reads in the /var/log files using > the Tail module. It does the following: > >a.

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Brandon Phelps
"dbi-users@perl.org" *Sent:* Wednesday, September 21, 2011 9:04 AM *Subject:* Re: Tail Module + DBI Module, can\'t keep up! Thanks for the responses. I would love to be able to output the data to a flat file or something and do bulk inserts daily, however this isn't really

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Brandon Phelps
Try to fix this two issues. If it is still too slow, we can do more tuning. From: Brandon Phelps To: tiger peng Cc: Tim Bunce; John Scoles; "dbi-users@perl.org" Sent: Wednesday, September 21, 2011 9:04 AM Subject: Re: Tail Module + DBI Module, can\&#x

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread tiger peng
more tuning. From: Brandon Phelps To: tiger peng Cc: Tim Bunce ; John Scoles ; "dbi-users@perl.org" Sent: Wednesday, September 21, 2011 9:04 AM Subject: Re: Tail Module + DBI Module, can\'t keep up! Thanks for the responses. I would love to be abl

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-21 Thread Brandon Phelps
ent:* Friday, September 16, 2011 10:13 AM *Subject:* Re: Tail Module + DBI Module, can\'t keep up! Tim, I bet at that time your MySQL did not support partition. Now, with partition management available, the jobs should be easy. Using a small partition, called hot partition in DW/ETL field, to

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-16 Thread tiger peng
.org" Sent: Friday, September 16, 2011 10:13 AM Subject: Re: Tail Module + DBI Module, can\'t keep up! Tim, I bet at that time your MySQL did not support partition. Now, with partition management available, the jobs should be easy. Using a small partition, called hot partition in DW/

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-16 Thread tiger peng
; and when the DB is back,  bulk-load tool can be used to catch up the load quickly. Tiger From: Tim Bunce To: John Scoles Cc: tigerpeng2...@yahoo.com; bphe...@gls.com; dbi-users@perl.org Sent: Friday, September 16, 2011 4:20 AM Subject: Re: Tail Module + DBI

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-16 Thread Tim Bunce
This is all fine advice for performance tuning DBI app and worth doing. But there's always a limit to what can be achieved on the client. So it's worth exploring what can be done on the server side, beyond standard tuning practices. I wrote a high volume log insertion app using mysql many years ag

RE: Tail Module + DBI Module, can\'t keep up!

2011-09-15 Thread John Scoles
> Date: Thu, 15 Sep 2011 09:26:41 -0700 > From: tigerpeng2...@yahoo.com > Subject: Re: Tail Module + DBI Module, can\'t keep up! > To: bphe...@gls.com > CC: dbi-users@perl.org > > Separate the process into two steps and figure out which step should be fixed >

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-15 Thread tiger peng
Separate the process into two steps and figure out which step should be fixed first. 1. Parse the log with Tail and dump the data to plain file. 2. Load the plain file with DBI (are you using batch insert?)

RE: Tail Module + DBI Module, can't keep up!

2011-09-15 Thread Roode, Eric
dealing with lines from Sep 14 at 8am. This is obviously due to the > fact that the Tail module, and more likely the DBI module simply > can't INSERT/UPDATE the database as fast as the logs are coming in. Have you benchmarked/profiled your program yet? You can't tell what parts

Re: Tail Module + DBI Module, can't keep up!

2011-09-15 Thread ericbambach1
and Tools 2500 Lake Cook Road, Riverwoods IL 60015 P: 224.405.2896 ericbamba...@discover.com Brandon Phelps 09/15/2011 08:46 AM To cc Subject Tail Module + DBI Module, can't keep up! Hello! I have a bit of a problem with a script and am hoping someone will have an idea as to ho

Re: Tail Module + DBI Module, can't keep up!

2011-09-15 Thread Clive Eisen
On 15/09/2011 14:43, Brandon Phelps wrote: Has anyone ever dealt with an issue like this and have any idea how I might rework the script and/or application to avoid this delay, which will obviously get worse and worse as time goes on? IMHO it's much more likely to be mysqld itself get http://

Tail Module + DBI Module, can't keep up!

2011-09-15 Thread Brandon Phelps
rting into a mysql database using the DBI module. My problem here is that the logs are coming in extremely fast and while the script does work, it progressively gets further and further behind. It's currently Sep 15, 10AM yet the script is still dealing with lines from Sep 14 at 8am. This is

Re: How to connect DBI module in my local server

2010-10-25 Thread Robert Roggenbuck
Hi, Am 23.10.2010 07:22, schrieb yugandhar sompalle: Hi, I have query .I wrote simple program in perl it is simple program to connet local DBI server. What is a "DBI server"? Please provide me procedure how to do ?. Please have a look at http://search.cpan.org/~timb/DBI/DBI.pm especiall

How to connect DBI module in my local server

2010-10-23 Thread yugandhar sompalle
Hi, I have query .I wrote simple program in perl it is simple program to connet local DBI server. Please provide me procedure how to do ?. Regards, Yugandhar

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Owen
> Hi Team > > Need Your help ASAP.I am getting error while installing the PERL DBI > module,as mentioned below > === > [r...@dba /]# cd /usr/bin/ > [r...@dba bin]# cd DBI-1.611 > [r...@dba DBI-1.611]# perl Makefile.PL > Can't locate Cwd.pm in @INC

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread John R Pierce
On 07/08/10 1:36 AM, Clive Eisen wrote: On 08/07/2010 11:18, Martin J. Evans wrote: Scripting Giri wrote: Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Clive Eisen
On 08/07/2010 11:18, Martin J. Evans wrote: Scripting Giri wrote: Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba DBI-1.611]# perl Makefile.PL Can't l

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Martin J. Evans
Scripting Giri wrote: > Hi Team > > Need Your help ASAP.I am getting error while installing the PERL DBI > module,as mentioned below > === > [r...@dba /]# cd /usr/bin/ > [r...@dba bin]# cd DBI-1.611 > [r...@dba DBI-1.611]# perl Makefile.PL > Can't loca

error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Scripting Giri
Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba DBI-1.611]# perl Makefile.PL Can't locate Cwd.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8

Re: DBI module most important module in Perl 2010 survey

2010-06-22 Thread John Scoles
Must be an IE thing seems to open with Firefox/ Interesting stuff. When you look at the DBI I think it is understated as there are a number of mods on that list that require DBI. My fab is the very few who have taken formal 'Perl' training, me thinks it is time 'perl' is put on the curricu

Re: DBI module most important module in Perl 2010 survey

2010-06-22 Thread Martin Evans
John Scoles wrote: > Martin Evans wrote: >> http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html >> >> >> Look for the presentation slides. >> >> Martin > Looks like the link to his slides is broken or at least when I try and > get

Re: DBI module most important module in Perl 2010 survey

2010-06-22 Thread John D Groenveld
In message <4c20b25e.3030...@pythian.com>, John Scoles writes: >Looks like the link to his slides is broken or at least when I try and >get it I get a corrupt file error! http://github.com/singingfish/Data-PerlSurvey-2010/raw/master/report/perl_survey.pdf> John groenv...@acm.org

Re: DBI module most important module in Perl 2010 survey

2010-06-22 Thread John Scoles
Martin Evans wrote: http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html Look for the presentation slides. Martin Looks like the link to his slides is broken or at least when I try and get it I get a corrupt file error!

DBI module most important module in Perl 2010 survey

2010-06-21 Thread Martin Evans
http://blogs.perl.org/users/holy_zarquons_singing_fish/2010/06/perl-survey---initial-data-analysis-and-presentation.html Look for the presentation slides. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: error while installing DBI module...help required

2010-05-20 Thread John R Pierce
Victor Churchill wrote: The line you highlighted tells you that the make command failed because it could not find a C compiler (cc: not found). This could be because it's not present on your system, or because it can't be found in your $PATH. The C compiler exists because it is detailed lower dow

Re: error while installing DBI module...help required

2010-05-20 Thread Victor Churchill
The line you highlighted tells you that the make command failed because it could not find a C compiler (cc: not found). This could be because it's not present on your system, or because it can't be found in your $PATH. The C compiler exists because it is detailed lower down in your listing. So you

Re: error while installing DBI module...help required

2010-05-20 Thread Alexander Foken
Your system lacks a C compiler, "cc". Install the relevant system packages and try again. Alexander ninu.clee...@relianceada.com wrote: 2) output of $* make* cc -c-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff-DVERSION=\"1.609\" -DXS_VERSION=\

error while installing DBI module...help required

2010-05-20 Thread Ninu . Cleetus
1) output of $perl Makefile.PL Creating test wrappers for DBI::PurePerl: t/zvp_01basics.t t/zvp_02dbidrv.t t/zvp_03handle.t t/zvp_04mods.t t/zvp_05concathash.t t/zvp_06attrs.t t/zvp_07kids.t t/zvp_08keeperr.t t/zvp_09trace.t t/zvp_10examp.t t/zvp_11fetch.t t/zvp_12quote.t t/zvp_13taint.t t/zvp_14ut

Re: Help with selectdb in dbi module

2010-05-18 Thread mani kandan
I am using DBD::ODBC.I will try out with DMO or SMO.I am using SQL server 05.I too after many trails got that selectdb() wont work for me with sql server.I let all to know after trying with DMO. Regards, Manikandan.G On Mon, May 17, 2010 at 4:50 PM, John Scoles wrote: > If you are using SQLServ

Re: Help with selectdb in dbi module

2010-05-17 Thread John Scoles
If you are using SQLServer than I do not think 'selectdb()' is going to work for you. You are either using DBD::ODBC or DBD::ADO neither of which have selectdb in them which one is it?? If there is a way with ADO to get a list of all the tables in a DB but I don't remember. I think you h

Re: Help with selectdb in dbi module

2010-05-17 Thread Martin Evans
mani kandan wrote: > Hi, > >As Alex asked me why I not giving the name of the database in the > connection string, the script I writing is basically a testing scripting.It > will connect to the database engine then iterate over all the database > available.If the database of my interest is ava

Re: Help with selectdb in dbi module

2010-05-17 Thread mani kandan
Hi, As Alex asked me why I not giving the name of the database in the connection string, the script I writing is basically a testing scripting.It will connect to the database engine then iterate over all the database available.If the database of my interest is available I will connect to it.Els

Re: Help with selectdb in dbi module

2010-05-14 Thread John Scoles
Alexander Foken wrote: On 13.05.2010 16:58, mani kandan wrote: Hi Tim, I wrote a small script that connect to SQL Server engine.I don't want to give the name of the databse in the connection string. Why not? I want to select a db on the fly only if it present. When WHAT is present? I t

Re: Help with selectdb in dbi module

2010-05-14 Thread Alexander Foken
On 13.05.2010 16:58, mani kandan wrote: Hi Tim, I wrote a small script that connect to SQL Server engine.I don't want to give the name of the databse in the connection string. Why not? I want to select a db on the fly only if it present. When WHAT is present? I tried $dbh->selectdb($datab

Help with selectdb in dbi module

2010-05-14 Thread mani kandan
Hi Tim, I wrote a small script that connect to SQL Server engine.I don't want to give the name of the databse in the connection string.I want to select a db on the fly only if it present.I tried $dbh->selectdb($databasename) but this failed throwing error can't able to locate object method "selec

Re: Official DBI module for Solaris Box

2010-04-14 Thread Martin Evans
etting the right @INC at run time: >>>>> >>>>> OPERL_LIB=$ORACLE_HOME/perl/lib >>>>> $ORACLE_HOME/perl/bin/perl -I$OPERL_LIB/5.8.3 >>>>> -I$OPERL_LIB/site_perl/5.8.3/sun4-solaris-thread-multi foo.pl >>>>> >>>>>

Re: Official DBI module for Solaris Box

2010-04-14 Thread Parag Kalra
E/perl/bin/perl -I$OPERL_LIB/5.8.3 > >>> -I$OPERL_LIB/site_perl/5.8.3/sun4-solaris-thread-multi foo.pl > >>> > >>> Your Oracle-installed perl may vary from the above, but this is working > >>> with 10.2.0.4 and includes, of course DBI and DBD::Oracle.

Re: Official DBI module for Solaris Box

2010-04-09 Thread Martin Evans
LIB/site_perl/5.8.3/sun4-solaris-thread-multi foo.pl >>> >>> Your Oracle-installed perl may vary from the above, but this is working >>> with 10.2.0.4 and includes, of course DBI and DBD::Oracle. I'm not sure if >>> they install perl with the Oracle Clien

Re: Official DBI module for Solaris Box

2010-04-08 Thread Parag Kalra
-I$OPERL_LIB/5.8.3 >>>> -I$OPERL_LIB/site_perl/5.8.3/sun4-solaris-thread-multi foo.pl >>>> >>>> Your Oracle-installed perl may vary from the above, but this is working >>>> with 10.2.0.4 and includes, of course DBI and DBD::Oracle. I'm not sure i

Re: Official DBI module for Solaris Box

2010-04-08 Thread Parag Kalra
BI and DBD::Oracle. I'm not sure if >>> they install perl with the Oracle Client, but it is installed in the DB >>> server, so it can be used... >>> >>> -Original Message- >>> From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] >

Re: Official DBI module for Solaris Box

2010-04-08 Thread Parag Kalra
cle Client, but it is installed in the DB >> server, so it can be used... >> >> -Original Message----- >> From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] >> Sent: Tuesday, March 23, 2010 6:42 PM >> To: Parag Kalra >> Cc: DBI Users Mailing Li

RE: Official DBI module for Solaris Box

2010-03-25 Thread Jeff Urlwin
ed... -Original Message- From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] Sent: Tuesday, March 23, 2010 6:42 PM To: Parag Kalra Cc: DBI Users Mailing List Subject: Re: Official DBI module for Solaris Box On Tue, Mar 23, 2010 at 2:49 PM, Parag Kalra wrote: > Surprised to see no

Re: Official DBI module for Solaris Box

2010-03-25 Thread Parag Kalra
d in the DB > server, so it can be used... > > -Original Message- > From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] > Sent: Tuesday, March 23, 2010 6:42 PM > To: Parag Kalra > Cc: DBI Users Mailing List > Subject: Re: Official DBI module for Solaris Box >

Re: Official DBI module for Solaris Box

2010-03-23 Thread Jonathan Leffler
h Perl or > is it like on Solaris we always explicitly need to install DBI module > externally. DBI is not distributed as standard on Solaris. > If the customer has valid support contract, can Sun Support help to get DBI > installed? Unlikely. > On Sat, Mar 20, 2010 at 7:31 PM, Pa

Re: Official DBI module for Solaris Box

2010-03-23 Thread Parag Kalra
Surprised to see no response yet. :-) Anyways few more questions - For which version of Perl on Solaris, does DBI comes integrated with Perl or is it like on Solaris we always explicitly need to install DBI module externally. If the customer has valid support contract, can Sun Support help to

Official DBI module for Solaris Box

2010-03-20 Thread Parag Kalra
(it has Perl installed - 5.8.4). However that Solaris machine doesn't have DBI module as a result of which I can't use my framework. But it has Oracle client installed using which (sqlplus, sqlldr etc) I am able to connect to the Oracle DB Server (located remotely) The best solution her

Re: Perl 5.6.1 supports DBI module

2010-03-19 Thread Peter J. Holzer
On 2010-03-18 16:30:11 -0500, Michael Nhan wrote: > DBI-1.605 was the last version not to require perl 5.8. Even though the > Readme doesn't state it, version 1.606 and newer requires 5.8.10 in the ITYM 5.8.1 hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Lud

Re: Perl 5.6.1 supports DBI module

2010-03-18 Thread Michael Nhan
chael On Thu, 18 Mar 2010, Peram, Sudhakara wrote: Date: Thu, 18 Mar 2010 23:32:26 +0800 From: "Peram, Sudhakara" To: dbi-users@perl.org Subject: Perl 5.6.1 supports DBI module Hello All I am working on Perl 5.6.1 version for my web application. I want to know whether perl5.6.1 s

Re: Perl 5.6.1 supports DBI module

2010-03-18 Thread Jonathan Leffler
On Thu, Mar 18, 2010 at 8:32 AM, Peram, Sudhakara wrote: > I am working on Perl 5.6.1 version for my web application. Why? Why not 5.6.2, 5.8.8 or 5.8.9, or even (bravado) 5.10.1? > I want to > know whether perl5.6.1 supports the DBI module or not, if it supports > the what is th

Perl 5.6.1 supports DBI module

2010-03-18 Thread Peram, Sudhakara
Hello All I am working on Perl 5.6.1 version for my web application. I want to know whether perl5.6.1 supports the DBI module or not, if it supports the what is the version of DBI module. Please let me know the answers. Thanks in advance. Regards Sudhakara Reddy Peram Desk

Error installing DBI Module for Perl 5.10

2009-06-08 Thread Cristian Aranda
Hello, I keep getting the following error when installing DBI Module (1.38) on Perl 5.10: install_driver(ODBC) failed: Can't locate loadable object for module DBD::ODBC i n @INC (@INC contains: C:/Progra~1/Perl510/site/lib C:/Progra~1/Perl510/lib .) Can anyone suggest any help with this?

Re: Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-12 Thread Mike Nhan
hoststring.10G = (DESCRIPTION= (LOAD_BALANCE=yes) (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.123)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.124)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=) ) ) Currently, using the DBI module I am able to connect to these servers

RE: Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-09 Thread Martin Gainty
party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Fri, 9 Jan 2009 14:31:28 -0800 > From: write2sr...@yahoo.com > Subject: Oracle::DBI module - Issues in connecting to Oracle 10G > To: dbi-users@perl.or

Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-09 Thread Srinu
Hello, Can someone help with me a DBI issue I'm having in connecting to an Oracle 10g DB server? We have production scripts that loads data into DB (oracle9i) using DBI module. We recently migrated our database to oracle 10g. Our DBA has implemented load balancing on this 10g server and

Re: Error in installing perl DBI Module on sun 0s box

2008-11-15 Thread Jonathan Leffler
On Sat, Nov 15, 2008 at 1:22 AM, Sureshkumar M (HCL Financial Services) < [EMAIL PROTECTED]> wrote: > When I tried to install the Perl DBI module in my machine (sun OS > 5.8) I am getting below error messages ,Could you please some one help > me on this... > > C)/home/XYZ/TE

Re: Error in installing perl DBI Module on sun 0s box

2008-11-15 Thread Ron Savage
Hi > Perl 5.008001 required--this is only version 5.00503, stopped at > Makefile.PL line 10. Upgrade Perl, just as the message suggests. But don't install V 5.8. Go straight to V 5.10. -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html

Error in installing perl DBI Module on sun 0s box

2008-11-15 Thread Sureshkumar M (HCL Financial Services)
Hi ALL, When I tried to install the Perl DBI module in my machine (sun OS 5.8) I am getting below error messages ,Could you please some one help me on this... C)/home/XYZ/TEST/suresh/modules/DBI/DBI-1.607$ perl Makefile.PL Perl 5.008001 required--this is only version 5.00503

Re: not able to install DBI Module

2007-11-02 Thread Jonathan Leffler
On 11/2/07, Sreedhar Gundreddy <[EMAIL PROTECTED]> wrote: > > > I am not able to install Perl DBI module > > #perl Makefile.PL has displayed this output > > [...] > > Writing Makefile for DBI > > # make output > > gcc -c -D_POSIX_PTHREAD_SEMANT

not able to install DBI Module

2007-11-02 Thread Sreedhar Gundreddy
Hi I am not able to install Perl DBI module #perl Makefile.PL has displayed this output *** You are using a perl configured with threading enabled. *** You should be aware that using multiple threads is *** not recommended for production environments. *** Note: The optional PlRPC

Re: Clarification on DBI module

2007-05-24 Thread ramesh thangamani
nd execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From:ramesh thangamani To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 8:10AM Sub

Re: Clarification on DBI module

2007-05-14 Thread ramesh thangamani
is working correctly as it is written by the way. You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From:ramesh thangamani To: John Scoles ; dbi-users@pe

Re: Clarification on DBI module

2007-05-10 Thread Tim Bunce
On Thu, May 10, 2007 at 02:50:10PM +0200, Peter J. Holzer wrote: > On 2007-05-10 07:50:16 -0400, Jeffrey Seger wrote: > > On your execution without a bound value, are you actually looking for rows > > where the empno column is null? If so, try this: > > > > instead of > > my @bind1 = (); > > try:

Re: Clarification on DBI module

2007-05-10 Thread ramesh thangamani
get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From:ramesh thangamani To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED] Sent: Wednesday, May 09

Re: Clarification on DBI module

2007-05-10 Thread Peter J. Holzer
On 2007-05-10 07:50:16 -0400, Jeffrey Seger wrote: > On your execution without a bound value, are you actually looking for rows > where the empno column is null? If so, try this: > > instead of > my @bind1 = (); > try: > my @bind1 = (undef); > > Otherwise, what exactly are you looking for? As I

Re: Clarification on DBI module

2007-05-10 Thread Jeffrey Seger
orking correctly as it is written by the way. You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From:ramesh thangamani To: John Scoles ; dbi-users@perl.org

Re: Clarification on DBI module

2007-05-10 Thread ramesh thangamani
lts for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From:ramesh thangamani To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 8:10

Re: Clarification on DBI module

2007-05-10 Thread ramesh thangamani
Thanks for your comments. May be i guess before calling execute i should check if the query has bind variables and whether they are passed otherwise i should error out. Jonathan Leffler <[EMAIL PROTECTED]> wrote: On 5/9/07, ramesh thangamani <[EMAIL PROTECTED]> wrote: Can you please

Re: debugging a DBI module

2007-05-10 Thread Tim Bunce
On Wed, May 09, 2007 at 04:17:04PM -0700, Justin Zygmont wrote: > hi, i'm trying to debug a problem with a DBD module, it seems the make > test fails, and I cannot see enough useful error information to > determine the problem. Does anyone know what is usually done in a case > like this? I am

debugging a DBI module

2007-05-10 Thread Justin Zygmont
hi, i'm trying to debug a problem with a DBD module, it seems the make test fails, and I cannot see enough useful error information to determine the problem. Does anyone know what is usually done in a case like this? I am less familiar with the debugging process in perl. Thanks,

Re: Clarification on DBI module

2007-05-09 Thread ramesh thangamani
uot; To: ; Sent: Wednesday, May 09, 2007 3:09 AM Subject: Clarification on DBI module > Hi, > >Can you please clarify my doubts regarding DBI perl module used for > database connection. > > In my environment I am using single module to prepare and execute the sql > q

Re: Clarification on DBI module

2007-05-09 Thread Jonathan Leffler
On 5/9/07, ramesh thangamani <[EMAIL PROTECTED]> wrote: Can you please clarify my doubts regarding DBI perl module used for database connection. In my environment I am using single module to prepare and execute the sql queries. The sql query can have bind variables or they may not have. In

Re: Clarification on DBI module

2007-05-09 Thread John Scoles
correctly as it is written by the way. You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From: ramesh thangamani To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTEC

Re: Clarification on DBI module

2007-05-09 Thread John Scoles
. cheers John Scoles - Original Message - From: "ramesh thangamani" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: Wednesday, May 09, 2007 3:09 AM Subject: Clarification on DBI module Hi, Can you please clarify my doubts regarding DBI perl mod

Clarification on DBI module

2007-05-09 Thread ramesh thangamani
Hi, Can you please clarify my doubts regarding DBI perl module used for database connection. In my environment I am using single module to prepare and execute the sql queries. The sql query can have bind variables or they may not have. In order to improve performance i used prepare() and

Re: problem with installing dbi module

2007-02-10 Thread Bart Lateur
On Sat, 10 Feb 2007 05:30:40 + (GMT), Jai chandru wrote: >iam using pxperl 5.8.1 on windows and when i tried to install following error >was reported . > >nmake > "gcc" cannot be recoganised as a internal command. > fatal error... PXPerl works well with Min

Re: problem with installing dbi module

2007-02-10 Thread Jonathan Leffler
On 2/9/07, Jai chandru <[EMAIL PROTECTED]> wrote: iam using pxperl 5.8.1 on windows and when i tried to install following error was reported . >nmake "gcc" cannot be recoganised as a internal command. fatal error... Why Perl 5.8.1? Use 5.8.8! It appear

problem with installing dbi module

2007-02-10 Thread Jai chandru
iam using pxperl 5.8.1 on windows and when i tried to install following error was reported . >nmake "gcc" cannot be recoganised as a internal command. fatal error... plese help me - Here’

RE: error in locating loadable object in DBI module.

2007-01-31 Thread Reidy, Ron
Did you install the DBI module? Did you really type "DBi" vs. "DBI" (it makes a huge difference)? Did you install DBI using ppm? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Tapas Kumar Swain [mailto:[EMAIL PROTECTED] Sent: Wednesday, January

error in locating loadable object in DBI module.

2007-01-31 Thread Tapas Kumar Swain
Hi, I am new to perl. I am using Active state perl for windows XP version5.8.8. I am trying export data from text file to an remote sql server database .I have followed the code given in URL http://www.oreillynet.com/pub/a/databases/2006/12/21/dts-imports.html

Re: DBI Module

2007-01-26 Thread Robert Roggenbuck
What is the error message You get while 'make'? Robert Agarwal, Nalnish (CT) schrieb: Hello, I am trying to make DBI on Solaris 9 machine. Following is the output of perl -V Makefile.PL --- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration

DBI Module

2007-01-25 Thread Agarwal, Nalnish \(CT\)
Hello, I am trying to make DBI on Solaris 9 machine. Following is the output of perl -V Makefile.PL --- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=solaris, osvers=2.9, archname=sun4-solaris-64int uname='sunos

  1   2   3   >