Re: debugging and stepping into ->do

2018-04-25 Thread Jeff Macdonald
st-upsert-in-mysql/ > > -- Jeff Macdonald Ayer, MA

Re: debugging and stepping into ->do

2018-04-25 Thread Jeff Macdonald
> https://www.tutorialspoint.com/c_standard_library/c_function_getenv.htm > > http://rosettacode.org/wiki/Category:C > > > > And in the “more than you wanted to know” department (including xs > tutorial, perl internals, and how to use gdb on perl) > > > > http://perldoc.perl.org/perlhacktips.html > > http://perldoc.perl.org/index-internals.html > -- Jeff Macdonald Ayer, MA

Re: ORA-12154 - (DBD: login failed)

2016-08-16 Thread Jeff Long
It has been so long since it happened I might be (mis)remembering that the periods were in the path to java being used by the installer(?). Jeff On 08/16/2016 05:51 PM, Jeff Long wrote: Does your current ORACLE_HOME have periods in it? If so the periods could possibly cause the problem. I

Re: ORA-12154 - (DBD: login failed)

2016-08-16 Thread Jeff Long
everything work immediately. Jeff Long On 08/10/2016 10:40 PM, Mani, Arunkumar (BMS - India GDC) wrote: Just following up to see if I can get any help on this. *Arunkumar Mani *ITO Service Delivery Consultant Database Engineering, BMS Account arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.

Re: Nedd your help to get DBD:Sybase working to connect to SQL Server

2016-05-17 Thread Jeff Urlwin
And, to add, I’ve recently come across a new Microsoft ODBC driver for Linux. I haven’t tested it yet, but I can imagine it may address domain logins for example. It’s on my todo list some day. (I recently tested a different driver for OS X that allowed domain credentials — very cool…) > On

Re: Here is a classic one for you

2015-01-02 Thread Jeff Urlwin
Depending upon a few factors- I'd also check the file owner and permissions. We have a nasty requirement that our root umask eliminates group and world access to files created by root. Wreaks havoc on Perl module installations. Sent from my iPhone On Jan 2, 2015, at 12:18 PM, The Doctor

Re: Trouble installing DBD::Oracle in OS X 10.8 ; Oracle 32 bit drivers the issue?

2013-02-06 Thread Jeff Urlwin
I just tried on OSX, using MacPorts perl (64 bit) and get unresolved symbols/dependencies. Lot's of messages from PHPers about this missing dependency: _C_SendHTTPRequest. No solution posted, that I could find yet… On Feb 6, 2013, at 3:54 AM, Jonas Brømsø Nielsen jona...@gmail.com wrote:

Re: Trouble installing DBD::Oracle in OS X 10.8 ; Oracle 32 bit drivers the issue?

2013-02-06 Thread Jeff Urlwin
Den 06/02/2013 kl. 20.05 skrev Jeff Urlwin jurl...@urlwincc.com: I just tried on OSX, using MacPorts perl (64 bit) and get unresolved symbols/dependencies. Lot's of messages from PHPers about this missing dependency: _C_SendHTTPRequest. No solution posted, that I could find yet

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

2012-09-28 Thread Jeff Tate
: 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 to odbcinst.ini (made my own copy (system file)) and change $ODBCINST to address

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

2012-08-15 Thread Jeff Tate
- is that target neutral or is there some additional work they would have to do to enable a Teradata connection. Thanx -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Wednesday, August 15, 2012 4:06 AM To: Jeff Tate Cc: dbi-users@perl.org Subject: Re

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

2012-08-15 Thread Jeff Tate
] Sent: Wednesday, August 15, 2012 10:50 AM To: Jeff Tate Cc: dbi-users@perl.org Subject: Re: Help please with DBD::ODBC on SUSE-Linux On 15/08/12 15:32, Jeff Tate wrote: Couldn't find odbcinst. Compiled test code as instructed. Result of a.out is: size of SQLLEN is 8 Ok, so

Help please with DBD::ODBC on SUSE-Linux

2012-08-14 Thread Jeff Tate
have been posted. Thanx in advance for any and all insights (per the admonition, I looked for a README.linux to review, but there wasn't one) Jeff Tate CHAMPS-DW Project Manager (415) 606 7621 (cell) (517) 993-0946 (OI office) (925) 887 6825 (eFax) mailto:tat...@michigan.gov tat

Strange happenings in ODBC

2011-09-28 Thread Jeff Tate
and not seen any warnings about this. Can anybody tell me if this is a known issue, and if so whether there is a canonical way of handling it. Thanx Jeff Tate CHAMPS-DW Project Manager (415) 606 7621 (cell) (517) 993-0946 (OI office) (925) 887 6825 (eFax) mailto:tat...@michigan.gov tat

RE: Strange happenings in ODBC

2011-09-28 Thread Jeff Tate
every time I run the program in the pair of environments, but I'm sure that's not what you mean. Thanx -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Wednesday, September 28, 2011 4:51 PM To: dbi-users@perl.org Cc: Jeff Tate Subject: Re: Strange

Need help with DBD::Teradata

2011-08-08 Thread Jeff Tate
= { 'Input_Date' = '2011-04-01' }; Explanations and/or work-arounds/corrections will be most gratefully received. Thanx Jeff Tate CHAMPS Project Office DW/TCO Manager (415) 606 7621 (cell) (925) 887 6825 (eFax) mailto:tat...@michigan.gov tat...@michigan.gov (scheduling)

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

2011-06-17 Thread Jeff Macdonald
might be    eval {$unknown-execute();1) or $dbh-do($unknown) which would need to be adjusted to capture the returned values, if needed, and would not work with an object other than a $sth that has an execute method. -- Jeff Macdonald Ayer, MA

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

2011-06-16 Thread Jeff Macdonald
-do($_[0]);    } }; so it looks like yes! I got sidetracked after I asked that message. I'm guessing this is in the DBI code? Thanks for the pointer. -- Jeff Macdonald Ayer, MA

Re: Get off the list

2010-06-17 Thread jeff
No. It just doesn't seem to work. Has anyone tested it? On Wed, 2010-06-16 at 18:27 -0500, David Nicol wrote: does your receiving MTA give you a return-path header? Maybe you forgot you are subscribed under an alias. On Wed, Jun 16, 2010 at 5:47 AM, jeff j...@roqc.no wrote: Anyone know how

Get off the list

2010-06-16 Thread jeff
Anyone know how ? The automated method doesn't work and owner doesn't respond. LOL- You can not use the unsub word anywhere in your email or it get bounced. Is this is some diabolical plot to never let anyone leave. ;-)

[Fwd: Re: Get off the list]

2010-06-16 Thread jeff
Forwarded Message From: jeff j...@roqc.no To: Lesley Binks lesl...@pgcroft.net Subject: Re: Get off the list Date: Wed, 16 Jun 2010 07:39:01 -0400 Well, will try again. Hasn't worked yet. Get a reply asking for confirmation. Send email to confirmation. The dbi-user emails keep

[Fwd: [Fwd: Re: Get off the list]]

2010-06-16 Thread jeff
:-( Oh well. Forwarded Message From: jeff j...@roqc.no To: dbi dbi-users@perl.org Subject: [Fwd: Re: Get off the list] Date: Wed, 16 Jun 2010 07:40:04 -0400 Forwarded Message From: jeff j...@roqc.no To: Lesley Binks lesl...@pgcroft.net Subject: Re: Get off

RE: [Fwd: [Fwd: Re: Get off the list]]

2010-06-16 Thread jeff
LOL On Wed, 2010-06-16 at 13:12 +0100, Neil Beddoe wrote: Welcome to the Hotel California. -Original Message- From: jeff [mailto:j...@roqc.no] Sent: 16 June 2010 12:43 To: dbi Subject: [Fwd: [Fwd: Re: Get off the list]] :-( Oh well. Forwarded Message

RE: [Fwd: [Fwd: Re: Get off the list]]

2010-06-16 Thread jeff
Who is the administrator anyway ? :-) On Wed, 2010-06-16 at 08:06 -0400, jeff wrote: LOL On Wed, 2010-06-16 at 13:12 +0100, Neil Beddoe wrote: Welcome to the Hotel California. -Original Message- From: jeff [mailto:j...@roqc.no] Sent: 16 June 2010 12:43 To: dbi

Re: how to post

2010-04-29 Thread Jeff Zucker
On Wed, Apr 28, 2010 at 7:11 PM, Pam Wampler pwamp...@acttoday.com wrote: How do I post a question to this forum? Not unlike the way you posted that one :-). -- Jeff Thanks, Pam Wampler Senior Oracle Database Administrator Advanced Call Center Technologies, LLC. 3035 Boones

DBI threads

2010-04-07 Thread jeff
When building DBI with threads enabled there is a warning against using threads. Is this really true - does anyone have any experience using DBI with threads ?

RE: Official DBI module for Solaris Box

2010-03-25 Thread Jeff Urlwin
Some points I would add to the below: 1) I agree, grabbing a new perl is usually best, but, sometimes that isn't as easy (politically) as it should be. 2) I have had luck injecting DBI, and other perl modules, into the existing, Solaris perl, using Sun's Studio compiler. I

spammer on dbi-users

2010-03-25 Thread jeff
Who's ever the dbi-users group monitor, please shut this annoying person off: Kenneth Webber mp34...@hotmail.com

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-15 Thread jeff
handles from the other. This is effectively the proxy solution, but you're just forking and proxying to a private sub-process you created. (Full disclosure: I wrote the RMI modules. If they break for you please email me.) Scott jeff wrote: You make an incorrect assumption

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-15 Thread jeff
Scott, Would something like this be close: ## $c = RMI::Client::ForkedPipes-new(); $c-call_use_lib($ENV{MY_PERL_INSTALL}.'/some/path/to/other/Oracle_module'); # A build of Oracle DBD using oracle 8 client not normally in @INC $c-call_use('DBI');

Success ! Different versions of Oracle .so files within single Perl build

2009-12-15 Thread jeff
Thank you, Scott ! In case anyone else needs this sort of setup: I wanted to share this quick dirty successful test using Scott's RMI to connect to both oracle 10 with a wallet and oracle 8 with external authentication - no user names or passwords provided in script. ora8_lib contains the

Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-14 Thread jeff
and the usual setup for Oracle 10 connections with some limited success. What would be ideal would be to have 2 different Oracle DBD connections from within the same perl build. Any suggestions or ideas for potential solutions out there ? Thanks. Jeff

Clarify: Different versions of Oracle .so files within single Perl build

2009-12-14 Thread jeff
To clarify - connecting 'internally' (ie, forcing users to provide username passwords on the GUI ) is not an option - all connections must be 'external'. Forwarded Message From: jeff j...@roqc.no To: dbi-users@perl.org dbi-users@perl.org Subject: Looking for clever solution

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-14 Thread jeff
, preferably the newer 10 client. It shuld work in 99.9% of all cases. If that doesn't work, try 8. If that still does not work, try 9. Alexander On 14.12.2009 13:18, jeff wrote: I need to connect simultaneously to both Oracle 8 and oracle 10 from the same script using 'external' connection

Further Clarification: Different versions of Oracle .so files within single Perl build

2009-12-14 Thread jeff
NO user name/password on interface. The oracle client libraries seem to be mutually exclusive on the above two modes of connection. Forwarded Message From: jeff j...@roqc.no To: dbi dbi-users@perl.org Subject: Clarify: Different versions of Oracle .so files within single Perl build

Question about DBI ProxyServer

2009-12-14 Thread jeff
DBI ProxyServer does not seem to return {NAMES} and {ora_types} on a prepare statement as part of the statement handle hash for an oracle connection. Is there a work around to get this info back on a prepare statement ?

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-14 Thread jeff
that thread startet two months ago. Well, I did, and it seems you are resistant to consulting, both from Oracle experts and from experienced DBI users. So, why do you waste our time? Alexander On 14.12.2009 13:18, jeff wrote: I need to connect simultaneously to both Oracle 8 and oracle 10 from

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

2009-11-02 Thread jeff
W: (03) 98110010 From: jeff j...@roqc.no Date: Fri, 30 Oct 2009 11:59:24 -0400 To: Jared Still jkst...@gmail.com Cc: dbi-users@perl.org Subject: Re: Multiple Oracle clients in same code - no usernames needed PS: Forgot to mention, these apps need to connect to an 8 and a 10

Re: 'External Connections on different Oracle versions.

2009-11-02 Thread jeff
:-) Can't, privileges do vary from SID to SID so need user's real access. DBI::Proxyserver for one or the other is a winner I think. On Mon, 2009-11-02 at 09:10 -0700, Bruce Johnson wrote: On Oct 29, 2009, at 2:15 AM, jeff wrote: Oracle.pm built against 8 works great with Oracle 8 when doing

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

2009-10-30 Thread jeff
and the apps themselves running client 10 - 2 different perl installations. Looks like it will work so far. On Fri, 2009-10-30 at 08:27 -0700, Jared Still wrote: On Wed, Oct 28, 2009 at 12:38 PM, jeff j...@roqc.no wrote: I need to talk to both an oracle 8 and oracle 10 server

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

2009-10-30 Thread jeff
PS: Forgot to mention, these apps need to connect to an 8 and a 10 within the same script simultaneously. :-) On Fri, 2009-10-30 at 08:27 -0700, Jared Still wrote: On Wed, Oct 28, 2009 at 12:38 PM, jeff j...@roqc.no wrote: I need to talk to both an oracle 8 and oracle 10

'External Connections on different Oracle versions.

2009-10-29 Thread jeff
Asked a question yesterday but I don't think I worded it very well so heres another try. I want to do an 'external connection' (i.e., No user or password supplied in DBI-connect ) from a single script to multiple versions of Oracle ( Oracle 8 10 ). What I have found so far is that Oracle.pm

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

2009-10-29 Thread jeff
On Thu, Oct 29, 2009 at 6:41 AM, Martin J. Evans martin.ev...@easysoft.com wrote: 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

Re: 'External Connections on different Oracle versions - more info

2009-10-29 Thread jeff
,PASSWORD from dba_users; OW_ADMIN_UTILS 26749C6AA7E5A212 MYUSER EXTERNAL OWPROJECT F068F107BFFB41DD On Thu, 2009-10-29 at 05:15 -0400, jeff wrote: Asked a question yesterday but I don't think I worded it very well so heres another try

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

2009-10-29 Thread jeff
away with this with an 9 client and if memory serves me correctly it can connect both wallet and the old 8 way DBD::Oracle would then be able to handle both. cheers John Scoles jeff wrote: Please read the next post I put up to rephrase my question. In all cases the connections

Re: 'External Connections on different Oracle versions.

2009-10-29 Thread jeff
: On 29/10/09 09:15, jeff wrote: Asked a question yesterday but I don't think I worded it very well so heres another try. I want to do an 'external connection' (i.e., No user or password supplied in DBI-connect ) from a single script to multiple versions of Oracle ( Oracle 8 10

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

2009-10-29 Thread jeff
way DBD::Oracle would then be able to handle both. cheers John Scoles jeff wrote: Please read the next post I put up to rephrase my question. In all cases the connections have to 'external' - No name or password given. The mechanism changed to the Oracle wallet in 10

Multiple Oracle clients in same code - no usernames needed

2009-10-28 Thread jeff
::Oracle8; my $db3=DBI-connect(dbi:Oracle8:SERV2,'',''); Any ideas as to why? Thanks. Jeff

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

2009-10-28 Thread jeff
Yes, They are built against the different Oracle libs. If anyone has solved this before I'm happy to abandon this strategy :-) On Wed, 2009-10-28 at 19:41 +, Martin J. Evans wrote: jeff wrote: Hi all, Hope someone can help. I need to talk to both an oracle 8 and oracle 10

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

2009-10-28 Thread jeff
to Oracle 7 and 9i. May be a bit less hassle. Steve On Thu, Oct 29, 2009 at 6:41 AM, Martin J. Evans martin.ev...@easysoft.com wrote: 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

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

2009-10-28 Thread jeff
, Oct 29, 2009 at 6:41 AM, Martin J. Evans martin.ev...@easysoft.com wrote: 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

Re: Multiple Oracle clients in same code - Clarify

2009-10-28 Thread jeff
versions PLEASE let me know how. Thanks. Any other solutions would be GREATLY appreciated. ;-) On Wed, 2009-10-28 at 21:18 +0100, Alexander Foken wrote: On 28.10.2009 20:38, jeff wrote: Hi all, Hope someone can help. I need to talk to both an oracle 8 and oracle 10 server in the same

RE: DBD-ADO ithread safety

2009-09-03 Thread Jeff Picklyk
Hi Steffen, Well it is progress but there appears to be issues still. I think the issues I am running into are with my code though and not the ADO. I am no longer getting cloning issues so I'll work on the other issues on my own. Thanks for the quick reply! -Jeff -Original Message

Re: DBD-ADO ithread safety

2009-09-02 Thread Jeff Picklyk
Hi Steffen, I will try out the code later this evening and let you know. Cheers, Jeff - Original Message - From: Steffen Goeldner sgoeld...@cpan.org To: Jeff Picklyk Cc: dbi-users@perl.org dbi-users@perl.org; Adam Kawecki Sent: Wed Sep 02 10:01:21 2009 Subject: Re: DBD-ADO ithread

DBD-ADO ithread safety

2009-09-01 Thread Jeff Picklyk
to be possible when using iThreads. Is there any further updates coming to the ADO driver that will fix this or am I not using it properly? When not using threads I have no issues with the database connection code. For threading I am attempting to create a new connection per thread. Many thanks, Jeff

RE: DBD-Oracle 1.23 testing

2009-06-28 Thread Jeff Urlwin
, then switch users to someone else. Sqlplus does this too, with sqlplus pool_user[real_user]/password_for_pool_user In java, we can actually use Enterprise users (users in the ldap directory without a direct local account) for this and that will be a follow-on patch. Thanks, Jeff

DBD-Oracle 1.23 testing

2009-06-25 Thread Jeff Urlwin
Attached are my quick results from testing DBD::Oracle on 32/64 bit clients, 10.2.0.4 and 11.1.0.7 in various (but not all) combinations. I hope this helps, and I will research more of these, but I thought it might help the group. Regards, Jeff

RE: DBD-Oracle 1.23 testing

2009-06-25 Thread Jeff Urlwin
John -- yes attached again... I tried typing it out in all words, but it was really harder to read than a table. Sigh. I have a vm with oracle 11.1.0.7 (32 bit) so I can try to find some time to actually work on them, rather than just report. Regards, Jeff -Original Message- From

DBD SQL::Statement change in Maintainership

2009-04-17 Thread jeff
. I'd also like to thank the many people over the years who sent bug reports and patches and jumped in to help when I needed it, especially Tim Bunce and Dean Arnold. -- Jeff Zucker (j...@perlmonks, jzuc...@cpan)

The user name is disappearing when I try to connect to a MySQL database

2008-09-03 Thread Jeff Silverman
get the sense from the error message that MySQL isn't complaining about access to a table, but rather access to a database. Thank you Jeff Silverman | Network Support Engineer F5 Networks P 888-882-4447 F 206.272-5541 www.f5.com http://www.f5.com D 206.272.6465 M

Re: DBD::CSV: perl script to read CSV file does not work

2008-06-01 Thread Jeff Zucker
it. -- Jeff See also https://rt.cpan.org/Public/Bug/Display.html?id=20340 Try adding this : $dbh-{'csv_tables'}-{'info'} = { 'file' = 'testtable.csv', 'eol' = \n }; Be sure to use double quotes qround the \n. If that doesn't work try a line ending specific to your OS (e.g

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread Jeff Zucker
to your OS (e.g. '\012' for *nix). -- Jeff Thanks, Prakash use warnings; use DBI; $dbh = DBI-connect(DBI:CSV:) or die Cannot connect: . $DBI::errstr; $dbh-{'csv_tables'}-{'info'} = { 'file' = *'testtable.csv'*}; $sth = $dbh-prepare(SELECT * FROM info) or die prepare: . $dbh-errstr

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread Jeff Zucker
ending, using \n on linux will not work. -- Jeff --- On Sun, 6/1/08, Jeff Zucker [EMAIL PROTECTED] wrote: From: Jeff Zucker [EMAIL PROTECTED] Subject: Re: DBD::CSV: perl script to read CSV file does not work To: Prakash Prabhakar [EMAIL PROTECTED] Cc: dbi-users@perl.org Date: Sunday, June

Re: Need help with aggregate functions and queries that return zero records

2008-03-04 Thread Jeff Zucker
|| []; Sorry for the problems. -- Jeff Ashok Vemuri wrote: Hi, I am having a bit of trouble using aggregate functions with DBI::CSV (version 0.22) and could use some help figuring out why. I have the following code snippet that queries a CSV file named masterdata, located at c:/test/output folder

Re: dbd::csv with col_names but insert / delete / update fail

2007-12-31 Thread Jeff Zucker
are trying to insert into. -- Jeff If the csv has column names, the script (without col names defined) works. sql select works on both csv with or without column names. * not working /root/csv/db/b 1,peter 2,wilson insert.pl use DBI; $dbh = DBI-connect(DBI:CSV:f_dir=/root/csv

Re: Cursors (foiled again)

2007-12-04 Thread Jeff Zucker
[EMAIL PROTECTED] wrote: On Dec 3, 6:37 pm, [EMAIL PROTECTED] (Jeff Zucker) wrote: [EMAIL PROTECTED] wrote: It's been a while since I did dbi, but I used to be quite proficient. Now I'm back to it. What I want to do is read a flat file that has a column value in it, do a select

Re: Cursors (foiled again)

2007-12-03 Thread Jeff Zucker
. -- Jeff So I'd have a perl function that basically does select column1 from table where column2 = (value in file) and returns the column value selected. I can do this with a prepare, execute, and fetchrow_array OK (and it is really slow), but there's got to be a way to set up a select cursor

Re: New edition of the Cheetah?

2007-11-30 Thread Jeff Zucker
(Tim,Jeff); Sorry, even the January 2008 date is at least as exaggerated as the reports of Mark Twain's death. I know you'd like to fetch() the book, but sorry, the wait will be a bit longer. -- Jeff Brian H. Oak wrote: I pre-ordered an updated edition of the Cheetah book, _Programming

Re: Next patch for SQL::Statement

2007-10-12 Thread Jeff Zucker
people involved, if your company should or should not be credited, if you want your email listed, etc. Thanks again for all the work. -- Jeff [EMAIL PROTECTED] wrote: Hi Jeff, as I wrote you last time, we were a little bit unhappy with the method join2tables(). Finally we looked over it a little

Re: DBD::CSV: make test fails

2007-10-12 Thread Jeff Zucker
! -- Jeff [EMAIL PROTECTED] wrote: Hello, [sorry for eventual double posting] since a longer time I am using DBD::CSV for several purposes and were quite happy with it. But now I try to install it on an old Linux Server (SuSE) and the 'make test' fails in nearly every case. Can someone give some

Re: Bugs / Performance-Issues of SQL::Statement

2007-09-10 Thread Jeff Zucker
Hi Jens, Thanks much for the patches. I'll look into them as soon as possible and presumably add them to a new release soon thereafter. I'm happy to discuss your other ideas. Unless they're DBI specific, though, we should probably do that off-list. -- Jeff [EMAIL PROTECTED] wrote: Hi

Re: Connecting to Progress Database

2007-08-16 Thread Jeff Zucker
There seems to be no *progress* on this list since the last time someone asked about a DBD for *progress* (not postgres), someone also mentioned DBD::Pg. Progress is a commercial RDBMS and if there's a DBD for it, I haven't seen one. -- Jeff Alexander Foken wrote: There is DBD::Pg

Re: ShowErrorStatement

2007-08-14 Thread jeff
in the connect statement and omit or die in the rest of the code. -- Jeff

Re: ShowErrorStatement

2007-08-14 Thread jeff
of perl errors in your code. -- Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 14, 2007 04:01 PM To: [EMAIL PROTECTED], dbi-users@perl.org Subject: Re: ShowErrorStatement From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent

DBD::mysql connect dying with Can't initialize character set latin1

2007-06-27 Thread Jeff Nokes
I just posted this on the [EMAIL PROTECTED] mailing list, but there is so little traffic there apparently, I thought I'd post this here too. I hope it is contextually OK. --- Hi, I have a project where I have

Re: question about SQL Parser

2007-06-25 Thread Jeff Zucker
are trying to do, this may not be useful) You may also want to look at some non-Perl SQL parsers such as the one by Mimer. Sorry I can't be more helpful, good luck. -- Jeff P.S. Since this isn't strictly DBI, perhaps you should send your reply to me directly.

Re: :CSV and multi character separator

2007-04-27 Thread jeff
(also by me) for their SQL engine. Does somebody know any DBD for flat files that will meet above requirements? No, sorry, but patches and collaborators welcome. -- Jeff Thanks - Santosh On 4/27/07, Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED] wrote: Santosh Pathak wrote: Hi

Re: :CSV and multi character separator

2007-04-27 Thread jeff
chopping in Perl and the CSV parsing in Text::CSV_XS. -- Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 04:50 PM To: 'Santosh Pathak', 'Garrett, Philip (MAN-Corporate)', dbi-users@perl.org Subject: Re: :CSV and multi character

Re: Problem with DBI:CSV

2007-04-07 Thread jeff
{ SELECT * FROM info WHERE ip = 192.168.1.44 }; Also it looks like you are connecting twice - the first connection in your script will be ignored. -- Jeff SELCT -Original Message- From: Christian Krauße [mailto:[EMAIL PROTECTED] Sent: Saturday, April 7, 2007 10:42 PM To: dbi-users

Re: Problem with DBI:CSV

2007-04-07 Thread jeff
* FROM info WHERE ip = '192.168.1.44' }; To use delimited identifiers would be something like this: my $sql = qq{ SELECT * FROM c:/foo/bar.csv WHERE ip='192.168.1.44' }; -- Jeff Also it looks like you are connecting twice - the first connection in your script will be ignored. -- Jeff

Re: (Fwd) DBI's method for reading [row x,field y]

2007-02-27 Thread Jeff Zucker
will answer your question. -- Jeff

Re: Problems using the DBI class to access CSV files.

2007-01-23 Thread Jeff Zucker
for the data file being used which may depend on whether or not you transferred the file from one platform to another using a line-ending aware process. -- Jeff I'm trying to parse pipe separated log files to search for data so that actions can be taken based on what I find in the log files

Re: New here. dbi:DBM:mldbm=Storable;f_dir=/foo/bar. Inserts when asked to update and other weirdness

2006-09-17 Thread Jeff Zucker
by this bug. Leave your test exactly as-is except put the word TEMP after the word CREATE in your create table SQL statements like so: $dbh-do( Create TEMP Table Folders ( Name TEXT, FolderID INT, Parent INT) ); -- Jeff

Re: New here. dbi:DBM:mldbm=Storable;f_dir=/foo/bar. Inserts when asked to update and other weirdness

2006-09-16 Thread Jeff Zucker
-connect('dbi:DBM:mldbm=Storable;f_dir=/foo/bar'); print $dbh-dbm_versions; __END__ -- Jeff

Re: (Fwd) [perl #40244] req:regarding support for BerkeleyDB

2006-08-28 Thread Jeff Zucker
You can use DBD::SQLite to access SQLite and DBD::DBM to access BerkeleyDB. For fullest access to BerkeleyDB you'll also need MLDBM and SQL::Statement. DBD::DBM comes with DBI, all the other mentioned modules are available on CPAN under their own names. -- Jeff Tim Bunce wrote

Re: DBI to BerkeleyDB?

2006-08-25 Thread Jeff Zucker
interface to pre-existing BerkeleyDB data, then use DBD::DBM. Yes, 0.005 seconds per query is slow compared to other ways to access the data, but in many situations (e.g. a CGI environment), that amount of time will not even be perceptible compared to other things that cost time. -- Jeff

Re: DBD-DBM too slow

2006-08-23 Thread Jeff Zucker
then execute many times in the loop using placeholders you will gain *lots* of time. This is true of most DBDs but especially true of DBD::DBM and other SQL::Statement based DBDs. Also, you might consider using DBI's new profiling capabilities or even Benchmark when doing tests. -- Jeff

Re: problems to connect to a mysql-database

2006-07-10 Thread Jeff Zucker
\...' And a third solution (works fine on windows too): Use forward slashes with either single or double quotes: c:/programme/xampp/... or 'c:/programme/xampp/...' -- Jeff -Original Message- From: Dr. Claus-Peter Becke [mailto:[EMAIL PROTECTED] Sent: Monday, July 10, 2006 10:41 AM

RE: make test fails for DBD::ODBC on Solaris 5.8 with openlink driver

2006-07-01 Thread Jeff Urlwin
because that's more of what they are made for... Jeff From: Baillie, Duncan BGI UK [mailto:[EMAIL PROTECTED] Sent: Fri 6/30/2006 5:02 AM To: dbi-users@perl.org Subject: make test fails for DBD::ODBC on Solaris 5.8 with openlink driver Hi, I have perl 5.8.0

Re: perl- dbi

2006-05-31 Thread Jeff Zucker
-e 'print $DBD::Oracle::VERSION\n' And here's an even better one, assuming a relatively modern DBI: perl -MDBI -e DBI-installed_versions That tells you the versions of DBI, Perl, OS, and all DBDs installed. -- Jeff

Re: execute/quote issue...

2006-05-31 Thread Jeff Zucker
Mason Loring Bliss wrote: $sth-execute($dbh-quote($key)); Don't do that. Either use the quote() method or use placeholders, never both. -- Jeff

Re: DBD::XBase, STDOUT, and IO issue

2006-05-11 Thread Jeff Zucker
of the results. -- Jeff

RE: DBD::Oracle ppd

2006-04-30 Thread Jeff Urlwin
I can tell you that ftp.esoftmatic.com may never be back, per se. I'm not there anymore and someone unplugged a few things and decided to leave it. Sigh. I did feel that it's usefulness was virtually eliminated when ppm started building ActiveState. Jeff -Original Message- From

RE: [dbi] Unicode-Patch for DBD::ODBC

2006-04-14 Thread Jeff Urlwin
Please let me know what you come up with for a final patch and I will try to incorporate this weekend... -Original Message- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 2:56 AM To: Martin J. Evans Cc: dbi-users@perl.org Subject: Re: [dbi]

Re: DBI versiion

2006-04-05 Thread Jeff Zucker
Michael Nhan wrote: print $DBI::VERSION,\n; Of for much more info: perl -MDBI -e DBI-installed_versions -- Jeff Date: Wed, 05 Apr 2006 13:43:30 -0700 From: Jie Zhang [EMAIL PROTECTED] To: dbi-users@perl.org Subject: DBI versiion Hi, We're using oracle 8 and 9. I have code

Re: DBI versiion

2006-04-05 Thread Jeff Zucker
and therefore can't use this particular method and will have to use perl -MDBI -e print $DBI::VERSION instead. -- Jeff

RE: :ODBC in a web application

2006-03-25 Thread Jeff Urlwin
. Then, as far as the environment goes, if you don't specify the Env as per the other posts, you won't get the environment. However, I see here, you are using a UNC to an MDE? I'm not sure what that is (typo? Encrypted MDB?). Jeff -Original Message- From: Robert Hicks [mailto:[EMAIL

RE: can't delete from the 2th level hash

2006-02-06 Thread Jeff Pang
] Sent: Feb 6, 2006 10:07 AM To: dbi-users@perl.org Subject: RE: can't delete from the 2th level hash Jeff Pang [mailto:[EMAIL PROTECTED] wrote: use MLDBM qw(DB_File Storable); the primary problem is this statement: delete $records{$mid}-{$time}; the action of 'delete' don't take effect. and I

RE: can't delete from the 2th level hash

2006-02-06 Thread Jeff Pang
'MLDBM'? thanks. -Original Message- From: Ronald J Kimball [EMAIL PROTECTED] Sent: Feb 6, 2006 10:07 AM To: dbi-users@perl.org Subject: RE: can't delete from the 2th level hash Jeff Pang [mailto:[EMAIL PROTECTED] wrote: use MLDBM qw(DB_File Storable); the primary problem is this statement

RE: Having problems setting up DBD::ODBC

2006-01-30 Thread Jeff Urlwin
Is there a chance you made it a file or some other type of DSN other than global? Jeff -Original Message- From: Mark Nettleingham [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 11:10 AM To: Jeff Urlwin; dbi-users@perl.org Cc: [EMAIL PROTECTED] Subject: Re: Having problems

RE: Future versions of DBI to require perl = 5.8

2006-01-27 Thread Jeff Urlwin
Tim, Is this now going to be rescinded, in light of the rest of the thread with Gisle? Regards, JEff -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 7:03 AM To: dbi-users@perl.org Subject: Future versions of DBI to require perl = 5.8 FYI

  1   2   3   4   5   6   7   8   9   10   >