FAQ

Perl > dbi-users

Search Discussions

11,276 discussions - 37,179 posts

  • Dear Experts, I am new to perl and I really need your help. I need your help for a perl DBD:sybase module i am using. I am trying to connect to a MS SQL Server from a linux server. Below are the ...
    Sumanth rameshSumanth ramesh
    May 15, 2016 at 3:32 am
    May 18, 2016 at 1:11 am
  • Hi, I've been trying many differents things with the following error, but nothing seems to be working. Let me start to explain my problem from the beginning. (Perl version: v5.10.) I use a ...
    Jefferson EliasJefferson Elias
    May 12, 2016 at 11:12 am
    May 17, 2016 at 5:40 am
  • Hello John. The DBI::hash function simply returns an integer that hash been derived from a string by some maths. See https://en.wikipedia.org/wiki/Hash_function That kind of 'hash' is (mostly) ...
    Tim BunceTim Bunce
    Apr 17, 2016 at 10:40 pm
    Apr 18, 2016 at 4:25 am
  • I'm generating a sql statement like this: sth = $mysql_dbh- prepare( "select sum(column) as columnSum from table where value in ( ? ) and row_date between cast( ? as date) and cast( ? as date) ") ...
    Bruce FerrellBruce Ferrell
    Apr 5, 2016 at 4:24 pm
    Apr 6, 2016 at 1:32 am
  • test.pl is more of a manual testing tool - you'll see it has a bunch of options for command line use. It could simply be renamed to tester.pl :) I find http://matrix.cpantesters.org/?dist=DBI+1.633 ...
    JluisJluis
    Feb 28, 2016 at 1:12 pm
    Feb 28, 2016 at 1:12 pm
  • Hi. I don't provide support for DBD::Oracle directly. Please email <span class="m_body_email_addr" title="f3fe1c24c9557e5b071e1780ae40b4c2" dbi-users@perl.org</span or, if you'd rather not just yet, ...
    Tim BunceTim Bunce
    Feb 5, 2016 at 8:35 pm
    Feb 7, 2016 at 12:05 pm
  • Martin J. EvansMartin J. Evans
    Jan 28, 2016 at 3:35 pm
    Jan 28, 2016 at 3:35 pm
  • Hello all, I'm updating a LONGBINARY column in a Jet 4 (MDB) database on Windows 7 with DBD::ODBC and have encountered an odd issue. Rather than the common problem of Unicode data being treated as ...
    Jerrad PierceJerrad Pierce
    Jan 27, 2016 at 10:11 pm
    Jan 28, 2016 at 3:52 pm
  • Hi David, This looks to be a genuine oversight on my part, which has until recently been patched up accidentally by the definition of a macro MIN() in /usr/include/sys/param.h (on Mac OS X 10.10.5 ...
    Jonathan LefflerJonathan Leffler
    Jan 26, 2016 at 9:40 pm
    Jan 26, 2016 at 9:40 pm
  • Hello greate community! This is my first message into this list :-), I hope I could get some help about this tricky issue. I'm trying to install manually Perl DBI 1.52 on a el6 server. I'm doing this ...
    Erick OcrospomaErick Ocrospoma
    Dec 26, 2015 at 4:42 pm
    Dec 27, 2015 at 2:35 am
  • PROBLEM: I have perl-DBD-MySQL-4.013-release-3.el6 and Perl 5.10.1 and while I have a user account which can connect to the database at the command prompt, I cannot get the same user (or any user) to ...
    Donna CoteDonna Cote
    Dec 23, 2015 at 1:36 am
    Dec 23, 2015 at 2:48 am
  • Dear Perl and MySQL community, We're pleased to announce the release of DBD::mysql 4.033_01. This is not a 'stable' release but merely for testing and feedback. We'll put out a stable 4.034 release ...
    Michiel BeijenMichiel Beijen
    Dec 15, 2015 at 7:28 am
    Dec 15, 2015 at 7:28 am
  • Dear DBI users, I use Perl, DBI and DBD:mysql for years, without a problem. But working on my latest project I encounter Perl often, but *not always(!) *crashing with the Windows message "Perl ...
    Meir GuttmanMeir Guttman
    Dec 7, 2015 at 8:21 am
    Dec 14, 2015 at 8:39 am
  • Hi all I am encountering a problem with DBD::mysql 4.20.0-r1, perl 5.20 and mysql 5.5 on amd64 Linux. The driver does not reconnect to the db once the server has closed the session (eg. after trying ...
    Markus WernigMarkus Wernig
    Dec 6, 2015 at 5:31 pm
    Dec 6, 2015 at 5:31 pm
  • Dear DBI users, I use Perl, DBI and DBD:mysql for years, without a problem. But working on my latest project I encounter Perl crashing with the Windows message "Perl interpreter has stopped ...
    Meir GuttmanMeir Guttman
    Dec 6, 2015 at 5:04 pm
    Dec 6, 2015 at 5:04 pm
  • SQL server v6.01.7601. is installed . version of ODBC is 6.01.7601 When I click configure, it says that MS access driver is not installed.
    Ismail ChamseddineIsmail Chamseddine
    Nov 2, 2015 at 2:47 pm
    Nov 2, 2015 at 5:37 pm
  • I did and it didn't work. for more information, the error message is the following: failed: [Microsoft][ODBC driver manager] data source name not found and no default driver specified (SQL - IM002) ...
    Ismail ChamseddineIsmail Chamseddine
    Nov 2, 2015 at 9:56 am
    Nov 2, 2015 at 11:01 am
  • 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 ...
    Jonathan LefflerJonathan Leffler
    Nov 1, 2015 at 3:17 pm
    Nov 1, 2015 at 3:17 pm
  • I am trying to connect to MS access database on my PC. I am getting an error message of failure, data source not found, (ODBC driver manager) no default driver is mentioned . please help
    Ismail ChamseddineIsmail Chamseddine
    Oct 30, 2015 at 1:21 pm
    Nov 2, 2015 at 9:19 am
  • Hello Team , We are facing an issue while trying to install DBI-1.634. Perl Version we use : v5.8.8 built for aix-thread-multi Server Version:AIX IMCBLRDMZSR1237 1 6 00C6FD554C00 I downloaded ...
    Abhishek Mohanty1Abhishek Mohanty1
    Oct 29, 2015 at 9:29 am
    Oct 30, 2015 at 1:52 am
  • Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant client? I installed the Basic and Development IC rpm’s and the DBD installer complained it couldn’t determine what ...
    Bruce JohnsonBruce Johnson
    Oct 20, 2015 at 6:53 pm
    Oct 20, 2015 at 9:44 pm
  • I've just uploaded DBD::ODBC 1.53_1 to the CPAN. The most significant change is to support DBI's new 64 bit row counts. DBD::ODBC did (and still does) support 64 bit row counts via its own API but ...
    Martin J. EvansMartin J. Evans
    Oct 16, 2015 at 4:02 pm
    Oct 16, 2015 at 4:02 pm
  • R AR A
    Oct 16, 2015 at 11:50 am
    Oct 16, 2015 at 11:50 am
  • Hi all, I wanted to point out that I have reported an issue with the latest 'dev' release of MySQL and DBD::mysql concerning mysql_insertid http://bugs.mysql.com/bug.php?id=78778 It's been confirmed ...
    Michiel BeijenMichiel Beijen
    Oct 15, 2015 at 6:00 pm
    Oct 15, 2015 at 6:00 pm
  • FYI: your CSS appears to be broken on: https://metacpan.org/pod/DBI There is no page formatting, others such as, DateTime seem to work fine.
    Geoff CollisGeoff Collis
    Oct 15, 2015 at 9:08 am
    Oct 15, 2015 at 8:48 pm
  • Hello, We are trying to install perl GD (GD-2.41) module in our application server. We detected the error message is given. Kindly help to advice. How to resolve this error message. perl Makefile.PL ...
    Amjath KassaliAmjath Kassali
    Oct 7, 2015 at 7:24 am
    Oct 8, 2015 at 2:09 am
  • Hi experts, I'm not sure whether the email list still works. because <span class="m_body_email_addr" title="f95f57f018372cbfcce46ebbd59d9bd0" sybperl-l@peppler.org</span is bouncing my email.. J We ...
    Yin BryanYin Bryan
    Sep 17, 2015 at 9:42 am
    Sep 17, 2015 at 2:22 pm
  • I have a table defined as follows: SQL desc sb1 Name Null? Type ----------------------------- -------- -------------------- C1 VARCHAR2(30 CHAR) C2 VARCHAR2(30) Note the difference is the character ...
    Steve BaldwinSteve Baldwin
    Sep 8, 2015 at 10:42 pm
    Sep 9, 2015 at 12:41 am
  • ----- Forwarded message from Dave Dyer <<span class="m_body_email_addr" title="bd2f0e3fe8e438136d7a788002a99e05" ddyer@real-me.net</span ----- Date: Tue, 01 Sep 2015 12:40:00 -0700 From: Dave Dyer ...
    Tim BunceTim Bunce
    Sep 1, 2015 at 8:22 pm
    Sep 1, 2015 at 8:22 pm
  • Hi, I have recently ported a large (1.4M line) perl application from: Centos 6.6 DBI version 1.6.09 DBD::ODBC version 1.23 To: Centos 6.6 DBI version 1.6.33 DBD::ODBC version 1.50 (and same issue ...
    Joel PlotkinJoel Plotkin
    Mar 24, 2015 at 3:45 pm
    Apr 8, 2015 at 12:56 pm
  • Dear Perl and MySQL community, We're pleased to announce the release of DBD::mysql 4.031! The changes, per ChangeLog: 2015-03-05 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.031) * Added ...
    Patrick GalbraithPatrick Galbraith
    Mar 8, 2015 at 4:10 pm
    Mar 8, 2015 at 4:10 pm
  • Dear Perl and MySQL community, We're pleased to announce the release of DBD::mysql 4.030_02. This is a test release, meaning that we are on our way to a full-blown release. There are changes in this ...
    Michiel BeijenMichiel Beijen
    Mar 2, 2015 at 9:04 pm
    Mar 2, 2015 at 9:04 pm
  • Fellow mod_perlers, I followed the instructions in the Server Configuration Customization guide to create a custom Apache configuration directive like so: my $foo; sub foo { $foo = $_[2] } ...
    David E. WheelerDavid E. Wheeler
    Mar 2, 2015 at 1:00 am
    Mar 31, 2015 at 4:24 am
  • MySql Gurus This may be the wrong mailing list for this question, so I apologize in advance for breaking some rule. I'm trying to get a trigger to work. My environment is a Perl DBI interface to a ...
    DavidDavid
    Feb 26, 2015 at 2:46 pm
    Feb 26, 2015 at 4:54 pm
  • I think someone wrote about this before, but I just wanted to bring it up again. Is there a way to have DBD::CSV produce a warning or a message (like when printError and raise error is set) to say ...
    Furst, CarlFurst, Carl
    Feb 25, 2015 at 5:25 pm
    Feb 26, 2015 at 5:20 pm
  • My script is intended to update 3 columns in a particular row of a table. My script is: #!/usr/local/perl5/bin/perl -w use strict; use DBI; my $alt_emp_no = 60017; # list of employee ids my ...
    Larry W. VirdenLarry W. Virden
    Feb 20, 2015 at 8:02 pm
    Feb 23, 2015 at 1:39 pm
  • Version 3.5.1 of DBD::Pg, DBI driver for PostgreSQL, is now available. This release contains some minor fixes to the code, the tests, and the documentation. Version 3.5.1 of DBD::Pg can be downloaded ...
    Greg Sabino MullaneGreg Sabino Mullane
    Feb 19, 2015 at 1:19 am
    Feb 19, 2015 at 1:19 am
  • As you may have heard, Larry Wall gave a speech recently declaring the goal of releasing Perl 6 this year, 2015. Honestly, there is little chance of me using Perl 6 until it has a good, working DBI ...
    Greg Sabino MullaneGreg Sabino Mullane
    Feb 5, 2015 at 12:23 am
    Feb 6, 2015 at 10:46 pm
  • Good Morning, I am looking for help to solve my problem with the Perl DBD::Teradata install 1.52. After a successful, error free, build and install I get the follow message when trying to make a ...
    Buehre, Joseph RBuehre, Joseph R
    Feb 4, 2015 at 1:52 pm
    Feb 5, 2015 at 2:42 pm
  • Dear Perl and MySQL community, I’m pleased to announce the release of DBD::mysql 4.030_01. This is a test release, meaning that we are on our way to a full-blown release. There are some great ...
    Patrick GalbraithPatrick Galbraith
    Jan 31, 2015 at 3:19 am
    Jan 31, 2015 at 3:19 am
  • Using mariadb 10 series, Perl 5.18 DBI 1.623 DBD-mysql 4.20 I seem to be getting 3 byte 'PRECISION' back on the statement handle for CHAR and VARCHAR field, so if its supposed to be 35 character ...
    Josh NijenhuisJosh Nijenhuis
    Jan 20, 2015 at 9:06 pm
    Jan 23, 2015 at 2:22 pm
  • jrw $ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.7 (Tikanga) jrw $ perl -v This is perl, v5.8.8 built for x86_64-linux-thread-multi ... jrw $ export | grep -e LC_ALL -e LANG ...
    John WiersbaJohn Wiersba
    Jan 7, 2015 at 9:50 pm
    Jan 8, 2015 at 6:19 pm
  • Version 3.5.0 of DBD::Pg, DBI driver for PostgreSQL, is now available. This release contains two major changes: an improved ping() method, and support for the new backslash-escape for placeholders ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jan 7, 2015 at 3:35 pm
    Jan 7, 2015 at 3:35 pm
  • I start a programme with a DBI dependency and I get: Can't locate object method "bootstrap" via package "DBI" at /usr/contrib/lib/perl5/site_perl/5.18.2/i386-bsdos/DBI.pm line 277. BEGIN ...
    The DoctorThe Doctor
    Jan 1, 2015 at 11:53 pm
    Jan 4, 2015 at 11:22 am
  • Wherein I attempt to summarize the requirements, the background, the options, the risks, and the counter-proposal ... ** Background Drivers that support placeholders parse the SQL statement to find ...
    Tim BunceTim Bunce
    Dec 28, 2014 at 10:50 am
    Jan 9, 2015 at 10:05 pm
  • I found this thread when testing an update to an old patch I had pending and came across the same issue. Having looked into to I believe I have a fix so wanted to link people to the pull request so ...
    Steven HartlandSteven Hartland
    Dec 23, 2014 at 8:15 pm
    Dec 23, 2014 at 8:15 pm
  • Hello Augustus. As more people start using Postgres 9.4 and the JSON operators this is going to become a significant problem. It won't do what you want. Question marks in quotes are ignored by the ...
    Tim BunceTim Bunce
    Dec 19, 2014 at 10:40 am
    Dec 24, 2014 at 12:36 pm
  • I'm pleased to announce the release of DBD::mysql 4.029 From the changelog: * Added fix to tests to create test database if not exists (contstant failure on Travis) (CaptTofu) * Support the fraction ...
    Patrick GalbraithPatrick Galbraith
    Dec 12, 2014 at 8:39 pm
    Dec 12, 2014 at 8:39 pm
  • Hi all, I've been using DBI with DBD::Sybase and SQL Server, and discovered a couple of issues. I will be happy to offer a patch if I can get some consensus on what the correct resolutions are: The ...
    Kurt StarsinicKurt Starsinic
    Nov 16, 2014 at 11:59 pm
    Nov 17, 2014 at 8:57 am
  • Hi Team, I am getting the error while downloading and install the mysql *driver:* [image: Inline image 1] -- kind regards, RaJaG 99 431 631 44
    RaJaG*RaJaG*
    Nov 5, 2014 at 1:09 pm
    Nov 5, 2014 at 8:14 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
groupdbi-users @
categoriesperl
discussions11,276
posts37,179
users6,305
websitedbi.perl.org

Top users

Tim Bunce: 2669 posts Michael A Chase: 1110 posts Isterin: 948 posts Martin Evans: 787 posts Scoles: 480 posts Michael Peppler: 449 posts Jeff: 437 posts Jeff Urlwin: 428 posts Reidy, Ron: 428 posts Ron: 410 posts Ronald J Kimball: 372 posts Jonathan Leffler: 312 posts Peter J . Holzer: 266 posts Jeff Urlwin: 245 posts Jleffler: 197 posts Bart Lateur: 184 posts Alexander Foken: 182 posts Jkstill: 163 posts Hardy Merrill: 149 posts Simon Oliver: 148 posts
show more
Archives