Kathy Kunkel/tech/clovisusd is out of the office.

2003-04-03 Thread KathyKunkel
I will be out of the office starting 04/01/2003 and will not return until 04/07/2003. I will respond to your message when I return.

segmentation fault on connection down with freetds

2003-04-03 Thread Giacomo
Hello. I'm using the freeTDS driver (0.61) and the DBD::Sybase (0.95) module on Solaris (and Linux) to connect to a MS SQL-Server 7 database on a Windows machine. It works mostly fine but I have problems when the connection to the DB Server goes down. If I stop the DB Server or if the TCP/IP conn

DBI and Forks

2003-04-03 Thread Mike Boyle
I am trying to fork off a series of child processes (~10) having each child connect to an Oracle 8i database . The child should process the data and return a value (using pipes). This works great for one child, but when I create a series of children I get the following Windows Error Message:

Problems compiling DBD::Oracle, Sol9, Ora9

2003-04-03 Thread Nathan Wiger
Hi all- I'm trying to compile the Perl DBD::Oracle on Solaris 9 64-bit against Oracle 9.2.0.1.0 and am having marked problems getting it to link and run. I get either: 1) on link, bad elf class: ELFCLASS32, or 2) on run, bad elf class: ELFCLASS64 That is, if I force it to 32-bit, it

ERROR: ORA-03106: fatal two-task communication

2003-04-03 Thread rbamidip
I get the following error while trying to open a database handle, not sure if this is a Oracle problem or the DBI problem, any pointers are appreciated.. ERROR: ORA-03106: fatal two-task communication Thx Ramesh

ORA 03106

2003-04-03 Thread rbamidip
I get the following error while trying to open a database handle, not sure if this is a Oracle problem or the DBI problem, any pointers are appreciated.. ERROR: ORA-03106: fatal two-task communication Thx Ramesh

Problem compiling DBD

2003-04-03 Thread Sancho, Nick
I am running HP/UX 11.0 with ANSI C compiler. I am compiling DBI ok but heres what happens when I try to install DBD # make realclean rm -f blib/script/ora_explain rm -rf Oracle.c Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def ./b lib Makefile.aperl

RE: DBD-ODBC Strange Behavior?

2003-04-03 Thread Waldemar Zurowski
my $sql = use eggsupp; select * from filesupp where owner like 'Adam%' ; Why don't you do: $dbh-do('use eggsupp'); and then: normally run your query, with that first 'use eggsupp' removed. Waldemar

RE: DBI and Forks

2003-04-03 Thread Hapworth, Adam
Are you making one Connection then passing it off to the children? I also had issues with that a while ago. I then resorted to having each child make its own connection to the DB and it worked fine. HTH Adam -Original Message- From: Mike Boyle [mailto:[EMAIL PROTECTED] Sent:

MaxRows for selectcol_arrayref

2003-04-03 Thread Wojciech Pietron
Hi Tim, have you ever planned to add 'MaxRows' attribute to selectcol_arrayref function as it is in selectall_arrayref? I thing there is a need for such an attribute. Best regards, Wojciech Pietron

Re: DBI and Forks

2003-04-03 Thread Tim Bunce
fork on windows is emulated using threads - and that's a whole big can or worms. Tim. On Wed, Apr 02, 2003 at 10:19:18AM -0500, Mike Boyle wrote: I am trying to fork off a series of child processes (~10) having each child connect to an Oracle 8i database . The child should process the data and

DBD cmd-line client driver?

2003-04-03 Thread Bakken, Luke
Hi all, I'm in the process of writing a DBD driver in perl that works by controlling our company's db command-line client. All is going well and I can get info out of/into the db. What I'm wondering is if there is a better example DBD driver for this scenario - currently I'm just using the info

RE: Need to Get the count of number of rows of select st without usin g count(*)!

2003-04-03 Thread Vonerden, Gary
in the initial sql statement could you just add 'count' before my $stamt = $dbh-prepare(select * from ab_tran); after my $stamt = $dbh-prepare(select count(*) from ab_tran); -Original Message- From: Veera Prasad [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 4:17 PM To:

Re: ERROR: ORA-03106: fatal two-task communication

2003-04-03 Thread David N Murray
Can post a sample of your connect statement? Searching Google Groups for ORA-03106 yields something about not using BEQ. I've only ever done TCP/IP connections, so the problem may be in your tnsnames.ora file. Can you connect from sqlplus on the same machine? Dave On Apr 2, rbamidip scribed:

Re: DBI and Forks

2003-04-03 Thread Dean Arnold
I've had the same issue with 631 (and DBD::Teradata), and yes, the connection is created within the child...the issue seems to relate to the way Win32 Perl emulates fork(). I've noticed there's a newer AS build of 5.6.1 available, but alas I've had no time to install/test it (any volunteers ?).

Re: MaxRows for selectcol_arrayref

2003-04-03 Thread Tim Bunce
On Thu, Apr 03, 2003 at 04:36:36PM +0200, Wojciech Pietron wrote: Hi Tim, have you ever planned to add 'MaxRows' attribute to selectcol_arrayref function as it is in selectall_arrayref? I thing there is a need for such an attribute. I hadn't thought about it. I could do I guess. Tim.

Re: segmentation fault on connection down with freetds

2003-04-03 Thread Michael Peppler
On Wed, 2003-04-02 at 04:50, Giacomo wrote: Hello. I'm using the freeTDS driver (0.61) and the DBD::Sybase (0.95) module on Solaris (and Linux) to connect to a MS SQL-Server 7 database on a Windows machine. It works mostly fine but I have problems when the connection to the DB Server goes

RE: DBD-ODBC Strange Behavior?

2003-04-03 Thread Michael Peppler
On Tue, 2003-04-01 at 06:20, Adam Peterson wrote: here's a sample piece that works when i don't include use eggsupp; my $sql = use eggsupp; select * from filesupp where owner like 'Adam%' ; $sth = $dbh-prepare($sql); The use database command has to be

ANN: DBD::Sybase 1.00

2003-04-03 Thread Michael Peppler
The uploaded file DBD-Sybase-1.00.tar.gz has entered CPAN as file: $CPAN/authors/id/M/ME/MEWP/DBD-Sybase-1.00.tar.gz size: 165041 bytes md5: dd54243c6aefa22bafdf7d9752c1489f Yes, this is finally the 1.00 release of DBD::Sybase. Recent changes: Release 1.00 Added

Re: ERROR: ORA-03106: fatal two-task communication

2003-04-03 Thread Christian Merz
Hello, besides looking at your tnsnames.ora file (and validating with an ordinary sqlplus connect) you should take care about your ORACLE_SID and TWO_TASK environment Variables (on UNIX). See below. ORA-03106: fatal two-task communication protocol error This points to an Oracle nativ connection

Re: DBD::Informix on Solaris 6 and Solaris 8

2003-04-03 Thread Jonathan Leffler
Jeroen Willems wrote: Currently, I'm using an Informix 9.x database, running on a Solaris 6 machine. I've built an application around this database server, using - Perl 5.6.0 , - Tk800.20 , - DBI 1.13 and - DBD:Informix all compiled on a Solaris 6 machine using an older Informix 7.x server. The

Re: (Fwd) CPAN Upload: T/TI/TIMB/DBD-Oracle-1.14.tar.gz

2003-04-03 Thread Tim Bunce
On Thu, Apr 03, 2003 at 11:02:19AM +0200, H.Merijn Brand wrote: On Thu 27 Mar 2003 19:13, Tim Bunce [EMAIL PROTECTED] wrote: file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.14.tar.gz size: 199667 bytes md5: ec364509df5dfd57a4c05e2c410f358f =head1 Changes in DBD-Oracle 1.1427th