FAQ

Search Discussions

37 discussions - 135 posts

  • 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 ...
    Ramesh thangamaniRamesh thangamani
    May 9, 2007 at 7:10 am
    May 24, 2007 at 4:45 am
  • Hello, I am using DBI 1.51 and DBD::ODBC 1.13, connecting to MSSQL2005. Executing following statements: $sth = $dbh- prepare('create table #foo (a int not null)'); $sth- execute(); $sth = $dbh- ...
    Andon TschauschevAndon Tschauschev
    May 9, 2007 at 3:31 pm
    May 16, 2007 at 12:05 pm
  • You can download it from http://homepage.mac.com/tim.bunce/.Public/perl/DBI-1.55-RC3.tar.gz =head2 Changes in DBI 1.55 (svn rev 9480), 1st May 2007 Fixed set_err() so HandleSetErr hook is executed ...
    Tim BunceTim Bunce
    May 1, 2007 at 9:32 pm
    May 4, 2007 at 5:58 pm
  • [This is my second attempt to post. First was refused for overly- long attachment.] Hello. I hope I have enough information here for someone to assist with a DBD::Informix problem. I am installing ...
    Mark AbajianMark Abajian
    May 15, 2007 at 5:18 am
    Jun 4, 2007 at 6:03 pm
  • Is it inherited? Do statement handles from a ReadOnly driver handle get the same attribute passed? If so: useful. I'd like to see that extended to be able to allow dirty reads or no-lock reads, ...
    H.Merijn BrandH.Merijn Brand
    May 1, 2007 at 8:46 am
    May 31, 2007 at 6:14 pm
  • Hello, We're running Perl v5.8.6 on Linux, Solaris Sparc, and Solaris x86. We're using the latest DBI/DBD related modules: o DBI v1.56 o DBD::Sybase v1.08 o DBIx::ContextualFetch v1.03 o Class::DBI ...
    Wood, DavidWood, David
    May 30, 2007 at 2:45 am
    Jun 8, 2007 at 2:02 am
  • I have been digging a bit to find what people consider loose ends in Text::CSV_XS, and tried to summarize that (in no particular order) in the new TODO list. Here "TODO" gives no guarantee that it ...
    H.Merijn BrandH.Merijn Brand
    May 25, 2007 at 6:50 pm
    May 26, 2007 at 8:43 am
  • Hi, I am trying to execute multi SQL statements within the $dbh- do() and it appears to work fine except it does not give me an error when part of the SQL fails. For example: BEGIN WORK; CREATE TEMP ...
    Loo, Peter # PHXLoo, Peter # PHX
    May 8, 2007 at 5:24 pm
    May 10, 2007 at 7:31 am
  • I want to barcode label from a serial number. I have a property accountability database using SYBASE. I access the database using perl and cgi, and display the results on the Web Page using Apache. ...
    Ithier CtrIthier Ctr
    May 8, 2007 at 5:35 pm
    May 8, 2007 at 7:33 pm
  • Hey: I'm trying to install DBD:mysql against DBI-1.56 and my own build of perl on a Macbook Pro running OS X 10.4.8. In a number of the tests run during the install I'm getting the error below. It ...
    Cosimo1953Cosimo1953
    May 26, 2007 at 7:26 pm
    Jun 13, 2007 at 4:46 pm
  • Hi All I'm trying to connect to MSSQL 2000 to execute a number of stored procedures to return values to my IVR system, I have two stored procedures that work, and one that works from the ms query ...
    Robert BoardmanRobert Boardman
    May 31, 2007 at 9:20 am
    Jun 3, 2007 at 11:40 pm
  • Hi All! Recently I have bumped into a memory leak happening in DBI. Running DBI version 1.55, DBD::ODBC version 1.13 on Windows XP SP2, Active State Active Perl 5.8 build 819. More comprehensive ...
    Fi DotFi Dot
    May 22, 2007 at 12:01 am
    May 22, 2007 at 12:15 pm
  • Hi, While trying to compile DBI-1.55 and getting the following results I am on Solaris 9 (SPARC) and I have tried using gcc 3.4.6 and also 3.3.2 # perl Makefile.PL ...
    Shane NeubauerShane Neubauer
    May 10, 2007 at 4:54 am
    May 11, 2007 at 8:10 am
  • Hello everybody, I'm using DBI v1.51 and DBD::ODBC v1.13. I'm connecting to MSSQL2000/MSSQL2005. Statements are executed in prepare-execute-fetch order. Everything works fine, since I found something ...
    Andon TschauschevAndon Tschauschev
    May 4, 2007 at 8:34 am
    May 4, 2007 at 5:05 pm
  • Hi, I have simple script , trying to get connection to DB. #!/usr/bin/perl use DBI; my $database="billing"; my $data_source = "DBI:mysql:$database;host=165.21.101.47"; my $dbh = DBI- connect( ...
    Keng HeeKeng Hee
    May 30, 2007 at 4:15 am
    May 30, 2007 at 8:20 am
  • Hello, I am writing an application that is using DBI to access a MS SQL database hosted on a remote server. I think I am having trouble with larger result sets. For example: If I do $stmt = "SELECT * ...
    Jordan MuellerJordan Mueller
    May 25, 2007 at 4:10 pm
    May 25, 2007 at 5:11 pm
  • Hi list, Anybody has a document / link explanining how to setup DBI and DBD::Oracle with Oracle 10g on Windows XP? Regards Xavier
    Galo BaldaGalo Balda
    May 10, 2007 at 4:26 pm
    May 10, 2007 at 7:18 pm
  • Hello all, My perl cgi script which runs dbi is generating error messages to the logs just about everytime dbi is called. The program appears to be running correctly. How do I keep from getting the ...
    Mary AndersonMary Anderson
    May 4, 2007 at 5:04 pm
    May 4, 2007 at 5:37 pm
  • I am trying to set up DBI Oracle stuff on a couple of boxes. One is Ubuntu Feiesty and the other is running SunOS 5.8. I have been using the following test script. #!/usr/bin/perl use DBI; $dbh = ...
    Ben EdwardsBen Edwards
    May 1, 2007 at 3:29 pm
    May 1, 2007 at 4:04 pm
  • 2007-05-31 0.27 - H.Merijn Brand <h.m.brand@xs4all.nl * checked with perlcritic (still works under 5.00504) so 3-arg open cannot be used (except in the docs) * 3-arg open in docs too * Added a lot to ...
    H.Merijn BrandH.Merijn Brand
    May 31, 2007 at 1:39 pm
    May 31, 2007 at 4:54 pm
  • Hi, I am trying to install the DBD::DB2 module on my Linux machine. I have installed Perl 5.8.5, IBM DB2 v8.1 , DBI v1.56 . But when i tried to test before install the perl module DBD::DB2 , i got ...
    Anand SeshanAnand Seshan
    May 24, 2007 at 10:51 am
    May 30, 2007 at 8:06 pm
  • (DBD::Oracle version 1.17) Given the following: my $sLobLocator; my $hSQL = $hDB- prepare(q{ BEGIN :lob := NULL; END; }, { ora_auto_lob = 0 }); $hSQL- bind_param_inout( ':lob', \$sLobLocator, 0, { ...
    Sven MillerSven Miller
    May 24, 2007 at 6:09 pm
    May 29, 2007 at 6:32 pm
  • Does connect_cached() reset attributes each time it's called? Even if just returning an active $dbh? On a CDBI application I need to access multiple databases with the same schema. So my initial ...
    Bill MoseleyBill Moseley
    May 23, 2007 at 2:04 am
    May 23, 2007 at 8:12 am
  • Hello, I am trying to write a script that connects to a remote MS SQL database. I have set up dsn on my server before and have no problem connecting. But something is working this time. I am pasting ...
    Jordan MuellerJordan Mueller
    May 21, 2007 at 6:00 pm
    May 21, 2007 at 6:41 pm
  • I´ve just installed DBD::DB2 to access a DB2 database, but I always get the following message when I run a SELECT query: DBD::DB2::db prepare failed: Error calling SQLGetInfo at ... Although this ...
    RodneyrRodneyr
    May 17, 2007 at 12:59 pm
    May 17, 2007 at 11:10 pm
  • I´ve just installed DBD::DB2 to access a DB2 database, but I always get the following message when I run a SELECT query: DBD::DB2::db prepare failed: Error calling SQLGetInfo at ... Although this ...
    RodneyrRodneyr
    May 16, 2007 at 5:51 pm
    May 16, 2007 at 7:50 pm
  • 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 ...
    Justin ZygmontJustin Zygmont
    May 9, 2007 at 11:19 pm
    May 10, 2007 at 8:23 am
  • Hi, I am not able to install the DBD::Sybase module on solaris 5.8. Even ppd packages are not getting installed(I am difficulty in finding one!!!!)Can please somebody help???? The error is: ...
    Amith KCAmith KC
    May 9, 2007 at 2:41 pm
    May 10, 2007 at 6:09 am
  • John, Here is a representative sample of the error output. Most of it has to do with DBI. But then it will generate a whole bunch of purely perl error messages about undefined variables, etc. ...
    Mary AndersonMary Anderson
    May 4, 2007 at 6:01 pm
    May 5, 2007 at 5:18 am
  • The email headers say: List-Unsubscribe: List-Help: Send email to dbi-users-unsubscribe@perl.org from your registered email acccount, or go to the web site dbi.perl.org and unsubscribe from there. It ...
    Jonathan LefflerJonathan Leffler
    May 3, 2007 at 12:30 pm
    May 4, 2007 at 7:09 am
  • Hello, I built DBD-Oracle for version 10 using a /usr/oracle/rdbms directory. However, now the DBAs want me to build it against a /usr/oracle/client directory instead. What is the best way to ...
    Capacio, Paula JCapacio, Paula J
    May 1, 2007 at 8:07 pm
    May 1, 2007 at 8:23 pm
  • I am having a problem with fetching rows of data contain long varchar data types. Subsequent rows are returning data from previous rows. I am using DBI-1.52 and DBD-Ingres-0.51 running on Red Hat ...
    Steven BernsteinSteven Bernstein
    May 27, 2007 at 11:07 pm
    May 27, 2007 at 11:07 pm
  • file: $CPAN/authors/id/T/TI/TIMB/GoferTransport-http-1.00.tar.gz size: 8955 bytes md5: b679e4eeb9acbd019f8eeaa6a1cb81d8 Client-side and server-side http transport modules for DBD::Gofer. For more ...
    Tim BunceTim Bunce
    May 14, 2007 at 10:42 am
    May 14, 2007 at 10:42 am
  • file: $CPAN/authors/id/T/TI/TIMB/DBI-1.56.tar.gz size: 482563 bytes md5: 5471f8a968943dae1971d55bbfafc844 =head2 Changes in DBI 1.56 (svn rev 9561), 13th May 2007 Fixed printf arg warnings thanks to ...
    Tim BunceTim Bunce
    May 14, 2007 at 10:35 am
    May 14, 2007 at 10:35 am
  • Hi, The deadline to submit Hackathon proposals for this year's YAPC Europe in Vienna is just around the corner. Please do not forget to submit your proposals by Sunday, 13th May 2007. Information on ...
    Michael KröllMichael Kröll
    May 8, 2007 at 9:42 am
    May 8, 2007 at 9:42 am
  • file: $CPAN/authors/id/T/TI/TIMB/DBI-1.55.tar.gz size: 477884 bytes md5: 0a6eda0cb7dbd8e7bc49b03dbac7c3b2 =head2 Changes in DBI 1.55 (svn rev 9504), 4th May 2007 Fixed set_err() so HandleSetErr hook ...
    Tim BunceTim Bunce
    May 4, 2007 at 9:07 pm
    May 4, 2007 at 9:07 pm
Group Navigation
period‹ prev | May 2007 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions37
posts135
users57
websitedbi.perl.org

57 users for May 2007

Tim Bunce: 14 posts John Scoles: 13 posts CAMPBELL, BRIAN D \(BRIAN\): 8 posts Ramesh thangamani: 7 posts Jonathan Leffler: 6 posts Ron Savage: 5 posts Michael Peppler: 4 posts Alexander Foken: 4 posts Andon Tschauschev: 4 posts H.Merijn Brand: 4 posts Rodneyr: 3 posts Fi Dot: 3 posts Martin Gainty: 3 posts Shane Neubauer: 3 posts Cosimo1953: 2 posts Jeffrey Seger: 2 posts Jenda Krynicky: 2 posts Jordan Mueller: 2 posts Loo, Peter # PHX: 2 posts Martin Evans: 2 posts
show more
Archives