Re: make test failed for perl module DBD-Oracle-1.70

question is there. Can you please guide how to proceed on this? Thanks Regards, Martin -- Martin J. Evans Wetherby, UK

New development release of DBD::ODBC 1.49_3

I've just uploaded DBD::ODBC 1.49_3 to the CPAN. Please test it especially if you've always wanted to use MS SQL Server Query Notification as it should now support it. Changes since last full release are: 1.49_3 2014-05-01 [CHANGE IN BEHAVIOUR] As warned years ago, this release removes

Re: Probably simple, stupid question about Oracle TAF and DBI

it up and call the callback. As such Oracle docs will be your friend. Try it and see and report back. Up to this point I only know of myself as having used TAF with DBD::Oracle. There may be an article on the Easysoft web site. Martin -- Martin J. Evans Wetherby, UK

Re: (Fwd) Issue :DBD::Oracle installation

On 04/06/14 12:44, tim.bu...@pobox.com wrote: - Forwarded message from Ranjitha ranji...@infosys.com - Date: Wed, 4 Jun 2014 11:05:34 + From: Ranjitha ranji...@infosys.com To: tim.bu...@pobox.com tim.bu...@pobox.com, t...@cpan.org t...@cpan.org Subject: Issue :DBD::Oracle

Re: (Fwd) Issue :DBD::Oracle installation

successfully run sqlplus - at best it will default to oracle 8. Martin -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Friday, June 06, 2014 1:44 PM To: Ranjitha; dbi-users@perl.org Subject: Re: (Fwd) Issue :DBD::Oracle installation On 04/06/14 12:44, tim.bu

Re: DBD::Informix

On 09/07/14 15:58, Helmut wrote: Hi all, i have problems building DBD::Informix. Running Makefile.pl ends up with .. /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen' /opt/IBM/informix/lib/esql/libifos.so: undefined reference to `crypt' /opt/IBM/informix/lib/libifasf.so:

New 1.50 release of DBD::ODBC

I've just uploaded DBD::ODBC 1.50 to the CPAN. This is the culmination of a series of 4 development releases in the 1.49 series. There are a number of bug fixes, enhancements, deprecated features and most importantly some changes in behaviour. See below for a list of changes. 1.50 2014-07-25

Re: Escaping placeholders

easier if they could just say 'does this DBD do X' and maybe 'how do I make it do X'. Martin -- Martin J. Evans Wetherby, UK On 2014-12-21 7:17 AM, Greg Sabino Mullane (the tenth man) wrote: Tim Bunce wrote: For code not using DBIx::Class the pg_placeholder_dollaronly attribute might work

Re: Statement Handle Attribute Precision

On 22/01/15 15:29, Josh Nijenhuis wrote: old docs from dbi = 1.39 i believe The PRECISION attribute contains a reference to an array of integer values that represent the defined length or size of the columns in the SQL statement. There are two general ways in which the precision of a

Re: DBD::ODBC Destroy bug?

On 24/03/15 15:45, Joel Plotkin wrote: 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 with 1.50_4) The error doesn't occur in the 1.23

Re: DBD::ODBC Destroy bug?

On Tue, Mar 24, 2015 at 12:24 PM, Martin J. Evans martin.ev...@easysoft.com mailto:martin.ev...@easysoft.com wrote: On 24/03/15 15:45, Joel Plotkin wrote: Hi, I have recently ported a large (1.4M line) perl application from: Centos 6.6 DBI version 1.6.09

Re: DBD::ODBC Destroy bug?

On 25/03/15 16:29, Joel Plotkin wrote: Hi, Are you running under Windows or Linux? We don't see the issue under ActiveState Perl- just under Linux/Centos. Linux Ubuntu 12.04.5 LTS Also, if it matters, we're running FreeTDS and UnixODBC. I am also running unixODBC. unixODBC.x86_64

Re: DBD::ODBC Destroy bug?

On 31/03/15 06:04, Joel Plotkin wrote: Hi, I've attached the sample test8.pl http://test8.pl script (smallest one possible that creates the problem) and a trace file at level 15. Thanks for any insight, Joel -dbd_st_execute(ac3cb0)=-1 - execute= -1 at test8.pl line 74 via at

Re: DBD::ODBC Destroy bug?

log so I'm going to suggest you've updated or changed your freeTDS driver and this one is broken. Martin On Tue, Mar 31, 2015 at 4:23 AM, Martin J. Evans martin.ev...@easysoft.com mailto:martin.ev...@easysoft.com wrote: On 31/03/15 06:04, Joel Plotkin wrote: Hi, I've

Re: Help with using Triggers MySql/Innodb

On 26/02/15 14:42, david wrote: 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 MySql database on Centos 6. I use the InnoDB database. I

Re: Memory not being freed with DBD::ODBC

On 20/04/15 17:54, Mike Martin wrote: I have the following script (extremley simplified) foreach my $key (sort {$a=$b} keys %run){ my $inp; $inp=$dbh-selectall_arrayref(select id, [description] from Kaonix_import_base where idint between ? and ? ,undef,$run{$key}-[0], $run{$key}-[1]) ;

Re: dbi selectall_hashref drops results

On 15/05/15 15:56, Kyle A. Hamilton wrote: I ran into an issue where dbi’s selectall_hashref will drop results returned from the database. If I change the query to count the number of results returned, it returns 96, but I am missing some records that I get when I manually query the database. If

Re: Issue with DBD::ODBC (SQLServer) and bcp

Just sounds like a locking issue to me. How do you connect to your SQL Server db via Perl and do you disable autocommit or start a transaction? Is this a known issue - not given the information provided unless the above. Martin -- Martin J. Evans Wetherby, UK

New DBD::ODBC 1.52 release

I have just uploaded DBD::ODBC 1.52 to the CPAN. Thanks to everyone who reported issues and in particular to Greg for his Pull Request from the PR challenge and to Neil for running it. If you are not part of the CPAN pull request challenge I believe you can still join - see

Re: help with odd DBI perpare/execute errors

On 03/06/15 14:06, William Bulley wrote: Environment Perl script trying to query Oracle 11g database: FreeBSD 9.3-STABLE DBI 1.633 oracle8-client 0.2.0 DBD::Oracle 1.19 I have no trouble connecting with the Oracle database. And I do recover data when I use the temporary

Re: help with odd DBI perpare/execute errors

On 03/06/15 14:38, William Bulley wrote: According to Martin J. Evans boh...@ntlworld.com on Wed, 06/03/15 at 09:15: So, when this fails, what is the value of $value. I just ran it again. The value is 547. Sounds ok but the error is invalid string ORA-0911 You tried to execute a SQL

Re: help with odd DBI perpare/execute errors

On 03/06/15 17:12, Bruce Johnson wrote: On Jun 3, 2015, at 7:19 AM, William Bulley w...@umich.edu wrote: According to Bruce Johnson john...@pharmacy.arizona.edu on Wed, 06/03/15 at 10:10: Make sure your original $query is delimited by double quotes, not single. I've tried

Re: help with odd DBI perpare/execute errors

On 03/06/15 14:06, William Bulley wrote: Environment Perl script trying to query Oracle 11g database: FreeBSD 9.3-STABLE DBI 1.633 oracle8-client 0.2.0 DBD::Oracle 1.19 It seems I missed this ^ A 9 year old DBD::Oracle. I can well believe the preparse code has changed

Re: MS access

On 30/10/2015 13:21, Ismail Chamseddine wrote: 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 Please try and help us help you and post more information.

Re: MS access

On 02/11/15 07:51, Ismail Chamseddine wrote: I am using Active Perl 5.18.4 64 bit on Windows 7 64 bit The connect string code my $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb); database= C:\Users\User\Documents\Mydb.accdb'); On Fri, Oct 30, 2015 at 4:07 PM, Marti

new development release 1.53_1 of DBD::ODBC

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 this now means if you have an up to date DBI, you can use the normal return from the execute

Re: DBD::Oracle and RHEL Instant Client rpms

and sqlplus zips and unzip them then point DBD::Oracle at them by setting LD_LIBRARY_PATH. Did you download the sqlplus RPM (assuming there is one) as DBD::Oracle uses sqlplus during the install to work out what version of the Oracle client you have? Martin -- Martin J. Evans Wetherby, UK

Re: Help with DBD::Oracle install

ION=\"10.2.0.5\" -DORA_OCI_102 Oracle.c /usr/ucb/cc: language optional software package not installed *** Error code 1 make: Fatal error: Command failed for target `Oracle.o' You need to install a C compiler - the one your Perl was built with is most likely to work. Martin -- Martin J. Evans Wetherby, UK

Fwd: Re: Extra nulls inserted with binary data (DBD::ODBC on Win7)

--- Begin Message --- On 28/01/16 15:08, Jerrad Pierce wrote: Hello Martin, $DBI::VERSION = 1.634 $DBD::ODBC::VERSION = 1.52 It would also be useful to know the column type in your access DB. I'm updating a LONGBINARY column in a Jet 4 (MDB) database. Thanks Thank you I forgot, MS

Re: DBD for SQL Server

On 06/09/16 14:40, Rob Dixon wrote: Hey Tim I'm wondering why there is no DBD module for Microsoft SQL Server? Is it a technical impossibility, or is it just waiting to be written? Thank you, Rob Dixon Norfolk England Microsoft has aligned itself with ODBC in the past and has reaffirmed

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

reports before. I think it had something to do with the method used to connect to Oracle and if that method is chosen it captures SIGCHLD and maybe another signal as well. Martin -- Martin J. Evans Wetherby, UK

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

, 2017 5:17 AM, "Martin J. Evans" <boh...@ntlworld.com <mailto:boh...@ntlworld.com>> wrote: On 02-Mar-17 10:54 PM, Douglas Wilson wrote: DBD::SQLAnywhere seems to work ok for Sybase IQ, but if I first create a DBD:Oracle handle, the SQLAnywhere con

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

Re: MySQL IV vs PV

On 13/11/17 17:43, James Cloos wrote: Is there anything in a db handle or statement handle one use to know whether the running instance of DBD::MySQL will return integer columns as IV? I'm adding some code to a layer atop DBI which will force IV (via +=0), but want to avoid doing that were it

Re: DBD::ODBC and issues getting LongTruncOk / LongReadLen to take effect

On 05/04/18 12:24, Daniel Kasak wrote: Hi all. I'm writing a database utility that has to access IBM's "DashDB" and other DB2-variants. I have their latest ODBC driver, and I have simple queries working. However queries against their system catalog are not working - queries appear to be

Re: DBD::ODBC and issues getting LongTruncOk / LongReadLen to take effect

is to set MapXMLDescribe to -152 as that is SQL_SS_XML which I think may be the same as MS_SQLS_XML_TYPE and of so, that is already handled. See https://fossies.org/linux/DBD-ODBC/dbdimp.h which suggests MS_SQLS_XML_TYPE is -152. Martin -- Martin J. Evans Wetherby, UK The script I'm

DBD-Oracle 1.79 released to the CPAN

I have just uploaded DBD::Oracle 1.79 to the CPAN.   [BUG FIXES]   Fix Avoid GCC-ism so that HP-UX can compile (GH#92, Dean Hamstead)   Destroy envhp with last dbh (GH#93, GH#89, Dean Hamstead, CarstenGrohmann) Thanks to everyone who contributed. Martin -- Martin J. Evans Wetherby, UK

New release of DBD::ODBC 1.61

contributed. Martin -- Martin J. Evans Wetherby, UK

Re: Perl script excessively executing statement

ess you are using execute_array. The code you posted didn't look like it was. Martin -- Martin J. Evans Wetherby, UK

Re: DBD error

compiler to build DBD::Oracle that was used to build Perl. Did you build Perl or did you get it pre-built from a repository for AIX? If the latter then you need to use the same compiler as was used to build Perl. You are mixing 32 bit compiled code with 64 bit compiled code as it stands. Martin -- Martin J. Evans Wetherby, UK

<    1   2   3   4   5   6