Re: DBI/DBD::DB2

2006-06-23 Thread Jonathan Leffler
On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, I am trying to write a perl script to connect to our DB2 database and do some basic SQL queries. But I'm having trouble with making everything play nice. I'm on WinXP, and did a manual build of DBI with Visual Studio's nmake.

DBI/DBD::DB2

2006-06-23 Thread Kevin.D.Wendt
Hello, I am trying to write a perl script to connect to our DB2 database and do some basic SQL queries. But I'm having trouble with making everything play nice. I'm on WinXP, and did a manual build of DBI with Visual Studio's nmake. That all went fine (as far as I can tell). So I downloaded

Problems building DBD 1.51 on Solaris 9

2006-06-23 Thread Brad Kroeger
Hello, I'm having problems building DBD 1.51 on Solaris 9. I have not found anything in google that has helped with with this problem, aside from that I should be using a compiler that was built on Solaris 9. I needed a 64 bit version of Perl for an application I am working on. I built gcc

Re: Stupid newbie question?

2006-06-23 Thread Martin J. Evans
Ben wrote: Hey guys, I'm very green at DBI stuff, so maybe this is a stupid question. But after going through the DBI man page and searching the web for a couple hours, I can't find the answer. All I'm looking to do is to walk the result set from a select statement more than once. Every exampl

RE: Stupid newbie question?

2006-06-23 Thread Reidy, Ron
Isn't this an ODBC thing? Did you look at the DBD::ODBC docs? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Ben [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 1:48 PM To: dbi-users@perl.org Subject: Stupid newbie question? Hey guys, I'm very green at DBI s

Stupid newbie question?

2006-06-23 Thread Ben
Hey guys, I'm very green at DBI stuff, so maybe this is a stupid question. But after going through the DBI man page and searching the web for a couple hours, I can't find the answer. All I'm looking to do is to walk the result set from a select statement more than once. Every example I can find

Re: DBD::Sybase misleads me?

2006-06-23 Thread Chuck Fox
[EMAIL PROTECTED] wrote: The sp_configure option is dynamic, but only affects future connections. It is an upper limit, and the client has to specifically request the larger packet size to get it. Otherwise the default 512 byte packet size is used. Michael In addition to setting the configura

RE: multiple perl installs - OT

2006-06-23 Thread Reidy, Ron
Put the path to that Perl interpreter into /etc/profile before the paths to the other Perl interpreters. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: LLC [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 4:52 PM To: dbi-users@perl.org Subject: multiple perl

Sybase ASE max network packet size

2006-06-23 Thread David Goodman
This is a server wide configuration setting. The benefit of using larger packet sizes is that you can get better efficiency and throughput from the network by sending data in larger packets, i.e. the same amount of data is transmitted in a smaller number of large packets and thus incur less overhea

Re: DBD::Sybase misleads me?

2006-06-23 Thread David Goodman
This topic really has nothing to do with DBD::Sybase. Truth be known, DBD::Sybase would never mislead anyone. Sybase ASE configuration parameter "max network packet size" is a static parameter; the dataserver needs to be restarted for it to take effect. The same applies to "default network packet

Re: DBD::Sybase misleads me?

2006-06-23 Thread michael . peppler
The sp_configure option is dynamic, but only affects future connections. It is an upper limit, and the client has to specifically request the larger packet size to get it. Otherwise the default 512 byte packet size is used. Michael Extranet [EMAIL PROTECTED] - 23/06/2006 14:48 To:matthew.

Re: DBD::Sybase misleads me?

2006-06-23 Thread Matthew Persico
On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I suspect that this should really be addressed to a Sybase list. Sorry about that. However, what may happen is that the server doesn't have enough network memory available and therefore is not able to allow the client to connect with t

Re: DBD::Sybase misleads me?

2006-06-23 Thread Alexander Foken
What does "sp_configure max network packet size" affect? The current connection or the entire server? If it's the connection, it simply can't work: The commercial app is forked, and has no relation to DBI's connection, so it creates and uses its own connection (though it seems to fail to set t

Re: DBD::Sybase misleads me?

2006-06-23 Thread michael . peppler
I suspect that this should really be addressed to a Sybase list. However, what may happen is that the server doesn't have enough network memory available and therefore is not able to allow the client to connect with the 16k packet size. You should probably take a look at the "additional network m

DBD::Sybase misleads me?

2006-06-23 Thread Matthew Persico
I have a commercial program that accesses a Sybase 12.5 server. It has an option to change the packet size of the communucation frame with the server, but you have to know what size you want. Sooo, in my perl program, I connect to the database with DBD::Sybase, execute a sp_configure 'max network

Re: Unable to install DBD::Oracle on windows XP

2006-06-23 Thread Ron Savage
On Fri, 23 Jun 2006 10:51:59 +0530, R, Karthik P wrote: Hi > I have installed Active Perl on my windows XP and also installed > DBI package. You need DBI. > But When I try to install DBD::Oracle I get the follow error You don't need DBD::Oracle. Connect via DBD::ODBC. -- Cheers Ron Savage, [E