Re: MS ACCESS text field truncated

Hi Tim, The doc says LongTruncOK and LongReadLen have nothing to do with writing data into DB. They are only for reading. In addition, I am dealing with Text type data in MS ACCESS, not LONG type. Thanks, J. Tim Johnson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Look in the docs

RE: [cpan #5556] make test cause core dump when perl(5.8.2) built with both use64bitint and usethreads options

1. logs for following are attached perl Makefile.PL -vmake.perl.log make make.make.log make test make.test.log 2. Oracle is v9.2.0.1.0-32bit 3. $ perl -V Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration: Platform:

[Fwd: Réf. : Re: Problem with DBD::Oracle]

Keep this on the list, not private email. Original Message Subject: Réf. : Re: Problem with DBD::Oracle Date: Fri, 5 Mar 2004 09:41:36 +0100 From: [EMAIL PROTECTED] To: Michael A Chase [EMAIL PROTECTED] Hi this is the completed error message when I do the make test Thank's

RE: Accessing oracle from windows 2000

Just wanted to let people know what worked for me for connecting to an Oracle database on a Windows XP platform, using both DBD::ODBC *AND* DBD::Oracle. Thanks to Jeff Urlwin for all the help - see Jeff's suggestions below for reference. NOTE that my version of ActiveState Perl is 5.8.2. 1.

Benchmarking Oracle connections on Windoze XP with DBD::ODBC and DBD::Oracle

I got some interesting results with this benchmark that I'd like some help interpreting. This test is on a Windoze XP box comparing: ora_odbc_driver (Oracle supplied(?) ODBC driver) ms_odbc_driver (Microsoft supplied ODBC driver) ora_dbd_driver (DBD::Oracle) Here is my test script:

Réf. : [Fwd: Réf. : Re: Problem with DBD::Oracle]

Hi Thanks for your help, we found the error source. When we installed Oracle client we don't have the C++ Lib. Now I have, one another problem with sql syntaxe. I try to translate my perl script from Mysql to Oracle, but when I excute this script I have this kind of error [Fri Mar 5 17:11:19

RE: MS ACCESS text field truncated

D'oh! You're right. I guess I should get more sleep before answering questions... -Original Message- From: Jason [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 2:16 PM To: [EMAIL PROTECTED] Subject: Re: MS ACCESS text field truncated Hi Tim, The doc says LongTruncOK and

RE: MS ACCESS text field truncated

Hi Tim, The doc says LongTruncOK and LongReadLen have nothing to do with writing data into DB. They are only for reading. In addition, I am dealing with Text type data in MS ACCESS, not LONG type. Just to butt in here...you should have specified that better in your original posting.

Re: MS ACCESS text field truncated

Hello Jeff, At first, I did put type longvarchar, then I read the doc and copy the type LONGVARCHAR to my code. All the other parts very simple because I use the default way to make connection and create prepared statement. The field $address is mapped to Text field of size 255 in MS ACCESS DB,

RE: Benchmarking Oracle connections on Windoze XP with DBD::ODBCand DBD::Oracle

I got some interesting results with this benchmark that I'd like some help interpreting. This test is on a Windoze XP box comparing: ora_odbc_driver (Oracle supplied(?) ODBC driver) ms_odbc_driver (Microsoft supplied ODBC driver) ora_dbd_driver (DBD::Oracle) Here is my

RE: Questions about connectivity

ok. thanks for the reply :) -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 1:30 AM To: Burak Gursoy Cc: [EMAIL PROTECTED] Subject: Re: Questions about connectivity On Thu, Mar 04, 2004 at 09:44:11PM +0200, Burak Gursoy wrote: The mysql client

How to format a DATE field?

OK--here's probably the easiest question ever posted on this forum. I can tell it's Friday night, cuz my brain must be completely shut down. I'm reading records from an Oracle database using the DataHash method. One of the fields in the records being retrieved is type DATE. I want to convert

GOT IT--NEVER MIND! RE: How to format a DATE field?

Never mind--I got it--I just have to use substr instead of sprintf. Thanks, folks. Laurie -Original Message- From: Laurie Vien [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 6:15 PM To: [EMAIL PROTECTED] Subject: How to format a DATE field? OK--here's probably the easiest

Can I reset the pointer in a DataHash?

I would like to read all the records from a table in once, in a single SELECT, and then use while($db-FetchRow()) and the %row = $db-DataHash() method to process through them. Is there a way to reset the pointer to the beginning of the recordset so that I can process the records a second time

Re: Réf. : [Fwd: Réf. : Re: Problem with DBD::Oracle]

[EMAIL PROTECTED] wrote: Now I have, one another problem with sql syntaxe. I try to translate my perl script from Mysql to Oracle, but when I excute this script I have this kind of error [Fri Mar 5 17:11:19 2004] Telagene_oracle_test.pl: DBD::Oracle::db do failed: ORA-00911: invalid character