Re: perl DBI cannot connect to host=hhhh; Solved use argname=xxx format

On Sun, Sep 1, 2024 at 8:27 AM Dennis German wrote: > In the documentation for DBI I did not see using the call format > argname= > Connecting is a very driver-specific action, so the best place to look is the docs for your driver - in your case, DBD::mysql. The very top of the DBD::mysql man

Re: perl DBI cannot connect to host=hhhh; Solved use argname=xxx format

Thank you very much! In the documentation for DBI I did not see using the call format argname= . Sincerely, Dennis German On 8/31/24 21:39, Zheng Li Sheng wrote: something like this: |# Define database connection parametersmy$database='your_database';my$hostname='127.0.0.1';# or any ot

Re: perl DBI cannot connect to host=hhhh

something like this: # Define database connection parametersmy $database = 'your_database';my $hostname = '127.0.0.1'; # or any other valid hostname/IP addressmy $port = '3306'; # Default MySQL port# Construct DSN stringmy $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";# D

perl DBI cannot connect to host=hhhh

How can DBI use a database SERVER not a socket? 1) perl code segment $host="sdb-74.hosting.stackcp.net"; #actually not used $database="realger1_birding"; $user='realger1_observr'; $pass='birxxx'; use DBI; use DBD::mysql; my $dbh = DBI->connect("DBI:mysql:$database",$user, $pass ); if ( ! $dbh

Version 3.18.0 of DBD::Pg released (Perl DBI driver for Postgres)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Version 3.18.0 of DBD::Pg, the Perl DBI driver for PostgreSQL, is now available. This release adds support for the new PQclosePrepared function inside libpq. What this means is that if DBD::Pg is compiled against version 17 or higher of Postgres

Re: PERL - DBI MODULE

The closest thing to what you ask that is actually useful is to install DBD::SQLite. While this is a DBD, it includes the database engine so you have full DBI functionality without needing to have a separate database server. -- Darren Duncan On 2020-06-02 9:35 p.m., Pramod Mv wrote: Hello te

RE: [EXTERNAL] PERL - DBI MODULE

need more help from this list for that https://metacpan.org/pod/DBD::JDBC You can use the Metacpan search interface for more DBD modules. And here are a few tutorials: This uses DBD::CSV https://www.perl.com/pub/1999/10/DBI.html/ This uses DBD::mysql https://www.perltutorial.org/perl-dbi

RE: [EXTERNAL] PERL - DBI MODULE

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

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 existing is to provide a unifo

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

ANNOUNCE: Informix Database Driver for Perl DBI Version 2018.1031 (2018-10-31) released

Informix Database Driver for Perl DBI Version 2018.1031 (2018-10-31) has been uploaded to CPAN. Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.008001 or later to access Informix databases via the DBI module (but if you are not already using

Re: Perl DBI libraries for connecting 12c

In message , Christopher Jones writes: >For the record, Instant Client is available in Solaris packages: https://blogs >.oracle.com/jmcp/oracle-instant-client:-now-available-in-ips Have you noticed that Oracle ships 12.2 Instant Client but only serves 12.1 IPS packages for Solaris 11? http://pkg.

Re: Perl DBI libraries for connecting 12c

On 10/10/17 3:42 pm, John R Pierce wrote: On 10/9/2017 6:32 PM, Lincoln A Baxter wrote: You can solve this problem by building your own perl with gcc. It's not that hard. After build, install it in a location on path (actually you pick the install location has part of configuring the build).

Re: Perl DBI libraries for connecting 12c

On 10/10/17 00:07, Bruce Johnson wrote: On Oct 9, 2017, at 3:52 PM, John R Pierce wrote: On 10/9/2017 2:49 PM, Furst, Carl wrote: I believe you have to go to Oracle to get those.. You can get DBI and even DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off of. You

Re: Perl DBI libraries for connecting 12c

On 10/9/2017 6:32 PM, Lincoln A Baxter wrote: You can solve this problem by building your own perl with gcc. It's not that hard. After build, install it in a location on path (actually you pick the install location has part of configuring the build). Then you can build the DBI, and DBD::oracle.

Re: Perl DBI libraries for connecting 12c

On Mon, 2017-10-09 at 15:52 -0700, John R Pierce wrote: > On 10/9/2017 2:49 PM, Furst, Carl wrote: > > I believe you have to go to Oracle to get those.. You can get DBI and even > > DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link > > off of. You’ll need to install an orac

Re: Perl DBI libraries for connecting 12c

> On Oct 9, 2017, at 3:52 PM, John R Pierce wrote: > > On 10/9/2017 2:49 PM, Furst, Carl wrote: >> I believe you have to go to Oracle to get those.. You can get DBI and even >> DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off >> of. You’ll need to install an oracle

Re: Perl DBI libraries for connecting 12c

On 10/9/2017 2:49 PM, Furst, Carl wrote: I believe you have to go to Oracle to get those.. You can get DBI and even DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off of. You’ll need to install an oracle client library. as I recall, to use CPAN and build modules tha

Re: Perl DBI libraries for connecting 12c

PM To: "dbi-users@perl.org" Subject: Perl DBI libraries for connecting 12c Hello, I need to install the Perl DBI libraries that are used by Perl scripts for connecting to an Oracle 12c database. The server is running Solari

Perl DBI libraries for connecting 12c

Hello, I need to install the Perl DBI libraries that are used by Perl scripts for connecting to an Oracle 12c database. The server is running Solaris 10 sparc Any help would be greatly appreciated. # perl

ANNOUNCE: Informix Database Driver for Perl DBI Version 2015.1101 (2015-11-01) released

Informix Database Driver for Perl DBI Version 2015.1101 (2015-11-01) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.008001 or later to access Informix databases via the DBI module (but if you are not already

(Fwd) perl DBI bug report

- Forwarded message from Dave Dyer - Date: Tue, 01 Sep 2015 12:40:00 -0700 From: Dave Dyer To: tim.bu...@pobox.com Subject: perl DBI bug report This query produces results with lots of trailing nulls embedded in the "outcome" value. I suppose this might be expected to do

ANNOUNCE: Informix Database Driver for Perl DBI Version 2015.0826 (2015-08-26) released

On the eighth birthday of the 2007.0826 release of DBD::Informix… Informix Database Driver for Perl DBI Version 2015.0826 (2015-08-26) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.008001 or later to access

ANNOUNCE: Informix Database Driver for Perl DBI Version 2015.0825 (2015-08-25) released

Informix Database Driver for Perl DBI Version 2015.0825 (2015-08-25) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.8.1 or later to access Informix databases via the DBI module (but if you are not already using

RE: perl DBI errors

that all dependency software was installed in the same location on all servers and install the perl modules in the same order you did for the original AIX box. So keep good notes! Good luck :) Curtis From: Jillapelli, Ramakrishna [mailto:ramakrishna.jillape...@xerox.com] Sent: Friday, March 07

Reg: perl DBI errors

Hi, Recently AIX 6.x is upgraded to AIX 7.1 on our servers. That upgraded automatically Perl version to 5.10.1. There are lot of perl and shell scripts on our servers. After upgrading most of the perl scripts failing. Errors: 1) Can't locate loadable object for module DBI in @INC (@INC con

ANNOUNCE: Informix Database Driver for Perl DBI Version 2013.0521 (2013-05-21) released

Informix Database Driver for Perl DBI Version 2013.0521 (2013-05-21) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.6.1 or later to access Informix databases via the DBI module (but if you are not already using

RE: (Fwd) Perl DBI question

Bruce, Thanks very much, I do see it in the several comments, and it appears to work as well! Thanks to Tim and then particularly Bruce for showing me the way, I do appreciate it! So in a nutshell: When a mysql command executed in a perl DBI do or execute method: load data local infile

Re: (Fwd) Perl DBI question

s this fits my situation exactly, I just have to learn where the "option > files" are > and how to put the [client] loose-local-infile=1 into it. > > Any suggestions where to look this up? right there in theat section you looked at, down in the comments is "For use in pe

RE: (Fwd) Perl DBI question

s where to look this up? Thanks again for your help with this! Mark Vancura -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Thursday, May 09, 2013 11:26 AM To: dbi-users@perl.org (dbi-users@perl.org) Subject: Re: (Fwd) Perl DBI question On May 9, 201

Re: (Fwd) Perl DBI question

On May 9, 2013, at 9:37 AM, tim.bu...@pobox.com wrote: > > However, then I want to put data into it, with a command like the following: > > > > load data local infile 'TEMP_LOAD_DATA_26021' into table ports ; > > > > And I get: > > DBD::mysql::db do failed: The used command is not

(Fwd) Perl DBI question

- Forwarded message from "Vancura, Mark D (Mark)" - Date: Thu, 9 May 2013 11:05:37 -0400 From: "Vancura, Mark D (Mark)" To: "tim.bu...@pobox.com" Subject: Perl DBI question Tim, I am newly trying to make Perl and DBI work with mysql, with s

ANNOUNCE: IBM Informix Database Driver for Perl DBI Version 2013.0118 (2013-01-18) released

IBM Informix Database Driver for Perl DBI Version 2013.0118 (2013-01-18) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.6.1 or later to access Informix databases via the DBI module (but if you are not already

Re: Perl DBI Hangs while execute()

oonection string is not correct. > > Cheers > > > > > From: amaresh.poth...@gmail.com > > Date: Mon, 19 Nov 2012 16:59:09 +0530 > > > Subject: Perl DBI Hangs while execute() > > To: dbi-users@perl.org > > > > > Hi All, > > > > I am usi

RE: Perl DBI Hangs while execute()

There are many things you can do in sqlplus that you cannot do in sql (in this case DBI). What are you trying to run? -Original Message- From: amaresh pothnal [mailto:amaresh.poth...@gmail.com] Sent: Monday, November 19, 2012 3:29 AM To: dbi-users@perl.org Subject: Perl DBI Hangs while

RE: Perl DBI Hangs while execute()

Well I would do something like select 1 from dual rather thatn '*' It sounds like your DB coonection string is not correct. Cheers > From: amaresh.poth...@gmail.com > Date: Mon, 19 Nov 2012 16:59:09 +0530 > Subject: Perl DBI Hangs while execute() > To: dbi-

Perl DBI Hangs while execute()

Hi All, I am using Perl DBI to connect Oracle Database. The query runs if type from 'sqlplus' manually but hangs when I use the sql inside the script. Getting following error, "DBD::Oracle::st execute failed: ORA-36871: (XSFTDSC01) Object %s cannot be used to define a colum

Re: Query on Perl DBI installation on Linux

: Query on Perl DBI installation on Linux Hi I installed the perl and DBI, DBD::Oracle module. I am getting the below error while I try to execute the DB connection perl coding. Please let me know what is the problem and the solution for this. Perl version : 5.8.8 Linux wapduvirtual062 2.6.18-308.

Re: Query on Perl DBI installation on Linux

did you set the LD_LIBRARY_PATH to point to where the oracle libraries reside? Is libclntsh.so.11.1 readable by the user you are running the script with? The error is from missing LD_LIBRARY_PATH or the library is not readable by the user. > > Hi I installed the perl and DBI, DBD::Oracle module

Query on Perl DBI installation on Linux

Hi I installed the perl and DBI, DBD::Oracle module. I am getting the below error while I try to execute the DB connection perl coding. Please let me know what is the problem and the solution for this. Perl version : 5.8.8 Linux wapduvirtual062 2.6.18-308.4.1.el5 #1 SMP Wed Mar 28 01:54:56 EDT

Query on Perl DBI installation on Linux

Hi I installed the perl and DBI, DBD::Oracle module. I am getting the below error while I try to execute the DB connection perl coding. Please let me know what is the problem and the solution for this. Perl version : 5.8.8 Linux wapduvirtual062 2.6.18-308.4.1.el5 #1 SMP Wed Mar 28 01:54:56 EDT

ANNOUNCE: IBM DB2 Database Driver for Perl DBI Version 1.84 released

IBM DB2 Database Driver for Perl DBI Version 1.84 has been uploaded on CPAN. Testers are please welcome to test the new features and report the bugs. DBI is an open standard application programming interface (API) that provides database access for client applications written in Perl. DBI

Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

asysoft Limited http://www.easysoft.com -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Monday, January 23, 2012 9:14 AM To: dbi-users@perl.org Subject: Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE? On 23/01/12 14:13, TIDWELL, G

RE: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

rl.org Subject: Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE? On 23/01/12 14:13, TIDWELL, GARY wrote: > Hi all, we are currently using DBD::ORACLE 1.16 and DBI 1.46, and I'm having > a tough time > trying to determine if either of these are st

Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

any futher. I also >>depends on the version of oracle DB and client you are using. >>CheersJohn >> > Date: Mon, 23 Jan 2012 15:14:24 + >>> From: martin.ev...@easysoft.com >>> To: dbi-users@perl.org >>> Subject: Re: What is the oldest community

Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

gt; > Date: Mon, 23 Jan 2012 15:14:24 + >> From: martin.ev...@easysoft.com >> To: dbi-users@perl.org >> Subject: Re: What is the oldest community supported versions for PERL >>DBI and DBD::ORACLE? >> >> On 23/01/12 14:13, TIDWELL, GARY wrote: >> >

RE: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

the version of oracle DB and client you are using. CheersJohn > Date: Mon, 23 Jan 2012 15:14:24 + > From: martin.ev...@easysoft.com > To: dbi-users@perl.org > Subject: Re: What is the oldest community supported versions for PERL DBI and > DBD::ORACLE? > > On 23/01/12

Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

On 23/01/12 14:13, TIDWELL, GARY wrote: Hi all, we are currently using DBD::ORACLE 1.16 and DBI 1.46, and I'm having a tough time trying to determine if either of these are still supported by the open source community. All help is appreciated. Thanks, Gary DBI 1.46 isn't even on cpan now

What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

Hi all, we are currently using DBD::ORACLE 1.16 and DBI 1.46, and I'm having a tough time trying to determine if either of these are still supported by the open source community. All help is appreciated. Thanks, Gary

Re: perl-dbi #temp table created using handle not accessible when accessed via ->do() with the same handle

ooking at the problem , I found that a very basic thing is failing with Perl::DBI using DBD::ODBC on sql server. But i am not sure if this wont happen with any other driver. The problem is that when I create a #temp table using $dbh->do and when i try to access the same #temp table using ano

RE: perl-dbi #temp table created using handle not accessible when accessed via ->do() with the same handle

Maybe it just doesn't like the # character in the table name. -Will > -Original Message- > From: Anantharaman Sekaripuram, Gopalakrishnan > [mailto:gopalakrishnan.sekaripuram.ananthara...@deshaw.com] > Sent: 4 August 2011 08:57 > To: dbi-users@perl.org > Subjec

ANNOUNCE: IBM Informix Database Driver for Perl DBI Version 2011.0612 (2011-06-12) released

After 3 years and 1 month bar 1 day, a new version of DBD::Informix hits the streets - well, CPAN, anyway. The primary change - support for Perl 5.14.0. IBM Informix Database Driver for Perl DBI Version 2011.0612 (2011-06-12) has been uploaded to CPAN. IBM Informix Database Driver for Perl

RE: perl DBI Oracle NCLOB fetching

al. Try a trace=>10 but you will get a whold lot more tracing Cheers John > Date: Mon, 6 Jun 2011 10:57:24 +0200 > From: y...@mailueberfall.de > Subject: Re: RE: perl DBI Oracle NCLOB fetching > To: byter...@hotmail.com; dbi-users@perl.org > > Hello, > > set

Re: RE: perl DBI Oracle NCLOB fetching

tring nls_timestamp_tz_format string SQL> yoyo Original-Nachricht > Datum: Fri, 3 Jun 2011 13:27:54 -0400 > Von: John Scoles > An: y...@mailueberfall.de, dbi-users@perl.org > Betreff: RE: perl DBI Oracle NCLOB fetching > > That only ocures

RE: perl DBI Oracle NCLOB fetching

> Subject: perl DBI Oracle NCLOB fetching > > Hello, > > my Perl script uses uses the DBI interface to connect to Oracle and runs > a select statement. But if one column is of type NCLOB it fails with: > > DBD::Oracle::st fetchrow_hashref failed: ORA-24806: LOB form mismat

perl DBI Oracle NCLOB fetching

NUM=1"] I googled a lot and didn't found any solution for it. According to the used versions of Perl, DBI and Oracle and the NLS settings it should work. Any idea how to get it working? Here are my used versions: DBI::VERSION = "1.41" perl, v5.8.0 SQL&

Re: Update is not working properly with Perl DBI

On 18/05/11 13:10, Shree wrote: I don't think we can help you because we don't know what HandleIds() does. I note it may return -1 and causes all of the remaining ids in your batch to be skipped. Some further comments below: use strict; use warnings; my $dsn = 'dbi:Oracle:dbname'; my $user =

Update is not working properly with Perl DBI

Hi, I have Perl program that will process one by one records from a queue table and set the flag 'T' to the processed records, Hence the same processed records should not be process again. And here the commit will happen in batch, the program will take batch of 10 records once and process it afte

execute external SQL scripts file within perl/DBI

I have a SQL routine stored in a file, that I wish to run in between other SQL statements within a perl/DBI script. I wonder, besides to read that file into a "prepare" statement, is there a way to directly execute that file from within the perl script? On a second thought, the sys

Re: (Fwd) Perl DBI on Mac OS X

On 05.05.2011 10:50, Martin J. Evans wrote: Clapper SQLCMD is a Python application that uses '/usr/local/lib/libmyodbc3.so'. So do you want to connect to MS SQL Server or MySQL? You need different ODBC drivers for each. Perl can also connect to MySQL using DBD::mysql, without needing an O

Re: (Fwd) Perl DBI on Mac OS X

David, I'm quickly losing track of where you are because you answered so many posts from days ago trying to help you and now mysql seems to be mentioned. Let me try and explain some of what you are doing and why it might be going wrong. "I am not explicitly specifying iODBC" When DBD::ODBC wa

RE: (Fwd) Perl DBI on Mac OS X

nathan Leffler [mailto:jonathan.leff...@gmail.com] Sent: Tuesday, May 03, 2011 11:47 AM To: Stiff, David Cc: dbi-users@perl.org Subject: Re: (Fwd) Perl DBI on Mac OS X On Tue, May 3, 2011 at 08:15, mailto:david_st...@mcafee.com>> wrote: Sorry. I meant to say Leopard, not Ubuntu. MacOS X it

RE: (Fwd) Perl DBI on Mac OS X

May 03, 2011 2:09 PM To: Stiff, David Cc: dbi-users@perl.org Subject: Re: (Fwd) Perl DBI on Mac OS X On Tue, May 3, 2011 at 10:53, mailto:david_st...@mcafee.com>> wrote: Comments in-line Now you have to get down to - which ODBC drivers do you have installed? >> How can I check? I d

RE: (Fwd) Perl DBI on Mac OS X (or Ubuntu?)

d From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] Sent: Tuesday, May 03, 2011 10:27 AM To: Stiff, David; dbi-users@perl.org Subject: Re: (Fwd) Perl DBI on Mac OS X (or Ubuntu?) On Mon, May 2, 2011 at 19:47, Tim Bunce mailto:tim.bu...@pobox.com>> wrote: - Forwarded messa

Re: (Fwd) Perl DBI on Mac OS X

id_st...@mcafee.com To: > > tim.bu...@pobox.com Subject: Perl DBI on Mac OS X > > > Hi Tim, > > > Sorry to bother you. I am new to Perl DBI. I have it working fine on > > my Windows 7 box. > > > I have installed the module on Ubuntu and tried running the same

Re: (Fwd) Perl DBI on Mac OS X

I am not explicitly requesting iODBC. I am trying to run the same test script, that works on my Windows machine, on a Mac machine. The script has: my $dsn = "DBI:ODBC:Driver={SQL Server};Server=$server;Database=$db"; Is this correct for the Mac? Thanks, David (sent from my personal account

Re: (Fwd) Perl DBI on Mac OS X

DBMS (DB) using just the ODBC software -- probably using isql or something similar. Only when you have that ironed out should you try bringing Perl into the picture. My general rule of thumb is: * Get the DB connection working without Perl (+ DBI + DBD::WhatEver) * Then get it working with Perl (

Re: (Fwd) Perl DBI on Mac OS X

DBM > > Driver: ExampleP > > Driver: File > > Driver: Gofer > > Driver: ODBC > > Driver: Proxy > > Driver: Sponge > That says you've got the Perl + DBI + DBD::ODBC combination installed. You even have an ODBC driver manager installed. Now you have to

Re: (Fwd) Perl DBI on Mac OS X (or Ubuntu?)

On Mon, May 2, 2011 at 19:47, Tim Bunce wrote: > - Forwarded message from david_st...@mcafee.com - > > Date: Mon, 2 May 2011 18:40:11 -0700 > From: david_st...@mcafee.com > To: tim.bu...@pobox.com > Subject: Perl DBI on Mac OS X > > [...] I am new to Perl DBI. I

Re: (Fwd) Perl DBI on Mac OS X

On 03/05/11 03:47, Tim Bunce wrote: - Forwarded message from david_st...@mcafee.com - Date: Mon, 2 May 2011 18:40:11 -0700 From: david_st...@mcafee.com To: tim.bu...@pobox.com Subject: Perl DBI on Mac OS X Hi Tim, Sorry to bother you. I am new to Perl DBI. I have it working fine on my

(Fwd) Perl DBI on Mac OS X

- Forwarded message from david_st...@mcafee.com - Date: Mon, 2 May 2011 18:40:11 -0700 From: david_st...@mcafee.com To: tim.bu...@pobox.com Subject: Perl DBI on Mac OS X Hi Tim, Sorry to bother you. I am new to Perl DBI. I have it working fine on my Windows 7 box. I have

Re: Need Perl DBI and DBD modules for Perl 5.8.8

On 13/04/2011 5:19 PM, mmilli...@fruit.com wrote: Well nothing special The latest DBI and DBD::Oracle and I would go with the latest version of the Oracle instant client 11g. Compiling for AIX is always a bit problematic depending on how the system is set up, how the Perl was compiled and wh

Need Perl DBI and DBD modules for Perl 5.8.8

Hello Experts, Need to recompile the DBI and DBD modules for perl 5.8.8 and the server uses Oracle 11g on AIX 6.1.5 If anyone has done this or know which module we need to download your help is reall appreciated, we need to response as quick as possible. Thanks Have a great Day! Senior Unix T

Re: Perl, DBI, DBD and MYSQL versions

> We are using following versions - > > MySql - 5.1.52 > Perl- 5.12.2 > DBI - DBI-1.615 > DBD - DBD-mysql-4.018 > > Is this combination correct? All up-to-date stable releases, so I'd consider it very good. -- Michael Ludwig

Perl, DBI, DBD and MYSQL versions

Hi, I want to know if there is any recommended versions for PERL, MYSQL, DBI and DBD. We are using following versions - MySql - 5.1.52 Perl- 5.12.2 DBI - DBI-1.615 DBD - DBD-mysql-4.018 Is this combination correct? Regards, Dattatray. DISCLAIMER == This e-mail may contain privilege

RE: external password store with perl DBI and CGI

ers@perl.org > Subject: external password store with perl DBI and CGI > > > I have a perl CGI script that uses DBI, connects to a 10g database > and does some simple stuff. It works. > > I want to use Oracle Wallet so that my script does not have > the text of the username/pas

external password store with perl DBI and CGI

I have a perl CGI script that uses DBI, connects to a 10g database and does some simple stuff. It works. I want to use Oracle Wallet so that my script does not have the text of the username/password wired in. This is on HP-UX and I am using Apache httpd. I have modified the Apache configuratio

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

On 07/28/2010 05:53 PM, Stuart Cooper wrote: > Hi Damian, > >> my $first_line = `grep -v '#' $filename|head -n 1`; # to get the first >> non-comment line > --extra code deleted-- > It's a broken pipe because the right side of it is not valid. Could you elaborate on why? I tried it and it worke

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

Hi Damian, > my $first_line = `grep -v '#' $filename|head -n 1`; # to get the first > non-comment line > the shell which is invoked inherits the SIGPIPE = 'IGNORE' state. This > causes a > grep: writing output: Broken pipe > error as the grep tries to write to the head process which has exited.

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

I'm no software engineer, but given that it is known that some of the libraries used by DBI 'mess with' signal dispositions in apparently unknown ways, would it not make sense for DBI.pm to preserve the state of %SIG on entry and reinstate it on disconnect/END/EXIT cheers Damian On 28 Ju

Perl DBI sets $SIG{PIPE} to 'IGNORE'

I'm using MySQL, any idea where I should report the problem to? (I'm a biologist not a computer programmer, apologies for my ignorance) thanks Damian On 28 Jul 2010, at 19:22, Martin J. Evans wrote: Damian Keefe wrote: Hi Folks $DBI::VERSION = "1.609" perl, v5.8.8 built for x86_64-l

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

damian keefe wrote: I'm no software engineer, but given that it is known that some of the libraries used by DBI 'mess with' signal dispositions in apparently unknown ways, would it not make sense for DBI.pm to preserve the state of %SIG on entry and reinstate it on disconnect/END/EXIT cheers

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

Damian Keefe wrote: Hi Folks $DBI::VERSION = "1.609" perl, v5.8.8 built for x86_64-linux-thread-multi SHELL=/bin/tcsh I'm not sure if this should be considered a bug in DBI or elsewhere, but it has unpleasant consequences. Somewhere in the bowels of DBI, SIGPIPE gets set to 'IGNORE'. It remai

Perl DBI sets $SIG{PIPE} to 'IGNORE'

Hi Folks $DBI::VERSION = "1.609" perl, v5.8.8 built for x86_64-linux-thread-multi SHELL=/bin/tcsh I'm not sure if this should be considered a bug in DBI or elsewhere, but it has unpleasant consequences. Somewhere in the bowels of DBI, SIGPIPE gets set to 'IGNORE'. It remains in this state afte

ANNOUNCE: IBM DB2 Database Driver for Perl DBI Version 1.79 released

IBM DB2 Database Driver for Perl DBI Version 1.79 has been uploaded on CPAN. Testers are please welcome to test the new features and report the bugs. DBI is an open standard application programming interface (API) that provides database access for client applications written in Perl. DBI

Re: How to use perl dbi to create a database

path to point to the location of your Oracle client. -Original Message- From: Martin Evans [mailto:martin.ev...@easysoft.com] Sent: 29 June 2010 17:16 To: Ashish Mukherjee Cc: Sharma, Sumit; dbi-users@perl.org Subject: Re: How to use perl dbi to create a database Ashish Mukherjee w

Re: How to use perl dbi to create a database

ader.pm line 226. > > at (eval 37) line 3 > > Compilation failed in require at (eval 37) line 3. > > Perhaps a required shared library or dll isn't installed where expected > > at C:\Perl\bin\dbi_drivers.pl line 19 I don't use Windows that much and

RE: How to use perl dbi to create a database

ation failed in require at (eval 37) line 3. Perhaps a required shared library or dll isn't installed where expected at C:\Perl\bin\dbi_drivers.pl line 19 -Original Message- From: Martin Evans [mailto:martin.ev...@easysoft.com] Sent: 29 June 2010 17:16 To: Ashish Mukherjee C

Re: How to use perl dbi to create a database

> and if it doesn't create the database and then connect to it. >> >> >> >> Is there any way using Perl DBI to first identify whether a given >> database exists or not if it doesn't create the database? >> >> >> >> Sumit >> >> >

Re: How to use perl dbi to create a database

doesn't create the database and then connect to it. > > > > Is there any way using Perl DBI to first identify whether a given > database exists or not if it doesn't create the database? > > > > Sumit > > > Notice: This e-mail is intended solely for use

Re: How to use perl dbi to create a database

Owen wrote: On Mon, 28 Jun 2010 04:51:45 -0400 "Sharma, Sumit" wrote: I am trying to use Perl to identify if a given database exists or not and if it doesn't create the database and then connect to it. Is there any way using Perl DBI to first identify whether a given databas

Re: How to use perl dbi to create a database

On Mon, 28 Jun 2010 04:51:45 -0400 "Sharma, Sumit" wrote: > Hello, > > > > I am trying to use Perl to identify if a given database exists or not > and if it doesn't create the database and then connect to it. > > > > Is there any way usi

How to use perl dbi to create a database

Hello, I am trying to use Perl to identify if a given database exists or not and if it doesn't create the database and then connect to it. Is there any way using Perl DBI to first identify whether a given database exists or not if it doesn't create the database? Sumit Noti

Re: Perl DBI and DBD::Oracle compatibility with perl, v5.6.1

Martin Evans wrote: Subhasis Gorai wrote: Hi, I just wanted to know what is the compatible version of DBI and Oracle DBD for perl, v5.6.1? It would be great if you can provide me with the information as soon as possible since it's very urgent. Thanks a lot for your time! Regards,

Re: Perl DBI and DBD::Oracle compatibility with perl, v5.6.1

Subhasis Gorai wrote: > Hi, > > > > I just wanted to know what is the compatible version of DBI and Oracle DBD > for perl, v5.6.1? It would be great if you can provide me with the > information as soon as possible since it's very urgent. > > Thanks a lot for your time! > > > > Regards, >

Perl DBI and DBD::Oracle compatibility with perl, v5.6.1

Hi, I just wanted to know what is the compatible version of DBI and Oracle DBD for perl, v5.6.1? It would be great if you can provide me with the information as soon as possible since it's very urgent. Thanks a lot for your time! Regards, Subhasis.

Re: PERL DBI ORACLE DATABASE OUTPUT TO A FILE

Requests for help with something that do not work are usually accompanied by relevant information: Platform versions error messages I did not see any of those in the post. Please see this article, it will prove to be quite valuable to you: http://catb.org/~esr/faqs/smart-questions.html

Re: PERL DBI ORACLE DATABASE OUTPUT TO A FILE

On May 11, 2010, at 12:25 PM, tech422 wrote: > Hi, > > I am trying to query an Oracle database and output the results to a > file using PERL but its not working. I have tried 2 approaches. 1 uses > bind the other does not. Could you please advise? This is my usual route: while (($col1,$col2,$c

RE: PERL DBI ORACLE DATABASE OUTPUT TO A FILE

gt;fetchrow_arrayref()){ $csv->print($fh,$rec); } $fh->close; } else{ die "$!: somefile.csv"; } -Original Message- From: tech422 [mailto:craym...@bu.edu] Sent: Tuesday, May 11, 2010 1:25 PM To: dbi-users@perl.org Subject: PERL DBI ORACLE DATABASE OUTPUT TO A

PERL DBI ORACLE DATABASE OUTPUT TO A FILE

Hi, I am trying to query an Oracle database and output the results to a file using PERL but its not working. I have tried 2 approaches. 1 uses bind the other does not. Could you please advise?: Using Bind: sub get_cms { $ENV{ORACLE_HOME} = "/usr/local/oracle/OraHome1"; my $unique = 0; open

  1   2   3   4   5   6   7   8   >