Re: DBD::mysql 4.024 Released

2013-09-24 Thread Robert Dodier
But when I inspect perl/site/lib/DBD/mysql.pm, I see that it says $VERSION = '4.024'. I'm not sure what to think. Was the new version actually installed? (Previous was 4.022.) Or is the installation mixed up in some way? How can I tell for sure? Thanks for any light you can shed on

looking for a patch or workaround for err / errstr bug

2013-06-26 Thread Robert Dodier
says $VERSION = '4.022' in it. Does anyone know of a patch or workaround for bug #71555? Thanks for any advice. best, Robert Dodier

Re: Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Robert Durgin
# Should I specify a bind type and if so, what type? $sth->bind_param(":p_ID",$i) or die "bind(ID) err is $DBI::errstr\n"; $sth->execute(); Hoping it is something really simple. Thanks for any help E. Scott Stricker @ Work -- Robert Durgin Sr. Software Engineer Texterity • 144 Turnpike Road Southborough , MA 01772 rdur...@texterity.com www.texterity.com

RE: DBD::ADO Crashes on Fork

2011-04-14 Thread Robert Boisvert
iated. Bob -Original Message- From: Steffen Goeldner [mailto:sgoeld...@cpan.org] Sent: Thursday, April 14, 2011 10:39 AM To: Robert Boisvert Cc: dbi-users@perl.org Subject: Re: DBD::ADO Crashes on Fork Robert Boisvert wrote: > I'm working on a project to connect to a SQLExpress

DBD::ADO Crashes on Fork

2011-04-12 Thread Robert Boisvert
the child process terminates (see program snippet below). Is my code in error or is there something amiss with the ADO/DBI drivers? I appreciate whatever assistance you can provide, Robert Boisvert Business Analyst SYNCHRONOSS TECHNOLOGIES (m) 908-745-1268 (aim) robert.boisv...@synchronoss.com ro

Re: DBD-CSV taint mode

2011-03-28 Thread Robert Roggenbuck
Can You insert a $dbh->trace($level) before the failing statement (with a $level of 1 or higher) and a $dbh->trace(0) after it? Show us the trace output. I hope we will see what exactly is tainted. Greetings Robert Am 28.03.2011 13:42, schrieb Karl Oakes: I have tried using the

Re: DBD-CSV taint mode

2011-03-27 Thread Robert Roggenbuck
Does an open(FILE, '<', $csvfile) works right before a CUD-operation? If not, move this open()-call step by step to the top of Your script to catch the point where the tainted data enters. BTW: if Your filename is composed from tainted bits it is tained too. greetings R

Re: Error on Make command - gcc: odule_wrap.o: No such file or directory

2010-11-25 Thread Robert Roggenbuck
It looks like a typo to me. Have You tried to look for "module_wrap.*"? Greetings Robert Am 24.11.2010 19:56, schrieb Mike Towery: Here is what I get when I do that. [r...@l2rac2 DBI-1.615]# gcc -shared -L/usr/local/lib odule_wrap.o -o blib/arch/auto/odule/module.so gcc: odule_

Re: How to connect DBI module in my local server

2010-10-25 Thread Robert Roggenbuck
DBI/DBI.pm especially http://search.cpan.org/~timb/DBI/DBI.pm#DESCRIPTION Greetings Robert

Re: DBI and DBD Installation on Different Unix (Solaris, AIX, HP and Linux)

2010-08-06 Thread Robert Roggenbuck
7;DBI' by the name of any DBD (or any other module) You like to install and continue. For example: $ perl -MCPAN -e "install 'DBD::SQLite'" This will work on any system, not only on Unixes. But of course only for modules hosted on CPAN. Greetings Robert

Re: need help on $sth->bind_param

2010-06-04 Thread Robert Roggenbuck
s example is equivalent to the one above: $sth->bind_param(1, $value, SQL_INTEGER); The TYPE value indicates the standard (non-driver-specific) type for this parameter. To specify the driver-specific type, the driver may support a driver-specific attribute, such as { ora_type => 97 }. The SQL_INTEGER and other related constants can be imported using use DBI qw(:sql_types); For the possible values of $bind_type look in the code of DBI.pm for 'sql_types'. Greetings Robert

Re: What is the meaning of the return value from a DBI do statement?

2010-05-26 Thread Robert Roggenbuck
w deleted. Is this the method of testing to see if, in this case, the DELETE deleted any rows, and if so, how many? If not, what would be the way? And would this other way handle updates as well? The problem is that You check the return value of $sth->execute() ... Greetings Robert

Re: 'AllTables' method in DBIx:.Database returns nothing with CSV files

2010-04-19 Thread Robert Roggenbuck
Did you tried it with an absolute path to f_dir? Greetings Robert -- ozarfreo schrieb: I am using DBIx::Recordset to access a directory with CSV files, and the method DBIx::Database->AllTables seems to return just an empty hash reference. I'm talking about the following code:

Re: Help needed.

2010-01-14 Thread Robert Roggenbuck
Can You show us the part of the code which have the problem. Try to minimise Your program to the problematic core. Greetings Robert --- Agarwal, Gopal K schrieb: Hi, I am connecting the Oracle DB with perl DBI. For short queries (execution time <2 sec) I am able to fetch the data but

Re: DBD version for Sybase 15

2009-12-17 Thread Robert Roggenbuck
The latest Version of DBD::Sybase is 1.09 (at CPAN). You should try this. By the way: What went wrong while installing or running Your program? Greetings Robert kanisorn.inthac...@dstglobalsolutions.com schrieb: Hi There, I'm looking to run the perl script on the Windows 2003 server

Re: Info needed about version compatibility

2009-11-27 Thread Robert Roggenbuck
Have a look at http://matrix.cpantesters.org/?dist=DBI+1.609 for DBI and http://matrix.cpantesters.org/?dist=DBD-Oracle+1.23 for DBD::Oracle. It doen't look good for DBD::Oracle but it seems to me that the passed tests are not reported ... it can't be such a bad code ;-) Greeti

Re: DBD::SQLite: Nullable Primary Key?

2009-10-21 Thread Robert Roggenbuck
) Not nice, but it is a way... Greetings Robert --- Mark Lawrence schrieb: On Mon Oct 12, 2009 at 02:54:38PM +0200, Robert Roggenbuck wrote: I detected that it is possible to enter NULL in a table-column defined as PRIMARY KEY. Is it a bug or a feature of the "manifest typing&quo

DBD::SQLite: Nullable Primary Key?

2009-10-12 Thread Robert Roggenbuck
ting a NULL in column b for the second INSERT, but not for column a in the first INSERT... Greetings Robert

Re: DBD::CSV data types

2009-10-09 Thread Robert Roggenbuck
You will find the "supported" data-types in SQL::Dialiects::CSV of the SQL::Statement package. There in no POD, but the section [VALID DATA TYPES] lists all possible types. DATE is unfortunately not there (DBD::CSV 0.22). Hope that helps Robert -- larry s schrieb: Does anyone kno

Re: DBD::CSV - UPDATE corrupts data!

2009-08-20 Thread Robert Roggenbuck
D::CSV::st (DBI::st=HASH(0x18e7698)~0x18e75c0 '20040101' '20080630' 'ID001') thr#1880010 -> execute for DBD::CSV::st (DBI::st=HASH(0x18e7698)~0x18e75c0 '20050701' '20100430' 'ID003') thr#1880010 -> execute for DBD::CSV

Re: DBD::CSV - UPDATE corrupts data!

2009-08-20 Thread Robert Roggenbuck
the same as 15). What's going on? Where should I look for the cause of the problem? Greetings Robert PS: Here again my test-script. The 1st execution creates the table 'Projects' in /tmp. The 2nd execution should update the data (infact if everything went fine nothing chang

Re: disconnect and non-'Active' statement handles

2009-08-19 Thread Robert Roggenbuck
ay 'close STDERR' works too.) :-) Greetings Robert Robert Roggenbuck schrieb: John Scoles schrieb: As I see this is a .cgi script I will hazard a guess that you are using an apache server. Thats right! If this is so what mostlikly is happening is apache::DBI is leaving thos

Re: disconnect and non-'Active' statement handles

2009-07-22 Thread Robert Roggenbuck
e develops after the release of the script. Greetings Robert

disconnect and non-'Active' statement handles

2009-07-22 Thread Robert Roggenbuck
l, v5.8.8 built for i586-linux-thread-multi (SuSe-Linux, kernel 2.6.18) DBI 1.52 DBD::SQLite 1.13 Greetings Robert

Re: Very slow mail-transport to the list

2009-07-06 Thread Robert Roggenbuck
I changed my subscription address. And now mailing goes as fast as it should. Thanx 8-) Robert rrogg...@uni-osnabrueck.de schrieb: Thank You very much for this clarification! I will try to change my email next week. The rest of this week I am at home and can not access the address from wich I

Re: DBD::CSV - UPDATE corrupts data!

2009-07-06 Thread Robert Roggenbuck
same. Other things inlined ... Alexander Foken schrieb: Hello, On 30.06.2009 14:41, Robert Roggenbuck wrote: Hi all, [snip] Running the code below copied and pasted on Linux 2.6.26.5, Perl 5.8.8, DBI 1.607, DBD::CSV 0.20, both runs deliver the same result from your first run. Even several

Very slow mail-transport to the list

2009-06-30 Thread Robert Roggenbuck
GMT! Is there something wrong with the list software? Or is there a problem anywhere between my and the list? Such delays are not good to take part in discussions... Greetings Robert PS: Here is a snipped of the mentioned Email. It can be seen that it left Uni-Osnabrueck.DE at '29 Jun

DBD::CSV - UPDATE corrupts data!

2009-06-30 Thread Robert Roggenbuck
84)~0xd27e8 '20050701' '20100430' 'ID003') thr#22ea0 1 -> finish for DBD::CSV::st (DBI::st=HASH(0xd27e8)~INNER) thr#22ea0 1 <- finish= 1 at File.pm line 439 <- execute= 1 at debugSetup.pl line 48 will try UPDATE Projects -> execute for DBD::CSV::st (DBI::st=HASH(0x4cee84)~0xd27e8 '20050301' '20091231' 'ID002') thr#22ea0 1 -> finish for DBD::CSV::st (DBI::st=HASH(0xd27e8)~INNER) thr#22ea0 1 <- finish= 1 at File.pm line 439 <- execute= 1 at debugSetup.pl line 48 [snip] At last my stats: Perl 5.8.8 built for sun4-solaris-thread-multi DBI 1.48 DBD::CSV 0.22 Can someone help? Greetings Robert

Re: Insert records in table with perl DBD::Mysql

2009-06-30 Thread Robert Roggenbuck
Greetings Robert --- Jannis Kafkoulas schrieb: Hi, I have this table: create TABLE netobj ( name VARCHAR(100), type int(1), ip_mem VARCHAR(1100), mask VARCHAR(15) default "na", comment VARCHAR(50) default "-", mark int(1) default 0, primary key(name)); (on a debian e

Re: bind_params: Not identifying ? as a parameter placeholder

2009-06-17 Thread Robert Roggenbuck
Why not $sth->bind_param(4, $int); ? I see 4 placeholders in Your statement. Do not rely on the values of statement handle attributes (like NUM_OF_PARAMS) unless You executed the statement handle. By the way: How does Your code fails? Any error message? Greetings Robert

Re: Datatype-support of DBD::SQLite

2009-06-05 Thread Robert Roggenbuck
DEFAULT, are available within DBD::SQLite. :-) Greetings Robert --- Owen schrieb: On Wed, 27 May 2009 16:19:28 +0200 Robert Roggenbuck wrote: Hi all, while looking at the SQLite-Documentation at http://www.sqlite.org I detected that there are only a few SQL data types supported

Datatype-support of DBD::SQLite

2009-05-27 Thread Robert Roggenbuck
CHARACTER, VARCHAR, BOOLEAN, DATE, TIME and other useful data types. Using DBD::CSV most of them are "accepted" but not treated special. Is it necessary to reformulate my CREATE TABLE statements if I decide to use DBD::SQLite? Greetin

Re: Difference between DBD::SQLite and DBD::SQLite2?

2009-05-27 Thread Robert Roggenbuck
Thanks for the clarification. Greetings Robert -- David Dooling schrieb: On Tue, May 26, 2009 at 12:29:08PM +0200, Robert Roggenbuck wrote: can someone explain the difference between the DBD::SQLite and the DBD::SQLite2 divers? DBD::SQLite2 is deprecated and (as you indicate below) is

Difference between DBD::SQLite and DBD::SQLite2?

2009-05-26 Thread Robert Roggenbuck
ion 3, since it states in it's NAME-chapter it is for sqlite 2.x? Hope someone can "unconfuse" me. Greetings Robert -- ====== Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachbereich Mathematik / Info

Re: selecting a bigint

2009-05-19 Thread Robert Roggenbuck
very RDBMS. And if it is there, the syntax differs... But may be there is a converging process to more and more standard support. Greetings Robert -- ====== Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachb

Re: Beginners Question: Can I have more the one statement-handle from same db-handle at a time?

2008-11-21 Thread Robert Roggenbuck
sth... while (my ($animal) = $sth2->fetch_array) { ... } I can´t test myself because my the mysql db on my iphone is broken and I have no other here at the moment :-( A simple yes or no will do. Thanks, B. -- === Robert Roggenbuck Universitaetsbibliothek Osnab

Re: How to write a (My)SQL statement with REGEX / RLIKE containing a scalar variable?

2008-11-14 Thread Robert Roggenbuck
Server ... :-( Greetings Robert Deviloper schrieb: That's again the moment where I ask me, are there any good mysql cookbooks out there? Every sql book I touch seems only to have crappy mysql examples, but tons of oracle example... thanks so far. B. "Dr.Ruud" <[EMAIL PRO

Re: [rt.cpan.org #36696] DBI AutoCommit perldebug eval $@ problem

2008-07-01 Thread Robert Roggenbuck via RT
Queue: DBI Ticket http://rt.cpan.org/Ticket/Display.html?id=36696 > Can You please remove the address 'dbi-users@perl.org' from any 'To'-field (CC and BCC)? Greetings Robert Tim_Bunce via RT schrieb: >Queue: DBI > Ticket http://rt.cpan.org

Re: [rt.cpan.org #36696] DBI AutoCommit perldebug eval $@ problem

2008-07-01 Thread Robert Roggenbuck
Can You please remove the address 'dbi-users@perl.org' from any 'To'-field (CC and BCC)? Greetings Robert Tim_Bunce via RT schrieb: Queue: DBI Ticket http://rt.cpan.org/Ticket/Display.html?id=36696 > Doesn't the fact this only happens in the debugger

Re: Installing package

2008-05-30 Thread Robert Roggenbuck
This sounds to be a permission problem. Check Your install aim and Your permissions there. Greetings Robert Nirmaladevi Venkataraman schrieb: Hi when I tried to install DBD-ODBC package I get following error message "ppm install failed: All available install areas are readonly.&quo

Re: Log DBI query and values with placeholders

2008-04-15 Thread Robert Roggenbuck
$sth->{Statement} returns the prepared statement. Using this as a base You can get the used values in a HashRef by $boundParams = $sth->{ParamValues} after an execute. I did not used it before ... but it should work. Regards Robert aspiritus schrieb: Hello all experts ! I need to log

DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 & Perl 5.10)

2008-02-02 Thread Robert Mundkowsky
Hi, If anyone has a pre-built DBD-Oracle for Windows (XP/Pro)/Perl 5.10, would love to have it. R - * Notice: This e-mail, i

Re: Segmentation Fault(Core dumped)

2008-01-07 Thread Robert Roggenbuck
Please give us some more information. Can You figure out where (= which lines) in Your script the code crashes? Greetings Robert Kasi, Vijay (London) schrieb: Hello, I am receiving 'Segmentation Fault (core dumped)' error while executing perl script on unix host. I am using ora

Re: DBI problem...

2007-12-18 Thread Robert Roggenbuck
Hi, at first it is not necessary to say "use DBI::DBD". You name the driver in the call of DBI->connect(). Regarding the syntax error it would be worth to see some more lines before line 23. May be a missing ';' in line 22? Regards Robert didik kustriant schrieb:

Re: DBD::CSV: make test fails

2007-10-19 Thread Robert Roggenbuck
; print "$Text::CSV_XS::VERSION\n"' 0.31 $> perl -e 'use DBI; print "$DBI::VERSION\n"' 1.59 $> perl -e 'use DBD::CSV; print "$DBD::CSV::VERSION\n"' 0.22 Best regards Robert

Re: DBD::CSV: make test fails

2007-10-17 Thread Robert Roggenbuck
lines 28-34). If I unset the DBI_* variables, DBD::Adabas is not used and all DBD::CSV-tests are passing - and finally 'make install' succeeds. May be this DBI_* usage should be removed from lib.pl? For the DBD::Adabas problem I will open a new thread. Thanks for all the comments :

Re: DBD::CSV: make test fails

2007-10-17 Thread Robert Roggenbuck
thought 'list_table' is a DBI function - but it is a DBD::CSV privat feature. So again DBD::CSV is wrong in using DBD::Adabas and applying it's own feature to a foreign driver. Cleaning the test codes from using foreign drivers will also solve this issue. Best regards Robert --

Re: DBD::CSV: make test fails

2007-10-16 Thread Robert Roggenbuck
Hi Ron, Ron Savage schrieb: Robert Roggenbuck wrote: Hi Robert Looking at the code and the first error msg you got: YOU ARE MISSING REQUIRED MODULES: [ ] makes me suspect the method you are using to test the module. Are you using 'The Mantra' of standard commands? Something like:

Re: DBD::CSV: make test fails

2007-10-15 Thread Robert Roggenbuck
opped going though the others. The message is exactly the same in every test. If these are Jeff Zucker's private tests, there is something wrong with the package... Best regards Robert Ron Savage schrieb: [EMAIL PROTECTED] wrote: Hi Robert This is not much (missing an unnamed modul

DBD::CSV: make test fails

2007-10-13 Thread Robert Roggenbuck
b/perl/lib/5.8.8/i686-linux-ld /home/rroggenb/perl/lib/5.8.8 /home/rroggenb/perl/lib/site_perl/5.8.8/i686-linux-ld /home/rroggenb/perl/lib/site_perl/5.8.8 /home/rroggenb/perl/lib/site_perl . --- Best regards Robert

Re: 11i is out...

2007-08-27 Thread Robert Hicks
Andy Hassall wrote: Robert Hicks wrote: Does the latest version of DBI/DBD::Oracle support it? I didn't see a support version table anywhere. I posted something on this to the dev list, see link below, basically it works but there's a couple of minor issues: http://www.mail-a

11i is out...

2007-08-27 Thread Robert Hicks
Does the latest version of DBI/DBD::Oracle support it? I didn't see a support version table anywhere. Robert

Re: Another set of DBI docs

2007-08-16 Thread Robert Hicks
e of the explorer-style TOC. I know its handy to me to quickly lookup the meaning of an attribute I've forgotten, or to lookup the right parameters for some method. Any comments/corrections/suggestions welcome, but are probably best sent offlist. Regards, Dean Arnold Presicient Corp. That is pretty nifty. Robert

Re: ShowErrorStatement

2007-08-15 Thread Robert Hicks
Tim Bunce wrote: On Tue, Aug 14, 2007 at 07:01:23PM -0400, Robert Hicks wrote: Tim Bunce wrote: Setting ShowErrorStatement is unrelated to "or die..." so the question seems flawed. ShowErrorStatement just adds information to the message produced by RaiseError and PrintError. I

Re: DBI DBD-ODBC

2007-08-15 Thread robert . v . simmons
Yes that is the statement I am using in my PERL script. Robert V Simmons Martin Evans <[EMAIL PROTECTED]> 08/15/2007 03:31 AM To dbi-users cc Subject Re: DBI DBD-ODBC [EMAIL PROTECTED] wrote: > I created an MSACCESS Database on my Windows XP O/S, set up the System

Re: ShowErrorStatement

2007-08-14 Thread Robert Hicks
Tim Bunce wrote: On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code

Re: ShowErrorStatement

2007-08-14 Thread Robert Hicks
Tim Bunce wrote: On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code

DBI DBD-ODBC

2007-08-14 Thread robert . v . simmons
If anyone knows the reason for this error and how I can fix it, I would appreciate it very much. I am sending this email as a last resort as I have exhausted all of my resources. Regards, Robert V Simmons This communication is for informational purposes only. It is not intended as an off

Re: ShowErrorStatement

2007-08-14 Thread Robert Hicks
h = DBI->connect($DSN, $user, $pass, { RaiseError => 1, PrintError => 0, ShowErrorStatement => 1, ... Tim. So I should still "or die..." even if I set ShowErrorStatement? I ask, because if true, then I would like to let the author of the paper I am reading know to make corrections if needed. Robert

ShowErrorStatement

2007-08-13 Thread Robert Hicks
First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with "or die..." statements. Is it good practice to use this or is an explicit "or die..." better because you can "see" there is error trapping? Robert

Re: Load Testing Script

2007-08-07 Thread Robert Hicks
Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might

Re: Load Testing Script

2007-08-07 Thread Robert Hicks
It probably doesn't matter. Right now I just have a script that does inserts and selects. I control the database so I can do pretty much what I need to do. Loo, Peter # PHX wrote: From a flat file? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED]

Re: Load Testing Script

2007-08-07 Thread Robert Hicks
Loo, Peter # PHX wrote: Hey Robert, Are you going from Oracle to Oracle? Peter Yup...I am basically wanting to test against 1 particular Oracle db. Robert

Load Testing Script

2007-08-07 Thread Robert Hicks
Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Robert

Re: Recovering records from corrupted MSSQL tables

2007-07-30 Thread Robert Roggenbuck
# implicit 'next;' } else { # no more records last; } } $isrt_sth->execute( @$row_ref ) } Robert Brian H. Oak schrieb: I'm working with an MS SQL Server database residing on a disk that suffer

Re: [DBD::Oracle] Familiar error to someone?

2007-07-20 Thread Robert Hicks
John Scoles wrote: Itanium could be a 32/64 bit problem did you compiled all your code useing 32 bit libs? I believe so...I know the c code is. Perl: Summary of my perl5 (revision 5.0 version 6 subversion 2) configuration: Platform: osname=linux, osvers=2.6.9-55.el, archname=ia64-lin

[DBD::Oracle] Familiar error to someone?

2007-07-20 Thread Robert Hicks
erl 5.6.2 DBD::Oracle 1.17 DBI 1.56 Should we move up to the latest DBD::Oracle to fix? This doesn't happen on the PA-RISC box running DBI 1.14 with the same version DBD::Oracle. Robert

Re: DBI requires 5.6.0 or 5.6.1?

2007-07-19 Thread Robert Hicks
Paul DuBois wrote: Tim, thanks for clarifying. I was wondering because it wasn't clear to me, in writing about DBI, how to characterize what version of Perl a reader should have. I'll write that 5.6.0 is required but 5.6.1 is preferred. What are you writing about DBI? ; ) Robert

Re: DBI:CSV join ... flashback to 2002

2007-07-16 Thread Robert Roggenbuck
x27;. May be all the problems will be gone then. Best regrads Robert [EMAIL PROTECTED] schrieb: Question about joining using DBI:CSV. I must be making a stupid mistake somewhere. Earlier posts (2002) state that there were problems using aliases in joins. I've just installed the mod

Oracle spatial

2007-07-12 Thread Robert Hicks
Does DBD::Oracle have any problems with spatial tables and the like? We are looking at using spatial for some nav computational stuff. Robert

Re: Oracle make test failing on HP/UX

2007-07-09 Thread Robert Hicks
/opt/perl5/lib/5.6.2/IA64.ARCHREV_0 /opt/perl5/lib/5.6.2 /opt/perl5/lib/site_perl/5.6.2/IA64.ARCHREV_0 /opt/perl5/lib/site_perl/5.6.2 /opt/perl5/lib/site_perl . Am I just not understanding the POD and suggestions? I am doing everything according to the POD but nada. Robert

Re: Oracle make test failing on HP/UX

2007-07-06 Thread Robert Hicks
/usr/lib/hpux32/dld.so: Cannot dlopen load module '/usr/lib/hpux32/libpthread.so.1' because it contains thread specific data. Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load '/users//DBD-Oracle-1.17/blib/arch/auto/DBD/Oracle/Oracle.so' for modu

Re: Oracle DBI for HP

2007-07-03 Thread Robert Hicks
[EMAIL PROTECTED] wrote: Can you get hold of an HP ANSI C compiler? p Yes I can. R

Re: Oracle DBI for HP

2007-07-03 Thread Robert Hicks
develooper.com/hpux/downloads.html I used the following version which has the DBI module already installed: "11.23 / 64 and perl 5.8.8 + defined-or + DBI 1.53 + Tk 804.027 built with gcc-4.1." (It is down at the bottom!) I have to use the 5.6 series... : ( Robert

Re: Oracle make test failing on HP/UX

2007-07-03 Thread Robert Hicks
=$ORACLE_HOME:$ORACLE_HOME/lib and see what happend I will try that as well. I have both the LD and SHLIB set in the env but I think the LD one points to the 64 bit libs. Robert

Re: Oracle make test failing on HP/UX

2007-07-03 Thread Robert Hicks
[EMAIL PROTECTED] wrote: Note the libraries. perl is 64 bit whereas you are trying to load 32 bit libraries. I have built Oracle DBI on Itanium if you want further info P I would be much ablidged if you could share. : ) Robert

Oracle make test failing on HP/UX

2007-07-03 Thread Robert Hicks
I am trying to install DBD::Oracle (yes I did read the README) on HP/UX 11.23 (itanium). I have DBI installed properly and I tested using DBD::SQLite. When I go to install the Oracle stuff I get this during a "make test": ./usr/lib/hpux32/dld.so: Cannot dlopen load module '/usr/lib/hpux32/lib

Re: escaping % AND \%

2007-07-02 Thread Robert Roggenbuck
>execute( '%' . $user_input . '%' ); Doing it this way You avoid the trouble handling the conflicting Perl- and the SQL-escaping in case of '%'. Regards Robert Bill Moseley schrieb: I have a very simple search using ILIKE and binding like: $sth->execute( &

RE: ODBC probelms when connecting to MSSQL

2007-06-02 Thread Robert Boardman
The perl script is #!/usr/bin/perl use strict; use warnings; use DBI qw(:sql_types); my($mandateid,$memberno,$orderval,$fitdate,$authmessage,$authnum); my ($output1, $output2,$output3, $input1, $input2, $input3, $input4, $input5); $mandateid = $ARGV[0];

ODBC probelms when connecting to MSSQL

2007-05-31 Thread Robert Boardman
Hi All I'm trying to connect to MSSQL 2000 to execute a number of stored procedures to return values to my IVR system, I have two stored procedures that work, and one that works from the ms query analyser, but when I run the perl script Here is the output DBI::st=HASH(0x9816204

Re: DBD::CSV and multi character separator

2007-04-27 Thread Robert Roggenbuck
This looks clean too me - and Philip points already to the main reason for which Your code fails. BTW: Did You get an error message while connecting / querying or did You just get no results? Greetings Robert - Santosh Pathak schrieb: Here is my code, use DBI; $dbh = DBI->conn

Re: DBD::CSV and multi character separator

2007-04-27 Thread Robert Roggenbuck
Hi, can You show us a relevant code snippet (connecting and querying) and a snippet of Your CSV-Data? Which kind of line separator are You using? Best Regards Robert Santosh Pathak schrieb: Hi, I read on following site that DBD::CSV supports multi-character separator. But I am not

Re: Is PERL --> MS SQL really that difficult?

2007-04-26 Thread Robert Denton
connect to server $DBI::errstr" unless $dbh; ~ My biggest error, other than borrowing unproven connect() syntax from who-knows-what-google-return, was in not declaring "dbi:ODBC:" in from of the data source and also in not defining my odbc.ini file. Many thanks to everyone

Re: Gofer to PC (was: Is PERL --> MS SQL really that difficult?)

2007-04-26 Thread Robert Denton
ion. I am pursuing the other ideas offered (sybase, connect () syntax improvements, etc) for now. Thanks for the tips! Robert On Apr 26, 2007, at 4:51 AM, Tim Bunce wrote: On Wed, Apr 25, 2007 at 05:24:40PM -0400, Robert Denton wrote: Is it just me, or is using perl on a linux server

Re: Is PERL --> MS SQL really that difficult?

2007-04-25 Thread Robert Denton
"Why can't we all just get along?" --unknown (by me) I understood from the start that I would be raging against the machine but I was hoping there would be fellow ragers to help me along. I am _so_ close. I can feel it. But I really need some help to get it the rest of th

Is PERL --> MS SQL really that difficult?

2007-04-25 Thread Robert Denton
des/tutorials/examples etc of how this set up is supposed to work. The examples at dbi.perl.org and in Programming the Perl DBI seem to never include MSSQL examples, unfortunately. Robert

Re: data_source syntax

2007-04-25 Thread Robert Denton
and DBI_DSN env var not set at ./feedback.pl line 11 What am I missing? Robert On Apr 25, 2007, at 12:40 PM, Robert Denton wrote: Okay. I looked breifly at OOB, which looks like quite good software, but unfortunately out of our budget since I am working on a project which has yet to

Registering the ODBC Driver With unixODBC

2007-04-25 Thread Robert Denton
ion t Is there a different way to associate the freetds driver with unixODBC? There doesn't seem to be a man page for odbcinst. Robert

Re: data_source syntax

2007-04-25 Thread Robert Denton
a look at FreeTDS and report back... Robert On Apr 25, 2007, at 12:20 PM, Martin Evans wrote: Robert Denton wrote: Well, as it turns out, I am jumping the gun. Going by some tutorials here: http://www.easysoft.com/developer/languages/perl/ dbd_odbc_tutorial_part_1.html Having unixODBC instal

Re: data_source syntax

2007-04-25 Thread Robert Denton
only have [PostgreSQL] but apparently I also need something that can talk to an MSSQL db. I thought unixODBC came with all the necessary drivers? Can anyone confirm this? Perhaps I need to install a different version? Thanks! Robert On Apr 24, 2007, at 7:17 PM, Ron Savage wrote: Hi Robe

data_source syntax

2007-04-24 Thread Robert Denton
me = 'testUser'; my $password = 'testPass'; $dbh = DBI->connect( $data_source, $username, $password ); Thanks! Robert

Re: Cannot find ODBC driver

2007-04-24 Thread Robert Denton
set it as such and rerun 'cpan DBD::ODBC' and despite numerous warnings, etc it did eventually report install OK. Thanks for your help! Robert On Apr 24, 2007, at 8:56 AM, Martin Evans wrote: Robert Denton wrote: I installed using yum, as in yum install unixODBC. I did a search

Re: Cannot find ODBC driver

2007-04-24 Thread Robert Denton
rom source? I would hope that if it is yumable then the yum install would suffice. Robert On Apr 24, 2007, at 8:17 AM, Martin J. Evans wrote: Robert Denton wrote: Hi, I am hoping someone here recognizes this problem: I have installed unixODBC for use as a driver manager for DBD::ODBC. How

Cannot find ODBC driver

2007-04-23 Thread Robert Denton
st Running make install Make had some problems, won't install Perhaps the problem is that the ODBCHOME env var is set wrong? I have tried the following: export ODBCHOME=/usr/bin export ODBCHOME=/etc both yield the same results... Could someone make a recommedation? Thanks!! Robert

Re: perl dbi memory error?

2007-04-16 Thread Robert Roggenbuck
By the way: In the 3rd step You are using in Your code $sth->execute (and not $dbh->execute, as You typed in Your message)? Don't You? Best regards Robert ravi kumar schrieb: Hai, I am using perl DBI module for fetching data from database. My database table contains

Re: Cannot Install DBD ORacle in Win Xp

2007-03-24 Thread Robert Hicks
t way? Robert

Re: Balasan: Re: Where does "MoveNext" belong to?

2007-02-09 Thread Robert Roggenbuck
ef(), or even dump_results() (depending of the purpose of the dumping). Best regards Robert Patrix Diradja schrieb: Hallo Robert, Vielen Dank fuer Ihre Antwort. But I don't think it's enough for my demand to use fetching of ResultSet that way. Could you help me more, please tell me whe

Re: Where does "MoveNext" belong to?

2007-02-06 Thread Robert Roggenbuck
I do not know anything special about ADO, but try the more usual way to fetch results: my $tab4l; while ( ($tab4l) = $rsnya->fetchrow_array) { print "\$tab4l: $tab4l \n"; } Does it work this way? Best regards Robert Patrix Diradja schrieb: Dear my friends I

Re: Help Needed :: urgent

2007-02-02 Thread Robert Roggenbuck
Can You add some more details about error messages, relevant code snippets and used versions (of Perl, DBI, used drivers, mySQL)? Robert veera sekar schrieb: Hello, I used perl DBI module for my threading concept.but i am getting problem, few things not working because of DBI resource break

Re: DBI Module

2007-01-26 Thread Robert Roggenbuck
What is the error message You get while 'make'? Robert Agarwal, Nalnish (CT) schrieb: Hello, I am trying to make DBI on Solaris 9 machine. Following is the output of perl -V Makefile.PL --- Summary of my perl5 (revision 5.0 version 6 su

  1   2   3   4   >