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

that task can take a while although seems simple to perform so if there is a simple 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 mailto:martin.ev...@easysoft.com>> wrote: On 24/01

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

ot; wanting a quick solution and I 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)

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 bu

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 un

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 ($price_s

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 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 table mje/); }; $h

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 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 like you built DBD::Ora

New DBD::ODBC 1.47 release

I have just uploaded DBD::ODBC 1.47 to the CPAN. This release does contain significant changes in behaviour for unicode builds of DBD::ODBC so I hope when I warned you months ago you tested it. Thanks to everyone on the dbi-dev list and irc that helped me work my way through the unicode issue.

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

ck but it should get you further. If you are struggling with this mail the Makefile to me (only) and I'll take a look. make: The error code from the last command is 255. Stop. [root@ews-pgh1-esmd2] /home/rj46/DBD-Oracle-1.70 q32 option is mandatory? no idea what your 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 t

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

ies and all DBD::Oracle does is make the appropriate calls to set 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 - Date: Wed, 4 Jun 2014 11:05:34 + From: Ranjitha To: "tim.bu...@pobox.com" , "t...@cpan.org" Subject: Issue :DBD::Oracle installation Hi Tim Facing an issue while installing DBD::Oracle mod

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

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

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

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: foreign_key_info() nits

On 16/11/14 23:59, Kurt Starsinic wrote: Hi all, I've been using DBI with DBD::Sybase and SQL Server, and discovered a couple of issues. I will be happy to offer a patch if I can get some consensus on what the correct resolutions are: The DBI docs say that foreign_key_info() can take from 3 to

Re: Escaping placeholders

t forward, but it would make application and interface layers so much 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 Bu

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

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 version,

Re: DBD::ODBC Destroy bug?

lbrews and I still cannot duplicate your issue. Martin On Tue, Mar 24, 2015 at 12:24 PM, Martin J. Evans 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: Ce

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

Re: DBD::ODBC Destroy bug?

r error, I've seen freeTDS error and fail to tell us the error before, your code works flawlessly with the Easysoft and MS ODBC drivers and your ODBC log contradicts the DBI/DBD::ODBC log so I'm going to suggest you've updated or changed your freeTDS driver and this one is broken. M

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 http://cpan-prc.org/

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

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 work

Re: help with odd DBI perpare/execute errors

On 03/06/15 14:38, William Bulley wrote: According to "Martin J. Evans" 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

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 wrote: According to Bruce Johnson on Wed, 06/03/15 at 10:10: Make sure your original $query is delimited by double quotes, not single. I've tried _everything_!! Single quotes. Double quotes. q{} and

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 o

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 meth

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

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

Re: error message

On 02/11/15 09:56, Ismail Chamseddine wrote: I did and it didn't work. for more information, the error message is the following: failed: [Microsoft][ODBC driver manager] data source name not found and no default driver specified (SQL - IM002) at line.. Then what drivers are listed in your OD

Re: Data sources

On 02/11/15 14:47, Ismail Chamseddine wrote: SQL server v6.01.7601. is installed . version of ODBC is 6.01.7601 When I click configure, it says that MS access driver is not installed. Then I'm afraid you need to to fix that problem first. If you have a 64bit perl I've no idea where you get the

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

On 27/01/16 22:10, Jerrad Pierce wrote: Hello all, I'm updating a LONGBINARY column in a Jet 4 (MDB) database on Windows 7 with DBD::ODBC and have encountered an odd issue. Rather than the common problem of Unicode data being treated as bytes, I have bytes that seem to be being treated as UCS-

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 Acces

Re: Help with DBD::Oracle install

PPORT -DORA_OCI_VERSION=\"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

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 th

new DBD::ODBC released

I have uploaded DBD::ODBC 1.56 to the CPAN (1.54 was skipped due to an indexing problem). Here are the changes since the 1.52: 1.53_2 2016-02-03 [MISCELLANEOUS] Add new FAQs 1.53_1 2015-10-16 [BUG FIXES] Strictly speaking this is a bug fix to DBI and not DBD::ODBC but DBI now sup

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

rd similar 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" 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 connect hangs for a while, and

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 libs to link off of. You

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 is

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 return

Re: debugging and stepping into ->do

On 25/04/18 16:13, Jeff Macdonald wrote: Hi, When using DBD::mysql, I can step into the prepare and execute methods of DBD, but I can't step into do (execution is the next code line after the do statement). 'do' is defined in DBI.pm this way: sub do { my($dbh, $statement, $attr,

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

n. Probably a better solution in the short term 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.

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

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

Re: DBD error

he same C 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: Solaris 10 - problem with connect to Oracle 10.2.0.2 with ORA_SYSDBA

olwin wrote: Sorry for my poor English. After connect in SYSDBA to an Oracle 10.2.0.2 Database, all system command return '-1' (No child processes). Problem detect on a Solaris 10 x86 server : Details : perl -MDBI -e 'DBI->installed_versions' Perl : 5.008006 (i86pc-solaris-thread-multi) OS : s

Re: problems compiling DBD::Oracle 1.22 on AIX 5.3

ark40 wrote: I know this has been discussed before but no solution was proposed. I searched google but couldn't find anything useful either. I am trying to compile DBD::Oracle 1.22 on an AIX 5.3 platform, using the Oracle 10g instant client. I initially ran into the OCI error so I went back and d

Re: Oracle 10.2 Perl 5.10

Duncan Garland wrote: Hi Martin, Thanks, but I don't think its Oracle, I think it the way the returned cursor is being handled. The statement is actually passed to a PL/SQL procedure my $cmd = qq { BEGIN report_package.execute_immediate(:sql, :start_row, :end_row, :page_ro

Re: DBD::Oracle + BLOB

Martin Gainty wrote: any reason why you want to 'describe' before the executing the statement? thanks Martin _ I'm not wishing to put words in Merijn's mouth but having attempted to write a perl app which worked with a number of DBDs I have some experience of how difficult this is.

New development release of DBD-ODBC (1.17_3)

I have just uploaded a new development release of DBD::ODBC. All/any feedback greatly appreciated. This fixes 2 issues on rt. I'm hoping this will be the last development release before a 1.18 as the 1.17 development series now contains quite a few changes - see below. Thanks to all who contri

DBD::ODBC 1.18 released to CPAN

t in 1.17 if the same column was greater than 80 characters then you would get a truncated error. The only way the around this was to set LongTruncOk or LongReadLen. Added a test case for rt 39897. =cut Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Recurse gives me No more handles

don.walt...@falconjet.com wrote: Just a quick thought. Instead of looping through the selected rows one at a time, if the result-set is small(ish) it would probably work if you selected all the rows (fetchall_arrayref) then looped through them. You will use more memory but les

Re: Recurse gives me No more handles

don.walt...@falconjet.com wrote: Is your dataset too large to hold in memory? Another approach would be load each result set into memory. I'm not sure I understand your suggestion. Whether I'm storing the results in memory or not, I still have to loop through the subroutine, h

Re: Ways of ensuring integers in the database are seen as numbers in perl?

Tim Bunce wrote: On Wed, Jan 28, 2009 at 10:30:49AM -0500, John Scoles wrote: I think this is on purpose. Oracle numbers have a huge precision (38 decimal digits), so in general you cannot convert them to a perl number without losing precision. DBD::Oracle could be sma

Error installing DBD::Oracle with InstantClient 10.1 - solution

lease = `$sqlplus_exe -S /nolog \...@define.sql 2>&1`; $ENV{ORACLE_HOME} = $x; } If needs to check for SP2-0642 as well and that fixes it: if ($sqlplus_release =~ /(SP2-0750)|(SP2-0642)/) { Hope this helps anyone else hitting this problem. Martin -- Martin J. Evans Easysoft

New development release 1.18_3 of DBD::ODBC

I have just uploaded DBD::ODBC 1.18_3 to CPAN. To see a list of changes since 1.18 see below. Since I requested anyone using DBD::ODBC to test the last development release I've had two replies - thank you. However, I cannot believe there are only 2 users of DBD::ODBC. I maintain DBD::ODBC for f

Re: install DBD::Oracle on oracle application server

joe bayer wrote: dear group I am trying to install DBD::Oracle on a box that has oracle application server. The sqlplus works fine, but i got error Unable to locate an oracle.mk, proc.mk or other suitable *.mk file in your Oracle installation. (I looked in /usr/local/app/ora

Re: FreeTDS and DBD::ODBC - bind parameter type during statement prep aration

will.sa...@sage.com wrote: Hello, I am using Perl 5.10, FreeTDS 0.82, DBI 1.605 and DBD::ODBC 1.13 with an MS SQL Server 2008. An SQL table I am working with includes columns with the binary data type. Whenever I try to prepare a statement with placeholders for these columns, the prepare fail

Re: ERROR OCIEnvNlsCreate with DBD::Oracle 1.23 and Oracle 10.2 on Solaris x86

Steven Schlansker wrote: Hello fine DBI users list, I'm having a bit of trouble getting DBD Oracle 1.23 working with Oracle Instant Client 10.2 (with SDK and SQLPlus) on SunOS machinename 5.10 Generic_138889-03 i86pc i386 i86pc I compile with a PREFIX set. Because I couldn't figure out how t

DBD::Oracle, Errors returned by procedures not unicode strings

R: OCIStmtExecute), Should be € Error decoded: ORA-20001: Error € ORA-06512: at "BET.P_MARTIN", line 3 ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) I would have expected "Error €" but the euro was double utf-8 encoded as it was not marked as utf-8 internally in perl. I sho

Re: make test fails on DBD::Oracle - t/26exe_array fail

roblems you are encountering are due to the user who is > running the test not having sufficient privs on the DB. > > Once I get access to an 11g EE box I might be able to look into it deeper. > > cheerrs Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com > >

Re: FreeTDS, unixODBC and DBD::ODBC

ble as it is quite possible Nick Gorham (of unixODBC) will know the answer or be able to find one. freetds version, unixodbc version, linux version, ldd and ld.so version, how unixodbc and freetds were built, whether you are using selinux etc. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: FreeTDS, unixODBC and DBD::ODBC

col wrote: On Thu, 25 Jun 2009 10:10:03 +0100 Martin Evans wrote: Martin J. Evans wrote: col wrote: [8<] So, I thought you folks should hear about it all again. HTH... else, sorry for the noise. [8<] I spoke to Nick and he reminded me why this can

Re: DBD::ODBC SQL-08S01 On Multiple Database Joins

Chase Putans wrote: Finding some odd and intermittent issues with DBD::ODBC when doing multiple database joins. If I do a multiple database join as in the SQL below, and do not have a where clause, or have a where clause and do not bind values, I get an SQL-08S01: "Read from SQL server failed".

Re: Problem with perl DBI ODBC driver (bug or misconfig ?) [String data right truncation]

Denis BUCHER wrote: Hello Martin, Martin Evans a écrit : Denis BUCHER wrote: Hello everyone, Some precisions to my previous email... I'm trying to simply do a SELECT from an ODBC source. It works perfectly in PHP but not in perl ! Therefore there is no problem at source or at

Re: DBD::ODBC and character sets

Sorry for top posting but this thread is getting really long now and getting difficult to follow. Good point Alexander and noted but I still feel the issue is way beyond whether UTF-8 encoded data is in the script or not as in my examples (as in the ones you provided when you did the original unic

Re: CGI::Sessions with MSSQL DB

se are a) transactions b) ability to install something on a windows machine c) whether you need unicode support d) level of API you are prepared to program to e) whether you need a support contract f) encrypted connections. If anyone has any other options, I'd like to hear them. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: tracing SQL calls with a stack dump

E R wrote: > Hi, > > I'd like to trace all SQL calls made but also print out the > information available from caller(). That will give me good > information about why I am accessing the database. > > Is there a way to do this with DBI (or DBD::Oracle in particular)? > Can I insert my own trace ha

[Fwd: Cannot send to 0rda-v...@xemaps.com]

I am getting one of these emails for every post I send to dbi-users and this has been going on for more than a day. Does the list automatically remove addresses which bounce repeatedly? Martin --- Begin Message --- An email you sent to '0rda-v...@xemaps.com' was refused by the remote mail server.

Re: Multiple Oracle clients in same code - no usernames needed

jeff wrote: > Hi all, > > Hope someone can help. > > I need to talk to both an oracle 8 and oracle 10 server in the same > script using their respective "external connections" capabilities (i.e., > no user name or password -- system authentication on 8 & wallet on > 10 ). > > Hacked up a versio

Re: Can't ctrl-c to exit with DBI, DBD::Oracle

Colin Murtaugh wrote: Hi -- I'm running into a strange problem with a script that uses DBI and DBD::Oracle. Once my script connects to my database, I can't use ctrl-c to exit (or ctrl-z to background it). I end up having to open another shell and kill the original process manually. As you ca

data retrieved from database is unexpectedly tainted

Hi, I've spent some time on this today and I am getting nowhere. Before I redouble my efforts I thought I'd post here just in case anything rings a bell with someone. We are using the latest DBI and DBD::Oracle to get data from an Oracle data. All data is retrieved via reference cursor returned

Re: data retrieved from database is unexpectedly tainted

Martin J. Evans wrote: > Hi, > > I've spent some time on this today and I am getting nowhere. Before I > redouble my efforts I thought I'd post here just in case anything rings > a bell with someone. > > We are using the latest DBI and DBD::Oracle to get data fro

Re: Problem with method statistics_info

White, Richard L wrote: > Hi, > > I'm new to the list, but not to Perl. I can not find an answer to my current > coding problem. > Is there an archive of this list? > > I'm running this code on: > OS - Windows XP > DB - Oracle 10 on Solaris > > I reinstalled ActiveState Perl yesterday and now

Re: strange bug with DBI, Sybase, and mod_perl

Jonathan Swartz wrote: Something in which code is closing STDOUT? I know that mod_perl redirects STDOUT to $r->print... Incidentally the code to reprodce for mysql is even easier - just need one connection. This will do it: use DBI; sub handler { my $dbh = DBI->connect( "DBI:mys

Re: $DBI::neat_maxlen

Bill Moseley wrote: > $DBI::neat_maxlen = 1; > DBI->trace(1); > > <- connect('dbname=test_dev', 'moseley', ...)= DBI::db=HASH(0xb2f6a90) > at DBI.pm line 653 > > Anyway to show the full connect details? > > $DBI::VERSION = "1.609"; > I'm not exactly sure what you want given your expl

Re: Error during SQL Server restore fails to propagate back to DBI client on Windows

all self contained and complete example would be best. Are you calling odbc_more_results after execute until it returns false? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Hi Martin, Thank you for your reply. I&#x

Re: Error during SQL Server restore fails to propagate back to DBI client on Windows

t;>>> >>>>>> sub error_handler { >>>>>> my @err = @_; >>>>>> >>>>>> print "Error handler >>>>> triggered!\n"; >>>>>> return 0; >>>>>> } >&g

Re: Error during SQL Server restore fails to propagate back to DBI client on Windows

most of that 2 hours ago. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Error during SQL Server restore fails to propagate back to DBI client on Windows

base context to 'master'. (SQL-01000) [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. (SQL-01000) errstr: [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 176 pages for database 'foo', file 'foo' on file 1. (SQL-01000)

Re: Error during SQL Server restore fails to propagate back to DBI client on Windows

On 22/02/2010 20:46, pr wrote: --- On Mon, 2/22/10, Martin J. Evans wrote: From: Martin J. Evans Subject: Re: Error during SQL Server restore fails to propagate back to DBI client on Windows To: "pr" Cc: dbi-users@perl.org Date: Monday, February 22, 2010, 7:35 PM On 21/02/2010

Common problems calling procedures in MS SQL Server via DBD::ODBC

I've written up some of the issues causing confusion on dbi-users (and to me personally) with DBD::ODBC and MS SQL Server here: http://www.martin-evans.me.uk/node/58 I encourage all feedback. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Problems with empty/NULL lobs

"A word of catution when using the data retruned from an ora_lob_read in a condtional statement. for example if the code below;" Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Help with handling CLOBs in Oracle and ORA-1460 error

> on LOBs larger than 32k? Is this a bug? In Oracle? Perl? DBI? > DBD::Oracle? > > Any thoughts or suggestions would be greatly appreciated! > > Thanks, > > -Mark > > Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Help with handling CLOBs in Oracle and ORA-1460 error

al Message- From: Martin Evans [mailto:martin.ev...@easysoft.com] Sent: Wednesday, April 07, 2010 12:38 PM To: Bobak, Mark Cc: dbi-users@perl.org Subject: Re: Help with handling CLOBs in Oracle and ORA-1460 error Martin J. Evans wrote: Bobak, Mark wrote: Hi all, I'm new to the list

Re: Help with handling CLOBs in Oracle and ORA-1460 error

Bobak, Mark wrote: > > From: Martin J. Evans [mailto:martin.ev...@easysoft.com] > Sent: Wednesday, April 07, 2010 2:49 PM > To: Bobak, Mark > Cc: dbi-users@perl.org > Subject: Re: Help with handling CLOBs in Oracle and ORA-1460 error > > Bobak, Mark wrote: > > Hi

Re: (Fwd) How to loop through a database, row by row, and select and update one row at a time

;SELECT msgid, xmlcontent FROM messages WHERE msgid = 1892362" is > also mildly inefficient, why are you returning the msgid when you > already know it? > > do "SELECT xmlcontent FROM messages WHERE msgid = 1892362" instead. > > It's not much, but you're sa

New experimental development release of DBD::ODBC 1.23_4 - faster - please test

coming from the database as utf8. This is for Aster (based on PostgreSQL) which returns all strings as UTF-8 encoded unicode. Thanks to Noel Burton-Krahn. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Stupid Oracle question

Bruce Johnson wrote: > If $dbh is my database handle, to roll back the current transaction I > do: $dbh->rollback(); right? > > The DBD::Oracle docs don't explicitly say > > You want to look at the DBI pod. The begin_work method starts a txn and the commit and rollback methods commit or rol

Re: Stupid Oracle question

Bruce Johnson wrote: > > On May 6, 2010, at 11:34 AM, John Scoles wrote: > >> Bruce Johnson wrote: >> >> Depends if you have |AutoCommit| on or not and if you DB and DBD >> friver can do a rollback. > > > I've explicitly turned autocommit off, so I can roll back transactions > if an error occur

ODBC - The Connection Process

I get a lot of queries to my personal/CPAN email address with connection problems with DBD::ODBC. I've tried to describe the process at http://www.martin-evans.me.uk/node/70 which you may find useful. I know some people are a little cagey these days about self promotion of web sites. If you are on

<    1   2   3   4   5   6   >