Re: DBI Issue With iSeries AS400 Returning Null Columns on 64-bit Linux

2012-09-07 Thread Martin J. Evans
involved to describe here. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBI Issue With iSeries AS400 Returning Null Columns on 64-bit Linux

2012-09-07 Thread Martin J. Evans
the easiest looking change but you'll find a few more places where SQLLEN/SQLULEN are used. Thanks, Keith I'll write your rt off now unless you object. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com On Fri, Sep 7, 2012 at 10:10 AM, Martin J. Evans martin.ev...@easysoft.comwrote

DBD::ODBC 1.40_2 development release

2012-09-06 Thread Martin J. Evans
monks for providing an example. [CHANGE IN BEHAVIOUR] If you attempt to bind an rv without amagic DBD::ODBC will now croak - related to rt 78838. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Error running make on AIX 5.3

2012-08-16 Thread Martin J. Evans
On 15/08/12 18:38, Harry Jamieson wrote: On 8/15/2012 10:33 AM, Harry Jamieson wrote: On 8/15/2012 10:24 AM, Martin J. Evans wrote: On 15/08/12 17:20, Harry Jamieson wrote: On 8/15/2012 10:13 AM, Martin J. Evans wrote: On 15/08/12 17:12, Martin J. Evans wrote: On 15/08/12 17:05, Harry

Re: Are you using TAF support in DBD::Oracle?

2012-08-16 Thread Martin J. Evans
On 10/08/12 09:58, Martin J. Evans wrote: On 07/08/12 10:32, Martin J. Evans wrote: Hi, I didn't implement TAF support in DBD::Oracle but I want to use it. I've just started using it and have had to fix some problems with memory corruption, memory leaks and issues with scalars going out

Re: Error running make on AIX 5.3

2012-08-15 Thread Martin J. Evans
compiler, and cc_r is linked to it. Thanks for all of your help so far. Harry Jamieson I thought you were using an old Perl and I don't think pod supported =encoding since day 1. I could be wrong. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Help please with DBD::ODBC on SUSE-Linux

2012-08-15 Thread Martin J. Evans
have gdb (or install it) do: gdb /usr/bin/perl replace with which output and at the prompt do: run -Iblib/lib -Iblib/arch t/03dbatt.t when it crashes type bt for a back trace and post it. Even if we cannot get a clue from this it will be useful if you go to teradata. Martin -- Martin J

Re: Error running make on AIX 5.3

2012-08-15 Thread Martin J. Evans
On 15/08/12 16:45, Harry Jamieson wrote: make test output file. That is a lot of failures. What does prove -vb t/06attrs output? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Error running make on AIX 5.3

2012-08-15 Thread Martin J. Evans
On 15/08/12 17:05, Harry Jamieson wrote: On 8/15/2012 9:55 AM, Martin J. Evans wrote: On 15/08/12 16:45, Harry Jamieson wrote: make test output file. That is a lot of failures. What does prove -vb t/06attrs output? Martin # /usr/opt/perl5/bin/prove -vb t/06attrs.t t/06attrs1..148 ok

Re: Error running make on AIX 5.3

2012-08-15 Thread Martin J. Evans
On 15/08/12 17:12, Martin J. Evans wrote: On 15/08/12 17:05, Harry Jamieson wrote: On 8/15/2012 9:55 AM, Martin J. Evans wrote: On 15/08/12 16:45, Harry Jamieson wrote: make test output file. That is a lot of failures. What does prove -vb t/06attrs output? Martin # /usr/opt/perl5/bin

Re: Error running make on AIX 5.3

2012-08-15 Thread Martin J. Evans
On 15/08/12 17:20, Harry Jamieson wrote: On 8/15/2012 10:13 AM, Martin J. Evans wrote: On 15/08/12 17:12, Martin J. Evans wrote: On 15/08/12 17:05, Harry Jamieson wrote: On 8/15/2012 9:55 AM, Martin J. Evans wrote: On 15/08/12 16:45, Harry Jamieson wrote: make test output file

Re: Help please with DBD::ODBC on SUSE-Linux

2012-08-15 Thread Martin J. Evans
On 15/08/2012 18:25, Jeff Tate wrote: Step 1) added ODBC trace information to odbcinst.ini (made my own copy (system file)) and change $ODBCINST to address NO output produced in trace file Step 2) running test under gdb Linux:puTest gdb `which perl` GNU gdb (GDB) SUSE

Re: Help please with DBD::ODBC on SUSE-Linux

2012-08-15 Thread Martin J. Evans
On 15/08/2012 18:25, Jeff Tate wrote: Step 1) added ODBC trace information to odbcinst.ini (made my own copy (system file)) and change $ODBCINST to address NO output produced in trace file That suggests you are NOT using unixODBC as the ODBC driver manager. Therefore this

Re: DBD::ODBC column_info

2012-08-09 Thread Martin J. Evans
handle returned from column_info. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Problems installing DBI on AIX5

2012-08-03 Thread Martin J. Evans
Makefile.PL, make and show us the output? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Problems installing DBI on AIX5

2012-08-03 Thread Martin J. Evans
on right now but xlc must support -c (it means compile but do not link). What does perl -V output? Do you really have a full AIX compiler installed or is this one of those silly mini compilers. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Problems installing DBI on AIX5

2012-08-03 Thread Martin J. Evans
and it costs money usually (but I could be out of date on that). If you cannot spend money or cannot get xlc you can always build your own Perl with perlbrew and install gcc for the compiler but you cannot mix gcc compiled stuff with xlc compiled stuff (which your current Perl is). Martin -- Martin J

Re: Problems installing DBI on AIX5

2012-08-03 Thread Martin J. Evans
the right xlc/cc is on your path first. See the mail from John R Pierce. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Connecting to SQL Server on Windows

2012-07-25 Thread Martin J. Evans
or defined in the wrong place - see odbcinst -j output and then check odbinst.ini. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New 1.39 release of DBD::ODBC

2012-07-07 Thread Martin J. Evans
I've just sent to the CPAN the 1.39 release of DBD::ODBC. This contains some bug fixes, one major enhancement to support TAF and one change in behaviour you should note. =head2 Changes in DBD::ODBC 1.39 July 7 2012 [BUG FIXES] Manifest mentioned 2 files in examples which do not exist - they

Re: Connecting to SQL Server on Windows

2012-06-29 Thread Martin J. Evans
DRIVER= in uppercase as DBD::ODBC has a problem identifying the DRIVER in the connection string on unicode builds if it is mixed or lower case (basically the XS code does not case fold on unicode strings). Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Connecting to SQL Server on Windows

2012-06-28 Thread Martin J. Evans
On 28/06/2012 17:07, Shrenuj Bansal wrote: I am using a perl script to try to connect to SQL Server on Windows. I believe I have DBI v1.607 and DBD::ODBC v1.25. I am able to connect to the server when I set up a data source using the ODBC Data Source Administrator on Windows. However, when I

Re: Connecting to SQL Server on Windows

2012-06-28 Thread Martin J. Evans
On 28/06/2012 21:03, Shrenuj Bansal wrote: On Thursday, June 28, 2012 11:50:50 AM UTC-6, quot;Martin J. Evansquot; wrote: On 28/06/2012 17:07, Shrenuj Bansal wrote: I am using a perl script to try to connect to SQL Server on Windows. I believe I have DBI v1.607 and DBD::ODBC v1.25. I am able

Re: DBD::Oracle RTs a summary and request for help

2012-06-27 Thread Martin J. Evans
On 27/06/12 09:01, Martin Hall wrote: On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access

Re: DBD::Oracle RTs a summary and request for help

2012-06-26 Thread Martin J. Evans
On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone

New development release of DBD::ODBC 1.38_3

2012-06-25 Thread Martin J. Evans
I have uploaded DBD::ODBC 1.38_3 to CPAN. As no new issues have been reported my intention is to make this a full 1.39 in the next week or so. There is nothing too exciting in 1.38_3 but the previous 1.38 development releases contain some interesting enhancements and changes. Please let me

DBD::Oracle RTs a summary and request for help

2012-06-24 Thread Martin J. Evans
Yanick and I have been trying to keep on top of DBD::Oracle RTs but the time I have to do this is short. There are also some issues I don't feel in a position to investigate. There are 35 outstanding RTs which is a significant improvement on 2 years ago when it was over 50 but that is still a

Re: LongReadLen not working with Pervasive

2012-06-22 Thread Martin J. Evans
::ODBC so if you are not in that position substitute 15 for DBD. BTW, DBI has an attribute to ChopBlanks for you for char columns. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::ODBC and ODBC SQL Servre driver

2012-06-19 Thread Martin J. Evans
or downgrade DBD::ODBC to pre 1.26_1. Of course if you downgrade DBD::ODBC you will lose some enhancements and bug fixes. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Fwd: Re: DBD::ODBC and ODBC SQL Servre driver

2012-06-18 Thread Martin J. Evans
Oops, forgot to post this to the list. Martin ---BeginMessage--- On 18/06/2012 21:51, Shrenuj Bansal wrote: Hi, I am currently using the trial version of the Easysoft ODBC-SQL Server driver. I need to be able to connect from Perl to SQL Server using a Linux machine and am currently using

Re: DBD::ODBC and ODBC SQL Servre driver

2012-06-18 Thread Martin J. Evans
On 18/06/2012 23:23, Shrenuj Bansal wrote: On Monday, June 18, 2012 3:54:45 PM UTC-6,quot;Martin J. Evansquot; wrote: Oops, forgot to post this to the list. Martin Well, whenever I run the example script given to connect to the SQL Server DB, the compiler gives me an error on the use DBI

Re: FW: :ODBC {ChopBlanks=1} option issue

2012-06-01 Thread Martin J. Evans
, Madhunapanthula_Naaga Sent: Friday, June 01, 2012 5:02 PM To: 'Martin J. Evans' Subject: DBD::ODBC {ChopBlanks=1} option issue Hello Martin, I hope you are doing well. ChopBlanks option, doesn't seem to work with DBD::ODBC. Can you please help? I checked out latest version of DBD::ODBC from svn.perl.org

New DBD::ODBC 1.38_2 development release

2012-05-24 Thread Martin J. Evans
to fixes above. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Changes in binding columns in DBD::ODBC

2012-05-20 Thread Martin J. Evans
As a result of a thread in the dvi-dev list I am proposing a change to the way DBD::ODBC binds columns. The changes are: 1. Columns described as SQL_INTEGER will be bound as SQL_C_LONG and hence retrieved as a C long and the bound scalar will be set using sv_setiv. This means the bound

Re: DBD::ODBC fetch is returning string for integer

2012-05-19 Thread Martin J. Evans
On 19/05/2012 13:33, pe...@vanroose.be wrote: DBD::ODBC is returning strings for integers. This results in incorrect values for bit wise operators. (for ex:- $e='16'; $f = '32' print $e $f returns 12 instead of zero ). Is there a setting that can help us return integers as 'integers'. It's

Re: Unable to make DBD::Oracle 1.44

2012-04-26 Thread Martin J. Evans
On 26/04/2012 19:32, John Adams wrote: Hi, folks, I'm having issues with making DBD::Oracle. Some information: Oracle version 11.1.0.7 DBI version 1.52 Perl version 5.8.8 OS version RHEL 5.8 The odd wrinkle in this is that most of Oracle on this machine is installed in an

Re: Unable to make DBD::Oracle 1.44

2012-04-26 Thread Martin J. Evans
On 26/04/2012 19:53, John Adams wrote: Hi, Martin, On Thu, Apr 26, 2012 at 1:39 PM, Martin J. Evans martin.ev...@easysoft.com wrote: When I build against Oracle Instant Client I download the instant client from Oracle, unzip it in /home/martin. Then I set LD_LIBRARY_PATH=/home/martin

Re: Error I've not seen before from oracle DBD

2012-03-30 Thread Martin J. Evans
cannot put that exact :xxx more than once in the SQL (you can with DBD::Oracle). Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: It's a bad day here...

2012-03-30 Thread Martin J. Evans
is concerned the statement handle is not active. Perhaps setting ora_verbose before your code above and turning it off afterwards would help us see what is really happening. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD: postgres fail

2012-03-20 Thread Martin J. Evans
and if this is the most recent Postgres driver report it on rt. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD:Oracle compilation failure

2012-03-20 Thread Martin J. Evans
or Cygwin - does that file exist? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: [DBD::Oracle] ORA-02005 on array insert

2012-03-20 Thread Martin J. Evans
) and Oracle Instant Client 11.2. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

DBD::ODBC 1.35 released

2012-03-06 Thread Martin J. Evans
I've just uploaded DBD::ODBC 1.35 to CPAN. This is the culmination of 7 development releases in the 1.34 chain and is a significant release containing a lot of changes and enhancements. As always I would like to thank everyone who has helped and especially CPAN testers. The full list of

New DBD::ODBC 1.34_5 development release

2012-02-17 Thread Martin J. Evans
attributes odbc_batch_size and odbc_disable_array_operations. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle not utf8 encoding PL/SQL out values

2012-02-09 Thread Martin J. Evans
On 07/02/12 09:28, Martin J. Evans wrote: On 07/02/12 04:56, Steve Baldwin wrote: #!/usr/bin/perl -w use strict; use warnings; use DBI; use Encode; sub main { my $dbh = DBI-connect( 'dbi:Oracle:', 'usr/pwd@instance', '', { PrintError = 0, AutoCommit = 0, RaiseError = 1, }, ); print {*STDERR

Re: DBD::Oracle not utf8 encoding PL/SQL out values

2012-02-07 Thread Martin J. Evans
be on. BTW, that code originates from a patch in April 2002 so it is OLD code - http://www.mail-archive.com/dbi-users@perl.org/msg10046.html You should probably rt this at rt.cpan.org. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle not utf8 encoding PL/SQL out values

2012-02-07 Thread Martin J. Evans
On 07/02/2012 19:42, Steve Baldwin wrote: Thanks a lot Martin. Created https://rt.cpan.org/Public/Bug/Display.html?id=74753. Cheers, Steve Could you post on the rt if you apply the patch and it works for you. Thanks Martin On Tue, Feb 7, 2012 at 8:28 PM, Martin J. Evans martin.ev

Re: New DBD::ODBC 1.34_3 development release

2012-02-05 Thread Martin J. Evans
On 04/02/2012 20:51, Tim Bunce wrote: On Fri, Feb 03, 2012 at 08:51:10PM +, Martin J. Evans wrote: You should also be aware that calling odbc_getdiag* will clear DBI's err, errstr and state so if you want DBI's methods to return something meaningful you may need to call them first - I'm

Re: Multiple Result Sets In A select Statement In Sybase

2012-02-03 Thread Martin J. Evans
-- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Multiple Result Sets In A select Statement In Sybase

2012-02-03 Thread Martin J. Evans
Melillo joseph.meli...@moodys.com So you are using DBD::Sybase - i.e., the Sybase in 'dbi:Sybase:' tells DBI to load DBD::Sybase. As a result, all the Sybase specific stuff will be documented in DBD::Sybase. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle on OSX Lion (64-bit)

2012-01-25 Thread Martin J. Evans
remember it was Oracle 10gr2 so, yes 10.2.x.x was the problem. I don't believe 10.2 was certified on Lion and I don't think that situation has changed. I have updated the readme. Thanks. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

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

2012-01-23 Thread Martin J. Evans
version is so different from the one you are using (code-wise) I doubt even if you found a bug which was still present in the newest release you'd persuade anyone to also fix it in 1.16. Perhaps you need to explain why you've asked the question. Martin -- Martin J. Evans Easysoft Limited http

Re: Upgrading to Ubuntu 11.10

2012-01-15 Thread Martin J. Evans
On 13/01/2012 17:37, Rafael Muneton wrote: Hello everyone: I have an application where i use Perl, with Apache and MySQL on Ubuntu 11.04 and everything is working OK. But in the last few days I'm trying to upgrade my Ubuntu to the 11.10 Version and I cannot connect to the database, I'm getting

Re: More of an oracle question than dbi...

2012-01-11 Thread Martin J. Evans
instead of just the SQL. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Problem with Oracle collections/objects

2011-12-13 Thread Martin J. Evans
. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com From: byter...@hotmail.com To: martin.ev...@easysoft.com; dbi-...@perl.org CC: dbi-users@perl.org Subject: RE: Problem with Oracle collections/objects Date: Tue, 13 Dec 2011 06:42:12 -0500 Well I am able to recreate it which

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-12 Thread Martin J. Evans
appeared to work so DBD::Oracle was ok at that point. The error you are getting looks like it resulted from running something else. Is your LD_LIBRARY_PATH still set to what it was when you built DBD::Oracle? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Development release of DBD::ODBC with native execute_for_fetch support

2011-12-11 Thread Martin J. Evans
Hi, I have just uploaded DBD::ODBC 1.34_1 to CPAN. This release adds very experimental support for a native execute_for_fetch method to DBD::ODBC which means you can do multiple row inserts/updates/deletes much quicker than using DBI's default execute_for_fetch (so long as you are using

Problem with Oracle collections/objects

2011-12-09 Thread Martin J. Evans
-execute; my $r = $s-fetchall_arrayref; return $r; } Thanks Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New DBD::ODBC 1.33 release

2011-12-01 Thread Martin J. Evans
I've just uploaded DBD::ODBC 1.33 to CPAN. This release contains no new changes since the 1.32_5 development release but is the official release for all the 1.32 dev series. The complete changes can be found below. The main thrust has been Unicode improvements. The most significant

Re: DBD::Oracle on RHEL5 [2.6.18-164.el5 albiet not really relevant] x86_64

2011-11-22 Thread Martin J. Evans
and twiddles for years of Oracle changes. I guess we need to edit that message in some way now to avoid it. client_version=11.2 DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\11.2.0.2\ -DORA_OCI_102 -DORA_OCI_112 Thanks for taking the time to report it. Martin -- Martin J. Evans

Re: Teradata using DBD::ODBC

2011-11-22 Thread Martin J. Evans
On 22/11/2011 08:48, Martin J. Evans wrote: On 21/11/11 18:51, Yang, Longjiang wrote: Hi, I use DBD::ODBC to connect to Teradata. I need to get column data type back. when using $sth-{TYPE}. I got IDs not in $dbh-type_info_all. It appears to happen to only CHAR and VARCHAR types. Does anyone

Re: Teradata using DBD::ODBC

2011-11-22 Thread Martin J. Evans
On 22/11/2011 18:57, Martin J. Evans wrote: On 22/11/2011 08:48, Martin J. Evans wrote: On 21/11/11 18:51, Yang, Longjiang wrote: Hi, I use DBD::ODBC to connect to Teradata. I need to get column data type back. when using $sth-{TYPE}. I got IDs not in $dbh-type_info_all. It appears

Re: Teradata using DBD::ODBC

2011-11-22 Thread Martin J. Evans
On 22/11/2011 19:02, Martin J. Evans wrote: On 22/11/2011 18:57, Martin J. Evans wrote: On 22/11/2011 08:48, Martin J. Evans wrote: On 21/11/11 18:51, Yang, Longjiang wrote: Hi, I use DBD::ODBC to connect to Teradata. I need to get column data type back. when using $sth-{TYPE}. I got IDs

New 1.32_3 dev release of DBD::ODBC - some Unicode changes

2011-11-15 Thread Martin J. Evans
J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Martin J. Evans
ended up patching DBD::Oracle to do what I needed. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Quoting Tim Bunce (tim.bu...@pobox.com): I'm late to this thread (it went into a different mail folder). Lyle, have you see the Oracle::OCI module? It provides deep

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Martin J. Evans
it another go. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread Martin J. Evans
don't think there is a way right now. You'd need to add an attribute or 2 on the $dbh to return them. It is fairly easy and if you've done some XS already I doubt you'd have much problem. Just do a search for an attribute like ora_parse_error_offset. Martin -- Martin J. Evans Easysoft Limited

Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread Martin J. Evans
++ libraries. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Hope this helps Cheers John Date: Thu, 27 Oct 2011 09:48:54 -0400 From: bro...@deseret.com To: byter...@hotmail.com CC: dbi-users@perl.org Subject: Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh Yes, I

New development release of DBD::ODBC (1.32_2)

2011-10-22 Thread Martin J. Evans
I have just uploaded 1.32_2 development release of DBD::ODBC. This contains one rather nice enhancement for Windows users which adds the new odbc_driver_complete attribute described as below. Any testing will be greatly appreciated. The full changes since 1.31 are: =head2 Changes in DBD::ODBC

Re: DBD::Oracle 1.32 Compile Errors : Oracle.c: In function ‘XS_DBD__Oracle__db_ora_db_startup’ and more....help?

2011-10-21 Thread Martin J. Evans
DBD::Oracle. Please RT this at rt.cpan.org. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::ODBC fails, SQL*Plus works

2011-10-07 Thread Martin J. Evans
Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Undefined $DBI::errstr on error using MySql on Windows-7-x64

2011-10-04 Thread Martin J. Evans
at: https://rt.cpan.org/Public/Bug/Display.html?id=71047 Also posted to StackOverflow: http://stackoverflow.com/questions/7432944/undefined-dbierrstr-using-dbi-perl-and-mysql-on-windows-7-x64 Thanks in advance, Tadhg Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Undefined $DBI::errstr on error using MySql on Windows-7-x64

2011-10-04 Thread Martin J. Evans
though the table does not exist. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com From: Martin J. Evansmartin.ev...@easysoft.com To: dbi-users@perl.org Sent: Tuesday, October 4, 2011 4:51 AM Subject: Re: Undefined $DBI::errstr on error using MySql

Re: Strange happenings in ODBC

2011-09-29 Thread Martin J. Evans
On 28/09/11 22:26, Martin J. Evans wrote: On 28/09/2011 22:10, Jeff Tate wrote: 1) the versions of DBI and ODBC are the same on Windows and AIX 2) the program is identical on Windows and AIX. I develop on Windows and move to AIX for production. The two output fragments are from an identical

Re: Strange happenings in ODBC

2011-09-28 Thread Martin J. Evans
On 28/09/2011 20:41, Jeff Tate wrote: I am developing an app that pulls data from a Teradata data-server through DBI, DBD::ODBC. It is developed on a Win32 platform, but targeted for an AXI platform. In debugging a difference between the two platforms (after rigorous code identity

Re: Strange happenings in ODBC

2011-09-28 Thread Martin J. Evans
? That is, reduce the problem to something we don't need inside knowledge to understand and even better into a reproducible problem (although I appreciate this can be difficult and I've not got teradata anyway). Martin -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com

Re: Strange happenings in ODBC

2011-09-28 Thread Martin J. Evans
of comparing the output in AIX and Windows - what column names exist in either output that differ from what you selected. Martin -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Wednesday, September 28, 2011 4:51 PM To: dbi-users@perl.org Cc: Jeff Tate Subject

Request for help collating unicode support in DBDs

2011-09-27 Thread Martin J. Evans
I am attempting to run through as many DBDs as possible producing a list of those that support Unicode, how they support it (driver flags and caveats etc) and any issues with it. So far I'm working my way through DBD::SQLite, DBD::CSV, DBD::ODBC, DBD::Oracle and DBD::Pg (because those are ones

Re: DBD::Pg closes connection unexpectedly

2011-09-04 Thread Martin J. Evans
On 04/09/2011 03:58, Mr. Puneet Kishor wrote: On Sep 3, 2011, at 9:46 PM, David E. Wheeler wrote: On Sep 3, 2011, at 7:27 PM, Mr. Puneet Kishor wrote: I am on Mac OS X Lion with Pg 9.0.x, Perl 5.14.1, and the latest iterations of DBI and DBD::Pg. My code is pretty straightforward my

Re: DBD ERROR: LOB refetch attempted for unsupported statement type

2011-09-03 Thread Martin J. Evans
On 03/09/2011 07:50, Shobha Deepthi V (sobv) wrote: Hi, I am calling a stored procedure that returns ref cursor from perl. But it fails with the following error, DBD::Oracle::st execute failed: ( DBD ERROR: LOB refetch attempted for unsupported statement type ) I searched for this

Re: DBD ODBC

2011-08-30 Thread Martin J. Evans
programs. 1/904 subtests failed. make: *** [test_dynamic] Error 255 Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD ODBC

2011-08-30 Thread Martin J. Evans
On 30/08/2011 13:05, Martin J. Evans wrote: On 23/08/11 17:12, Jason Lewis wrote: Checking if your kit is complete... Warning: the following files are missing in your kit: t/rt_68720.t Please inform the author. This is my fault and as soon as svn.perl.org and rt.perl.org are working again

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

2011-08-04 Thread Martin J. Evans
on this list, this question was first asked on stackoverflow at: http://stackoverflow.com/questions/6941197 I have provided and answer on stackoverflow and am awaiting a trace file. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Informix 2 test failures attempting to install AIX 5.3

2011-07-26 Thread Martin J. Evans
you with Informix itself but the maintainer might find it easier to diagnose the problem if you run prove -vb t/t32nulls and similarly on t61varchar as the output is more verbose. Martin snipped other info Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Help installing DBI

2011-07-17 Thread Martin J. Evans
On 16/07/2011 05:34, n...@kastle.org wrote: Hi, I want to interface my perl scripts with the MySQL dataBases. I'm running an Ubuntu Web Server - How can I test to see if DBI is installed and, if it's not, what's the process (or where can I find/read) to install both (if I

Re: t/20SqlServer.t hangs on 61. Must break.

2011-07-13 Thread Martin J. Evans
but that is just a guess. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: is it possible to use two sth from same dbh at the same time ?

2011-07-12 Thread Martin J. Evans
are using and then sometimes it depends on which driver you are using under that DBD. You'll need to tell us which DBD (and possibly driver) you are using. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: is it possible to use two sth from same dbh at the same time ?

2011-07-12 Thread Martin J. Evans
what is in the document referenced above. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Using MS Access 2007 with DBI

2011-06-29 Thread Martin J. Evans
My email client had a load of problems with your non-text email so I've not quoted it. I presume you are using DBD::ODBC? If not, I don't know. Could you provide a trace: set DBI_TRACE=15=x.log then run program and x.log should contain trace. Don't post it here, it is probably too long. If

DBD::ODBC 1.31 released

2011-06-23 Thread Martin J. Evans
I have just uploaded DBD::ODBC 1.31 to pause. This is the culmination of 7 development releases and I thought it was time to do an official release. Due to personal issues I am unlikely to be doing another update to DBD::ODBC in the near future but if you find issues please report them on RT

Re: can $dbh-do take a prepared statement handle?

2011-06-17 Thread Martin J. Evans
the $s statement handle was stringified into something like DBI::st=HASH(0x8e7e2c0) Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Handling DATE Field in DBD:::Teradata.pm

2011-06-10 Thread Martin J. Evans
me on this? Thanks Pariksheet I don't use Teradata so I could be way off here. Perhaps that is the default format for dates in your database. Perhaps you can cast it with a format - select cast(date as date format '-MM-DD') - something like that. Martin -- Martin J. Evans Easysoft Limited

Re: DBD::Sybase and DBI-get_info()

2011-06-04 Thread Martin J. Evans
On 03/06/2011 20:58, eric.b...@barclayscapital.com wrote: Thanks, John. If anyone can comment with authority on the lack of intraspection capabilities in DBD::Sybase, that'd be helpful. I looked through the code as well, and didn't find anything to say one way or another. Get_info() appears

Re: Assigning private attributes to DBI database handles

2011-06-03 Thread Martin J. Evans
On 03/06/2011 19:30, eric.b...@barclayscapital.com wrote: I'd like to set some private attributes on my db handles so that later I can interrogate them to get that information. We are doing this with statement handles, but not DB handles, and it simply doesn't seem to be working in any case.

Re: DBD::ODBC Segfaults on SET TEXTSIZE and TRUNCATE TABLE

2011-06-03 Thread Martin J. Evans
, martin.ev...@easysoft.com (Martin J. Evans) wrote: On 17/05/2011 14:54, eric.b...@barclayscapital.com wrote: Just a quick update: We switched back to using the FreeTDS driver under DBD::ODBC with the unixODBC ODBC manager on Linux and the segfault problem went away. That seems to suggest to me

Re: (Fwd) Question about DBD::Oracle

2011-05-24 Thread Martin J. Evans
and allow embedded \0 bytes. Oracle clients using OCI 9.2 do not strip trailing spaces and allow embedded \0 bytes. This is the normal default placeholder type. Yours faithfully, Kiyoshi Sumiya, - End forwarded message - -- Martin J. Evans

Re: What's the relationship between LongReadLen and TEXTSIZE?

2011-05-19 Thread Martin J. Evans
) whereas DBD::Sybase is for Sybase/MS SQL Server which both support TEXTSIZE. If TEXTSIZE is 80 then you'll always have to set LongReadLen to get all the data without truncating it. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com -Original Message- From: Martin J

Re: Update is not working properly with Perl DBI

2011-05-19 Thread Martin J. Evans
were processed, you just commit all the updates. }else { sleep(5); } } Did you intend to sleep for 10s when there are no ids or 5? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: What's the relationship between LongReadLen and TEXTSIZE?

2011-05-18 Thread Martin J. Evans
standalone example which creates a table and demonstrates the issue I will look at it. Eric Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

DBD::ODBC 1.30_4 development release

2011-05-18 Thread Martin J. Evans
on bound parameter problems. * Added new FAQ entry for Firebird * Removed some unused variables and added some missing function prototypes Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

<    1   2   3   4   5   6   >