FAQ

Search Discussions

69 discussions - 263 posts

  • Hello, I have some trouble connecting my PostgreSQL-Server. When I execute this small script: #!/usr/bin/perl use warnings; use strict; use DBI; my $dbh = DBI- connect ("DBI:Pg:dbname=test2", ...
    Christian StalpChristian Stalp
    Jan 22, 2006 at 7:54 pm
    Jan 30, 2006 at 12:52 pm
  • Apache::DBI and DBI's connect_cached both claim to keep your database handles fresh and happy, but I've had numerous problems trying to get either of them to work properly. If a database connection ...
    Tyler MacDonaldTyler MacDonald
    Jan 31, 2006 at 9:24 pm
    Feb 2, 2006 at 6:14 pm
  • DBIx::Transaction currently only depends on DBI, but for it's unit tests to run you need a DBI driver available. If SQLite2 is available, it gives you a nice default DSN to test DBIx::Transaction in ...
    Tyler MacDonaldTyler MacDonald
    Jan 11, 2006 at 2:44 am
    Jan 12, 2006 at 4:35 am
  • I have been handed a couple of requests to change some data. One is an update on 3.6 million records and the other is two different deletions of over 16 million rows of data. I need to be able to do ...
    Robert HicksRobert Hicks
    Jan 17, 2006 at 4:40 pm
    Jan 25, 2006 at 7:47 pm
  • I am using the ODBC module to talk to an Access database. In that database some of the column names have spaces in them (something like EMPLOYEE NAME). I have tried a bunch of stuff (backticking, ...
    Robert HicksRobert Hicks
    Jan 31, 2006 at 4:27 pm
    Feb 2, 2006 at 11:58 pm
  • FYI I'm planning on making the next release (1.51) be the last that officially supports perl 5.6. This is partly to make it easier to implement changes in future releases that improve performance ...
    Tim BunceTim Bunce
    Jan 25, 2006 at 12:04 pm
    Jan 31, 2006 at 11:49 am
  • Greetings all! I apologise for what might seem somewhat of a bit of neglect on my part to get some features into DBD::mysql, features such as UTF support, some bugs in 3.0002_4. I've been super busy ...
    Patrick GalbraithPatrick Galbraith
    Jan 31, 2006 at 12:24 am
    Apr 7, 2006 at 4:08 pm
  • or selectall_arrayhashref? Anyway, I rather frequently find that the "most natural" way to represent a query result is an array of hashes: Each row is hashref, but the the rows are in an array(ref) ...
    Peter J. HolzerPeter J. Holzer
    Jan 10, 2006 at 11:48 am
    Jan 11, 2006 at 1:17 pm
  • I'm using swap_inner_handle in a HandleError sub to re-connect the existing database handle. The trick is to re-connect if the error warrants it, return false to the caller, which then allows the ...
    Steven LembarkSteven Lembark
    Jan 25, 2006 at 7:43 pm
    Jan 30, 2006 at 10:41 pm
  • Has anyone ever heard of this? What do you think might be the cause and importantly, the solution? We have a bunch of applications that use DBI and DBD-Oracle and they've been running for quite some ...
    Fong, AnnaFong, Anna
    Jan 20, 2006 at 6:21 pm
    Jan 23, 2006 at 9:45 pm
  • I'm currently using an evaluation copy of the OpenLink Lite "Universal Data Access Driver Suite" I have the drivers installed and the test supplied by OpenLink is successful. However, when I try to ...
    Mark NettleinghamMark Nettleingham
    Jan 19, 2006 at 8:27 pm
    Jan 30, 2006 at 11:56 am
  • Hi, I have 10g client installed under linux, DBI version 1.50, DBD::Oracle module 1.16. The make runs fine for DBD::Oracle but the "make test" failed. t/10general.............DBI connect('','<my_user ...
    Thomas PorschbergThomas Porschberg
    Jan 10, 2006 at 12:54 pm
    Jan 11, 2006 at 12:35 pm
  • Hi, I had trouble loading DBD::Sybase on MacOSx 10.4.4.. Any ideas???? boehme:~/DBD-Sybase-1.05_02 boehme$ perl Makefile.PL Sybase OpenClient 12.5.1 ASE Edition found. By default DBD::Sybase 1.05 and ...
    Terence J. Young, D.C.Terence J. Young, D.C.
    Jan 31, 2006 at 8:26 pm
    Feb 13, 2006 at 11:30 pm
  • Hi. I'm trying to work out how to search a database by emailaddress. I'd like to see if an emailaddress exists in a database already. The code looks like this: /~~~~~~~~~~~~~~~~~~~~~~~~~~~ my $email ...
    LukeLuke
    Jan 31, 2006 at 3:23 am
    Jan 31, 2006 at 1:30 pm
  • I created a table in mysql in which i set a field "id" in that table to auto_increment and this field is the primary key to this tabel. so each time a new record is added the id increment by 1. When ...
    Dilly rajaDilly raja
    Jan 28, 2006 at 4:46 am
    Jan 30, 2006 at 12:12 pm
  • I have a cgi script adduser.cgi which collects the data from the user through adduser.html. when i execute this script i encountered the error as shown below. Name "dbi::errstr" used only once: ...
    Dilly rajaDilly raja
    Jan 27, 2006 at 9:57 am
    Jan 28, 2006 at 6:07 am
  • From DBI's pod: This only works for methods which return a single value and is hard to make reliable (avoiding infinite loops, for example) and so isn't recommended for general use! If you find a ...
    Steven LembarkSteven Lembark
    Jan 23, 2006 at 7:39 pm
    Jan 26, 2006 at 2:24 pm
  • Apache::DBI claims that it will reconnect to a database if it's gone away. DBD::Pg claims that it supports the ping method. However, when I restart my database server while apache2 is running, all ...
    Tyler MacDonaldTyler MacDonald
    Jan 13, 2006 at 11:54 pm
    Jan 17, 2006 at 9:50 am
  • I have a script that connects to ms sql server with DBI::ODBC. But this code works only for DBI 1.37 version, not for version 1.48. I get connection failed error and looks like the driver connection ...
    Claire LeeClaire Lee
    Jan 10, 2006 at 6:07 am
    Jan 12, 2006 at 1:12 pm
  • Hello All, I have run into a problem I have not seen before. I need to select all of the rows in a table and I am getting the following error: # upd_wia_test.pl Today's date: 1/10/2006 Running ...
    Elton HughesElton Hughes
    Jan 10, 2006 at 4:57 pm
    Jan 10, 2006 at 8:07 pm
  • I have a problem in taking backup of mysql dump in my windows xp machine. I have a database called dvd. i want to take the backup of this database so i tried the following, but it gives error.So i ...
    Dilly rajaDilly raja
    Jan 30, 2006 at 6:23 am
    Feb 3, 2006 at 11:06 am
  • Hi, Can I pass in a VARRAY data type to an oracle stored procedure via perl or receive VARRAY from Oracle SP? Thanks, KS
    Shuxteau, KikiShuxteau, Kiki
    Jan 24, 2006 at 4:45 pm
    Jan 24, 2006 at 11:55 pm
  • This RFC is an early probe, and is only being sent to 2 discussion lists for now, dbi-users and poop-group. If necessary, I may derive a better version later for wider dissemination, based on your ...
    Darren DuncanDarren Duncan
    Jan 7, 2006 at 12:10 am
    Jan 9, 2006 at 11:10 pm
  • curdate() works if $edate is embedded directly in my sql statement, but not as a bind variable. $bdate works fine. my $bdate = $q- param('bdate') || '%'; my $edate = $q- param('edate') || ...
    Jonathan ManginJonathan Mangin
    Jan 6, 2006 at 4:18 pm
    Jan 6, 2006 at 7:55 pm
  • I'm using DBD::ASAny on my development machine (win2000) but when I copied them to the production server (win2003) I got this error: install_driver(ASAny) failed: Can't load ...
    NyemNyem
    Jan 26, 2006 at 7:52 am
    Feb 2, 2006 at 6:30 am
  • Is there any way to restart the failed transaction from within the HandleError sub? I cannot find anything in the DBI doc's that allows me to tell what the last op on the dbh was. thanx -- Steven ...
    Steven LembarkSteven Lembark
    Jan 26, 2006 at 2:41 am
    Jan 26, 2006 at 7:10 pm
  • HI, I did according to the instruciton: http://www.esoftmatic.com/DBI/. But I found the problem as in title : install_driver(Oracle) failed: DBD::Oracle object version 1.15 does not match bootstrap ...
    Rusek Sebastian-ASR046Rusek Sebastian-ASR046
    Jan 26, 2006 at 10:22 am
    Jan 26, 2006 at 3:39 pm
  • hello evrybody, I have problems in installing DBI module, it require another library "cl" that i dont find please help me thinks cp Driver.xst blib\arch\auto\DBI\Driver.xst cp lib/DBI/ProxyServer.pm ...
    Faten BEN JEMAAFaten BEN JEMAA
    Jan 26, 2006 at 11:39 am
    Jan 26, 2006 at 2:36 pm
  • Hello everybody i got concerns when installing DBI that is after making perl Makefile.pl there is noway to exécute make or nmake or dmake (command not found) after that can anyone give me a simple ...
    Nizar LAHYANINizar LAHYANI
    Jan 26, 2006 at 8:56 am
    Jan 26, 2006 at 11:16 am
  • hello when i try to install mysql dbi for perl i m getting this sort of error cl : Command line error D2027 : cannot execute 'c1' NMAKE : fatal error U1077: 'cl' : return code '0x2' wat i did was ...
    Srikanth chantatiSrikanth chantati
    Jan 22, 2006 at 6:47 am
    Jan 23, 2006 at 12:14 pm
  • Hi, I'm trying to compile DBD::Oracle and on the configure, it assumes I want to use cc (This is solaris 9) instead of gcc. I have tried setting CC=gcc and I've tried moving cc to somewhere else, but ...
    Jon AugustJon August
    Jan 20, 2006 at 5:25 pm
    Jan 20, 2006 at 9:06 pm
  • Trying to compile DBI 1.50 on Solaris 8 using Sun WorkShop 6. The "40profile" test fails because dbi_profile_merge is returning way too many decimal places. Can I assume that this is due to my Perl ...
    Gerald GallagherGerald Gallagher
    Jan 6, 2006 at 5:07 pm
    Jan 11, 2006 at 1:17 pm
  • ----- Forwarded message from yuehua wu <carol.wu@urbandispatch.com ----- Date: Mon, 09 Jan 2006 12:11:09 -0700 From: yuehua wu <carol.wu@urbandispatch.com Subject: dbi-users@perl.org To: ...
    Tim BunceTim Bunce
    Jan 9, 2006 at 8:51 pm
    Jan 10, 2006 at 12:27 pm
  • Hi there, Has anyone seen this message before? install_driver(Oracle) failed: DBD::Oracle object version 1.16 does not match bootstrap parameter 1.06 at C:/Perl/lib/DynaLoader.pm line 253. If so do ...
    Shaw, GaryShaw, Gary
    Jan 6, 2006 at 4:38 am
    Jan 9, 2006 at 9:09 pm
  • I am trying to compile Oracle:DBD for a full Oracle 10g install on a Redhat 64 bit linux (egle64) and I am wondering if anyone has ever gotten the following So far I have gotten the Makefile.PL to ...
    John ScolesJohn Scoles
    Jan 4, 2006 at 5:15 pm
    Jan 9, 2006 at 5:03 pm
  • Now I am trying to install DBD::Oracle 1.16 version to Oracle 10.2.0.1.0_64 db server. Since I am using Perl 32 bit version 5.61 and I do not have permissions to upgrade it to 64 bit, IS THERE A ...
    Sunil A VSunil A V
    Jan 5, 2006 at 11:49 pm
    Jan 9, 2006 at 10:33 am
  • Dear dbi-helpers, My environment is RedHat 9.0. I got the following message while installing DBD::DB2 module. DB2_HOME environment variable must be set to installed location of DB2. Did this message ...
    Vincent DengVincent Deng
    Jan 5, 2006 at 9:49 am
    Jan 5, 2006 at 3:39 pm
  • Hello, I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is unreachable. Can anybody help me with this problem or send me this files? Thanks for any help. Kind Regards Denis ...
    DbaumgaertnerDbaumgaertner
    Jan 31, 2006 at 9:09 am
    Jan 31, 2006 at 9:29 pm
  • Hi all, I have a bugzilla database running on mysql. If you are aware of bugzilla, it has a table called "attachments". what i am trying to do is get the attachments of all the bugs having ...
    Sham PrasadSham Prasad
    Jan 31, 2006 at 12:26 pm
    Jan 31, 2006 at 1:26 pm
  • Try it with nmake and nmake install instaed of PPM if you have downladed the DBI. Regards Razat -----Original Message----- From: Dilly raja Sent: Tuesday, January 24, 2006 2:21 AM To: ...
    Gupta, RazatGupta, Razat
    Jan 24, 2006 at 11:54 am
    Jan 24, 2006 at 12:19 pm
  • I have installed ActivePerl-5.6.1.638-MSWin32-x86 in my Windows-Xp system. I have to install perl DBI on it. I dont have Internet connection. i downloaded the DBI-1.50.tar from the net and unzipped ...
    Dilly rajaDilly raja
    Jan 24, 2006 at 8:20 am
    Jan 24, 2006 at 11:12 am
  • I have been unable to find a complete list of the DATA_TYPE numeric codes returned by the DBL::column_info() function. I've figured out several, but need a full list. Can you point me to such a list? ...
    Mark FenbersMark Fenbers
    Jan 22, 2006 at 3:56 pm
    Jan 23, 2006 at 12:22 am
  • Hi list Without decode the following script works fine but with decode it is giving errors, is there a way to make decode work? Script follows: #!/usr/bin/perl DBI- trace( 2, 'dbitrace.log' ); use ...
    RobertRobert
    Jan 20, 2006 at 7:17 pm
    Jan 20, 2006 at 7:24 pm
  • Hello all. I am having an issue installing DBI on my system. I have tried both installing by hand and using CPAN and I get the same results. After toying with libraries and editting scripts, I can ...
    Jeff BallardJeff Ballard
    Jan 19, 2006 at 7:08 pm
    Jan 20, 2006 at 3:33 pm
  • There is a line of bad code on line 279. I document the error here: http://www.walljm.com/comments.asp?post=4776 Essentially, 279 Scalar::Util::weaken(my $test = \"foo"); the \ is negating the " and ...
    Jason WallJason Wall
    Jan 11, 2006 at 10:23 pm
    Jan 12, 2006 at 2:19 pm
  • Ron Savage suggested that the ideal way to handle the "end user vs. autotester" scenario was to encourage the autotesters to install DBD::SQLite2 (or perhaps set a valid DBI_DSN) for the testing. ...
    Tyler MacDonaldTyler MacDonald
    Jan 12, 2006 at 12:54 am
    Jan 12, 2006 at 1:38 am
  • I am running the install DBD-Oracle command on my WIN machine with the following error: Can't remove directory C:TEMP/DBD_Oracle-1-872-1136408691: Permission denied at ...
    Christopher T. BrownChristopher T. Brown
    Jan 10, 2006 at 5:08 pm
    Jan 10, 2006 at 6:58 pm
  • Actually the full error is: I am running the install DBD-Oracle command on my WIN machine with the following error: Can't remove directory C:\TEMP/DBD_Oracle-1-872-1136408691: Permission denied at ...
    Christopher T. BrownChristopher T. Brown
    Jan 10, 2006 at 5:32 pm
    Jan 10, 2006 at 6:57 pm
  • Well, it's rather messy because dbish's execution of perl is a bit messy. But it works fine. Try this: 1) start dbish like this: dbish dbi:AnyData:f_dir=./mydb 2) within dbish, issue a perl command ...
    Jeff ZuckerJeff Zucker
    Jan 6, 2006 at 6:10 pm
    Jan 9, 2006 at 4:46 pm
  • Hi, I colleague of mine has been briefly using DBD::mysql and was getting a lot of "FREE ERROR BIND!" messages appearing on stderr. I was asked to take a look and I've reproduced this with the ...
    Martin J. EvansMartin J. Evans
    Jan 6, 2006 at 1:21 pm
    Jan 6, 2006 at 6:04 pm
Group Navigation
period‹ prev | Jan 2006 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions69
posts263
users91
websitedbi.perl.org

91 users for January 2006

Tim Bunce: 26 posts John Scoles: 21 posts Ron Savage: 17 posts Christian Stalp: 11 posts Steven Lembark: 11 posts Tyler MacDonald: 11 posts Darren Duncan: 7 posts Peter J. Holzer: 7 posts Alexander Foken: 6 posts Andy Hassall: 6 posts Jeff Urlwin: 6 posts Louis Gonzales: 6 posts JupiterHost.Net: 5 posts Dilly raja: 4 posts Fong, Anna: 4 posts Mark d: 4 posts Mark Nettleingham: 4 posts Robert Hicks: 4 posts Robert Hicks: 4 posts Sunil A V: 4 posts
show more
Archives