RE: getting table structure out of MS-Access

2004-03-30 Thread Dennis M. Gray
It worked just fine for me with no changes. Dennis -Original Message- From: David N Murray [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 March 2004 2:38 PM To: Bart Lateur Cc: [EMAIL PROTECTED] Subject: Re: getting table structure out of MS-Access I thought this worked, but when I test

Re: possible memory leak in either DBI or DBD:Oracle (or maybe oci??)

2004-03-30 Thread Roman Hochleitner
On Wed, 12 Nov 2003, Tim Bunce wrote: On Wed, Nov 12, 2003 at 12:34:08PM +0100, Roman Hochleitner wrote: repeated connects to 2 or more 8.1.7 DBs OR schematas DOES leak repeated connects to only ONE (or more) 9.2.0 DB DOES leak so the conclusion could be that it looks like the problem

Re: DBI-state()

2004-03-30 Thread Robert_Doucette
I have a lot of code using those methods. I did not realize they were not standard parts of DBI. What is the alternative mechanism for these methods? Bob Doucette

Re: DBI-state()

2004-03-30 Thread Tim Bunce
On Tue, Mar 30, 2004 at 08:29:27AM -0500, [EMAIL PROTECTED] wrote: I have a lot of code using those methods. I did not realize they were not standard parts of DBI. Can you remember what made you think they were? Anybody else out there using them? What is the alternative mechanism for

Binding data for updating

2004-03-30 Thread Nguyen, David M
I am tasked to develop a GUI web-base HTML using DBI and DBD::Oracle for uses to insert, update, delete data from database. My question is how do I bind actual data from database to let users update it? Some example is really appreciated. Thanks, David

RE: DBI-state()

2004-03-30 Thread CAMPBELL, BRIAN D (BRIAN)
Just out of curiousity, how does DBI-err() even work? Did the DBI module export an object referece called DBI which in turn calls the class method DBI::err? Sorry, DBI.pm is not handy right now, from my current email venue so I can't look at the code for myself today. -Original Message-

Re: DBI-state()

2004-03-30 Thread Meyer, Rob
On Tue, Mar 30, 2004 at 08:29:27AM -0500, Robert_Doucette[at]putnam.com wrote: I have a lot of code using those methods. I did not realize they were not standard parts of DBI. Can you remember what made you think they were? Anybody else out there using them? I use them all over

Re: DBI-state()

2004-03-30 Thread Henri Asseily
I use them all over the place, too. What made me think they were standard is p. 95 of the Feb. 2000 edition of the Cheetah book, which describes them in quite a bit of detail: ...DBI defines several error diagnostic methods that can be invoked against any valid handle, driver, database, or

RE: DBI-state()

2004-03-30 Thread Capacio, Paula J
Tim Bunce: Can you remember what made you think they were? Anybody else out there using them? Rob Meyer: I use them all over the place, too. What made me think they were standard is p. 95 of the Feb. 2000 edition of the Cheetah book, which describes them in quite a bit of detail: I've

Transaction Errors

2004-03-30 Thread Mike Blezien
Hello, I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too: Error: Transactions not supported by database at module. bla..bla MySQL Version: 4.0.17-standard - Official MySQL-standard binary and it

Re: Transaction Errors

2004-03-30 Thread Rudy Lippan
On Tue, 30 Mar 2004, Mike Blezien wrote: Hello, I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too: Error: Transactions not supported by database at module. bla..bla What version of

subject

2004-03-30 Thread Steve McClure
unsubscribe

Re: Transaction Errors

2004-03-30 Thread Rudy Lippan
On Tue, 30 Mar 2004, Mike Blezien wrote: I think this maybe the problem,... I didn't realize that the DBI version was so old... this is on a client's server which I don't have root access too: Versions: DBI: - 1.14 DBD::mysql: - 2.0415 I do not see that version up on CPAN/backpan so I

RE: subject

2004-03-30 Thread Tim Johnson
Before the inevitable sea of flames and unsubscription requests comes crashing down, I'd like to refer anyone who wishes to unsubscribe to a perl.org mailing list to the perl.org website. You will be much more successful, and annoy people a lot less.

What's wrong with UnixDate(30000101,%Y%m%d)?

2004-03-30 Thread Laurie Vien
I know this isn't a DBI-specific question, but some of you are familiar with what I've been doing so I thought I'd post here: The following line of Perl code: $earliest_contact = UnixDate(3101,%Y%m%d); results in the following error messages: D:\process_chunkmail_SEND.pl

Re: What's wrong with UnixDate(30000101,%Y%m%d)?

2004-03-30 Thread Michael Nhan
Hi, You may need to set the timezone as its not set on Winnt by default. Open the properties of My Computer and set a SYSTEM variable TZ to your timezone. Use the form EST5EDT so you don't have to change it every 6 months when going to or from daylight saving. Its in the perldoc of

Re: Transaction Errors

2004-03-30 Thread Rudy Lippan
On Tue, 30 Mar 2004, Mike Blezien wrote: Not sure this may shed some light on the problem,... this is from a running a trace: DBI::db=HASH(0x83614cc) trace level set to 2 in DBI 1.14-nothread Note: perl is running without the recommended perl -w option - STORE for DBD::mysql::db

Re: DBI-state()

2004-03-30 Thread Tim Bunce
On Mon, Mar 29, 2004 at 12:21:05PM +0100, Tim Bunce wrote: On Sun, Mar 28, 2004 at 01:56:05PM -0800, Dean Arnold wrote: Have the DBI-err(), DBI-errstr(), DBI-state() been deprecated ? I see the err() and errstr() are still in the DBI.pm code, but no trace of state() (as far back as 1.38)

Re: Binding data for updating

2004-03-30 Thread Tim Bunce
On Tue, Mar 30, 2004 at 10:28:13AM -0500, Nguyen, David M wrote: I am tasked to develop a GUI web-base HTML using DBI and DBD::Oracle for uses to insert, update, delete data from database. My question is how do I bind actual data from database to let users update it? Some example is really

Re: What's wrong with UnixDate(30000101,%Y%m%d)?

2004-03-30 Thread Tim Bunce
On Tue, Mar 30, 2004 at 04:40:50PM -0500, Laurie Vien wrote: I know this isn't a DBI-specific question, but some of you are familiar with what I've been doing so I thought I'd post here: It's still an abuse of the list and the several thousand people it. There are pleanty of other forums for

RE: What's wrong with UnixDate(30000101,%Y%m%d)?

2004-03-30 Thread Laurie Vien
ok, sorry. will not use it for non-dbi questions in the future. thankfully several people were kind enough to send me answers anyway!! -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 5:45 PM To: Laurie Vien Cc: '[EMAIL PROTECTED]' Subject: Re:

Re: What's wrong with UnixDate(30000101,%Y%m%d)?

2004-03-30 Thread Tim Bunce
On Tue, Mar 30, 2004 at 05:46:19PM -0500, Laurie Vien wrote: ok, sorry. will not use it for non-dbi questions in the future. Thanks Laurie. I know it seems harsh but I have to protect the integrity of the list. Tim. thankfully several people were kind enough to send me answers anyway!!

Access into MVS DB2 using DBI or ???

2004-03-30 Thread Wagner, David --- Senior Programmer Analyst --- WGO
Uuncertain where to start or really what to use to try and see if I can do this? I searched under Activestate and found a large group of DBI modules. Do I just need DBI? Or are there other modules which I work with DBI? I am on XP Professional running service pack 1

Re: DBI-state()

2004-03-30 Thread Dean Arnold
Okay, there seems to be some confusion here. Ultimately the only access to a handle's err, errstr, and state are through method calls on the *handle* (the object reference): $h-err $h-errstr $h-state As a convienience the DBI also provides these *tied* variables $DBI::err

Re: DBI-state()

2004-03-30 Thread Lincoln A. Baxter
What is the alternative mechanism for these methods? $DBI::err, $DBI::errstr, and $DBI::state Tim. I know we have code that uses $h-errstr(). I assume that is not going away. These are documented in the DBI pod SYNOPSIS section: [snip] $rc = $h-err; $str = $h-errstr;

Antwort: Access into MVS DB2 using DBI or ???

2004-03-30 Thread Manfred . Beilfuss
Hi, to access any DB2-Server anywhere from perl you need first the dbi , then you need a dbd e.g. dbd::db2 or dbd::odbc depending on how you intend to connect to db2 and whether you want to connect only to db2 or to different dbms'es using perl. if you have at least one of these installed you