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

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

New release of DBD::ODBC 1.61

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

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

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

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: 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: 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: 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: 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 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: 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: 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

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: 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

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: 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: 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

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: 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]) ;

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: 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: 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?

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 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: 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: 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: 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

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: 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:

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: 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

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: 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

Re: I have a weird issue with a script running under cron

On 17/02/14 18:50, Bruce Johnson wrote: On Feb 17, 2014, at 11:41 AM, Bruce Ferrell bferr...@baywinds.org wrote: Bruce, The error says your script is attempting to load /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so for DBD::Oracle. is that the correct path for that library? it looks

Re: Surprising DBD::Oracle error raised

On 04/02/14 19:36, David Nicol wrote: $price_sth-execute; my ($o_file_price) = $price_sth-fetchrow_array(); if ($price_sth-fetch) { $this-log_error('ERROR: scalar select returned second row at %s line %d', __FILE__, __LINE__); } I expected the fetch to return

Re: Surprising DBD::Oracle error raised

On 05/02/14 13:36, John Scoles wrote: Well isn't he is calling with the alias 'fetch' isn't he: if ($price_sth-fetch) { and he is calling it in I think scalar context $row = $s-fetch; so am I. my ($row) = $s-fetchrow_array; As far as I can see I did the same. vs if

Re: Surprising DBD::Oracle error raised

On 05/02/14 14:08, David Nicol wrote: On Wed, Feb 5, 2014 at 7:25 AM, Martin J. Evans martin.ev...@easysoft.com wrote: That is indeed interesting. When I run the following with DBD::ODBC to MS SQL Server: use strict; use warnings; use DBI; my $h = DBI-connect(); eval { $h-do(q/drop

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

On 31/01/14 16:21, Tim Bunce wrote: On Fri, Jan 31, 2014 at 09:11:28AM -0500, John Scoles wrote: A final note on this. Seems there was a very very long unknown bug in DBI which was only fix a few days ago wiht DB 1.6.31 If you mean Callbacks getting an inner handle, that wasn't a

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

will definitely look at any code which reproduces the problem. Sadly, I don't right now see any other way to go. Martin -- Martin J. Evans Wetherby, UK

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

Just so everyone knows, I pointed hhferreira here in the following thread on perl monks: https://perlmonks.org/?node_id=1071794 Martin On 24/01/14 10:29, hhferreira wrote: Hi Guys, Hope you can provide us some enlightenment! We have the following code which basically calls an oracle

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

On 24/01/14 10:29, hhferreira wrote: Hi Guys, Hope you can provide us some enlightenment! We have the following code which basically calls an oracle procedure passing as inputs 6 bind arrays (converted in ORA_VARCHAR2_TABLE elements) and one string: /my $sth = $self-prepare( q{/ /

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

On 24/01/14 12:26, hhferreira wrote: Hi, We have already tried using ora_maxarray_numentries and other similar attributes unsuccessfully. Martin found that immediately before the error the following message is written: {{ execute callback CODE(0xb832be8) being invoked However we have done

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

24, 2014 at 1:28 PM, Martin J. Evans martin.ev...@easysoft.com mailto:martin.ev...@easysoft.com wrote: On 24/01/14 12:26, hhferreira wrote: Hi, We have already tried using ora_maxarray_numentries and other similar attributes unsuccessfully. Martin found

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

way do let us know :-) Thanks for your hints! Best Regards, Hélder Hugo Ferreira On Fri, Jan 24, 2014 at 1:28 PM, Martin J. Evans martin.ev...@easysoft.com mailto:martin.ev...@easysoft.com wrote: On 24/01/14 12:26, hhferreira wrote: Hi, We have already tried using

Re: Table-Valued Parameters to MS SQL Server stored procedure

different and can point me at it I'll take a look). The traditional way around this is to use temporary tables. Martin -- Martin J. Evans Wetherby, UK

Re: DBI: selectrow_array() return first column when called in list context

perl -MDBI -le 'print $DBI::VERSION;' 1.609 Martin -- Martin J. Evans Wetherby, UK

DBD::ODBC 1.46_2 released - your really need to test this

not support schemas - even for a simply ping (which uses SQLTables)). Now we call SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support which modifies SQLTables call. [MISCELLANEOUS] Added test 45_unicode_varchar.t for MS SQL Server only so far. Martin -- Martin J. Evans Wetherby

Re: DBD::ODBC and Unicode

On 20/11/13 09:39, Michiel Beijen wrote: Hi, I ran into this issue with DBD::ODBC; I read Martin asked about feedback on the 1.46_1 devel release. I tested my code against both versions 1.43 and 1.46_1 an the results are the same. Thanks for this. It has raised questions that needed

Re: :ODBC 1.46_1 released - You REALLY need to test this release

On 17/11/2013 08:32, Meir Guttman wrote: Dear Martin -Original Message- From: Martin J. Evans [mailto:boh...@ntlworld.com] Sent: שבת 16 נובמבר 2013 12:34 To: dbi-users@perl.org; DBI Developers Mailing List; dbi-annou...@perl.org Subject: DBD::ODBC 1.46_1 released - You REALLY need

DBD::ODBC 1.46_1 released - You REALLY need to test this release

uses SQLTables)). Now we call SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support which modifies SQLTables call. [MISCELLANEOUS] Added test 45_unicode_varchar.t for MS SQL Server only so far. Martin -- Martin J. Evans Wetherby, UK

Re: DBD::ODBC fails after Execute immediate success with info

-- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::ODBC fails after Execute immediate success with info

On 06/11/13 12:36, Jan Holčapek wrote: Hi Martin, 3. now run your basic script and send me /tmp/unixodbc.log attached is the log file you've requested. Please let me know your findings, thanks! --Jan Hi Jan, Your log shows: [ODBC][7270][1383740710.126962][SQLExecDirect.c][240]

Re: DBD::ODBC fails after Execute immediate success with info

On 06/11/13 14:36, Jan Holčapek wrote: Hi Martin, On Wed, Nov 6, 2013 at 3:05 PM, Martin J. Evans boh...@ntlworld.com wrote: I believe this is a bug in your ODBC driver. I kind of expected that. I'll file a bugreport to Vertica Support. good, that was part of what I was hoping to achieve

Re: (Fwd) Problems with DBD::Oracle package: function plsql_errstr

convinient for later use; *plsql_errstr* only converts that array into a single string. Of course one should provide at least two additional parameters to new plsql_errstr function. Martin -- Martin J. Evans Wetherby, UK

DBD::ODBC 1.45 released

I've just uploaded DBD::ODBC 1.45 to the CPAN. As always I'd draw your attention to a few small changes in behaviour. The changes since 1.43 are listed below but I need to warn you about an upcoming change first. WARNING - PLEASE READ: = The next development cycle of DBD::ODBC will contain

Re: (Fwd) Can't use an undefined value as an ARRAY reference at /usr/local/lib/perl/5.14.2/DBI.pm

invalid column names. Notice the incompatible change. I vaguely recollect this change. Does 1.618 work for you? Can you find the code which called fetchall_arrayref and show us it as I don't use Koha. Martin -- Martin J. Evans Wetherby, UK

Re: DBD::Oracle installation on AIX

odbcinst -j on your machine to see how unixODBC was built. d) include a unixODBC trace - which by the way, the one you sent me was not a unixodbc trace - it was the start of the DBI trace. Martin -- Martin J. Evans Wetherby, UK *From:* Martin J. Evans boh...@ntlworld.com *To:* Nagendra Singh nagsu

Re: DBD::Oracle installation on AIX

is broken b) it was built with SQLLEN 4 bytes instead of 8 bytes Neither of (a) or (b) DBD::ODBC can do anything about and both would require you contacting vertica to get a fixed ODBC driver. Martin -- Martin J. Evans Wetherby, UK *From:* Martin J. Evans boh...@ntlworld.com *To:* Nagendra Singh

Re: DBD::Oracle installation on AIX

=x.log perl myprogram.pl Martin -- Martin J. Evans Wetherby, UK

Re: Trouble with DBI - bug or rewrite?

On 18/09/13 09:58, Michael Seaton wrote: Hi there, I and a colleague have been trying to install Koha (an integrated library system written in Perl) onto a server. While we've been mostly successful in installing Koha, we keep getting the following message whenever we try to log in: Can't use

Re: Trouble with DBI - bug or rewrite?

On 18/09/13 10:26, Martin J. Evans wrote: On 18/09/13 09:58, Michael Seaton wrote: Hi there, I and a colleague have been trying to install Koha (an integrated library system written in Perl) onto a server. While we've been mostly successful in installing Koha, we keep getting the following

Re: DBD::Oracle installation on AIX

://cpansearch.perl.org/src/PYTHIAN/DBD-Oracle-1.66/README.help.txt Martin -- Martin J. Evans Wetherby, UK

New DBD::ODBC 1.44_2 development release

Attribute Fetch broken. Thanks to Stephen Oberholtzer for finding and supplying patch. Fixed problem with attributes on bind_col not being sticky. You'll probably only see this if you are using fetchall_arrayref with a slice and setting TYPE or attributes in bind_col first. Martin -- Martin J

Re: odbc_lob_read chunk is short

anything I might need to send you a new version with slightly different logging. By all means nag me if I don't get back to you by tomorrow. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: odbc_lob_read chunk is short

On 06/09/13 09:18, Martin J. Evans wrote: On 05/09/13 20:28, Mike Grau wrote: Hello, I am completely new at this, but I am trying to read a BLOB in chunks via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and oracle-instantclient11.2-odbc-11.2. I can read an entire BLOB in one read

Re: odbc_lob_read chunk is short

On 06/09/2013 17:52, Martin J. Evans wrote: On 06/09/13 09:18, Martin J. Evans wrote: On 05/09/13 20:28, Mike Grau wrote: Hello, I am completely new at this, but I am trying to read a BLOB in chunks via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and oracle-instantclient11.2-odbc

Re: Error running make command for DBI1.51

. This is very old. /opt/Interwoven/TeamSite/iw-perl/lib/CORE/perl.h:380:24: error: sys/types.h: No such file or directory This is a serious problem - looks like whoever installed this Perl did not run the script to generate header files. Martin -- Martin J. Evans Wetherby, UK

Re: ODBC Driver failing?

sure long term fix. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: ODBC Driver failing?

TRAIN1 username password isql -v PROD1 username password as you didn't say which one you are using? If you get back with this info I'll help more. Martin -- Martin J. Evans Wetherby, UK

Re: ODBC Driver failing?

On 26/06/2013 18:42, Dan Bent wrote: I agree, and I've been trying to identify what changed yesterday morning. The database, Perl,and the program all reside on the same machine, so I think we can rule out network issues. As far as I know, the DBMS, Perl and ODBC infrastructure have been stable

Re: ODBC Driver failing?

of strace on HPUX and run it on the isql command to see what system calls are being made. Did you say everything is on one box, so networking off that box cannot be the issue? Martin On Wed, Jun 26, 2013 at 12:11 PM, Martin J. Evans boh...@ntlworld.com mailto:boh...@ntlworld.com wrote

Re: ODBC Driver failing?

, Martin J. Evans boh...@ntlworld.com mailto:boh...@ntlworld.com wrote: On 26/06/2013 19:35, Dan Bent wrote: Big thanks! I did this: ldd /opt/perl_32/lib/site_perl/5.__8.8/PA-RISC1.1-thread-multi/__auto/DBD/ODBC/ODBC.sl and got: /usr/local/liant

Re: ODBC Driver failing?

it is then - since this pretty much looks ok. Martin On Wed, Jun 26, 2013 at 2:01 PM, Martin J. Evans boh...@ntlworld.com mailto:boh...@ntlworld.com wrote: On 26/06/2013 19:35, Dan Bent wrote: Big thanks! I did this: ldd /opt/perl_32/lib/site_perl/5.__8.8/PA

Re: (Fwd) Quick Perl Questions - DBI and DBD

Oracle that says they cannot change the Oracle client libs so you could hit some incompatibility if you don't recompile. Martin -- Martin J. Evans Wetherby, UK

Re: DBI article in Korean

On 24/05/13 06:51, Gabor Szabo wrote: Hi, On Wed, May 22, 2013 at 10:08 PM, Martin J. Evans boh...@ntlworld.com wrote: Another good tutorial - please keep up the good work of promoting Perl. Thanks. I hope others will also help promoting my articles and interviews. The DSN (Data Source

Re: DBI article in Korean

statement can return a lot of rows and a lot of values in each row we cannot use a simple call to the do method. Some DBDs really dislike using the do method for select stmts and especially multiple stmts in the same SQL e.g., do(q/something; select something from something/); Martin -- Martin J

Re: DBI Module installtion

. Martin -- Martin J. Evans Wetherby, UK

Re: (Fwd) Bug in Oracle 11g2 with DBD::Oracle

of a problem. Perhaps I'll find some time to update the pod. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Final development release of DBD::ODBC 1.42 series

about this until we ran the test against Derby. Changed to use '100'. RT 80446 - fix spelling mistake - thanks to Xavier Guimar. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Possible database handle leak in DBI?

is invoked using Apache::DBI::connect, but that doesn't seem to be the case if running under fastcgi. Anyway, thanks for the pointers. I'll report back with any extra information I find. Duncan Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Fwd: DBD::Oracle Schema different than User question

Forwarded to dbi-users. Original Message Subject: DBD::Oracle Schema different than User question Date: Mon, 12 Nov 2012 13:04:05 -0500 From: Kevin L. Kane kevin.k...@gmail.com To: Tim Bunce t...@cpan.org, Yanick Champoux yan...@cpan.org, Martin J. Evans mjev...@cpan.org Hi

Fwd: DBD::Oracle Schema different than User question

, Martin J. Evans mjev...@cpan.org Hi all, I am running into a problem and was planning on modifying my local DBD::Oracle to add support for a schema=mySchema construct in the connect string. Specifically, I want to connect as user X but set current_schema to Y. Another solution i've toyed

Re: Trying to get DBI to install on Raspberry Pi with Wheezy OS

On 28/10/2012 13:18, Steven Haun wrote: I have tried cpan and cpanm installs and get very non description errors (other than failed). Any help would be appreciated. Thanks. I installed DBI on a raspberry Pi ages ago. See bottom of http://www.martin-evans.me.uk/node/142 and

Re: Trying to get DBI to install on Raspberry Pi with Wheezy OS

apt-get install gcc Martin On Oct 28, 2012, at 8:27 AM, Martin J. Evans martin.ev...@easysoft.com wrote: On 28/10/2012 13:18, Steven Haun wrote: I have tried cpan and cpanm installs and get very non description errors (other than failed). Any help would be appreciated. Thanks. I installed

Re: Trying to get DBI to install on Raspberry Pi with Wheezy OS

installed, 0 to remove and 0 not upgraded. root@raspberrypi:/home/pi What does perl -V output? Martin On Oct 28, 2012, at 8:36 AM, Martin J. Evans martin.ev...@easysoft.com wrote: On 28/10/2012 13:34, Steven Haun wrote: I am using 'sudo cpanm -i DBI' . I found the details in the log (forgot

Re: Trying to get DBI to install on Raspberry Pi with Wheezy OS

, 0 newly installed, 0 to remove and 0 not upgraded. root@raspberrypi:/home/pi What does perl -V output? Martin On Oct 28, 2012, at 8:36 AM, Martin J. Evans martin.ev...@easysoft.com wrote: On 28/10/2012 13:34, Steven Haun wrote: I am using 'sudo cpanm -i DBI' . I found the details

Re: Trying to get DBI to install on Raspberry Pi with Wheezy OS

/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . On Oct 28, 2012, at 8:42 AM, Martin J. Evans wrote: On 28/10/2012 13:40, Steven Haun wrote: It appears

New 1.41 release of DBD::ODBC

J. Evans Easysoft Limited http://www.easysoft.com

New development release of DBD::ODBC 1.40_3

I will probably release this as 1.41 in the next week. Please note the changes in behaviour. =head2 Changes in DBD::ODBC 1.40_3 October 8 2012 [BUG FIXES] Oops, changes to some rt tests fail when not run to MS SQL Server and they should not be run for other drivers - there was a double

Re: is this a viable option?

On 01/10/2012 18:29, Jack Craig wrote: Hi Folks, I have an html / perl app running on host A, i want to do a remote oracle query on host B from host A. Assuming proper credentials, is this a viable configuration? This as opposed to running perl dbi module installed on host B. TIA, jackc...

Fwd: Re: oracle instant client for Linux (oracle 9.2) ?

Oops, forgot dbi-users: Original Message Subject:Re: oracle instant client for Linux (oracle 9.2) ? Date: Mon, 01 Oct 2012 19:17:43 +0100 From: Martin J. Evans martin.ev...@easysoft.com Organisation: Easysoft Limited To: Jack Craig jack.craig.ap...@gmail.com

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

. From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Wednesday, August 15, 2012 1:33 PM To: dbi-users@perl.org Subject: Re: Help please with DBD::ODBC on SUSE-Linux On 15/08/2012 18:25, Jeff Tate wrote: Step 1) added ODBC trace information

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

as yet but I would not rule it out. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

  1   2   3   4   5   6   >