Re: DBI to BerkeleyDB?

ManKyu Han wrote: I moved "prepare" outside loop, so DBD::DBM (BerkeleyDB) works almost twice faster (100 -> 200 /sec) but compare to BerkeleyDB, it is still slower. Since DBD::DBM is now using BerkeleyDB, shouldn't it perform as well as BerkeleyDB ?? (or at least not as bad as what I got?) If

RE: Remote DB2 connectivity in Perl

Hi, It gives the following error message:- DBI connect('DATABASE=hpcindb; HOSTNAME=172.30.0.180; PORT=56000; PROTOCOL=TCPIP ; UID=hpcinst; PWD=hpcin007pwd;','hpcinst',...) failed: [IBM][CLI Driver] CLI000 4W Invalid connection string attribute. SQLSTATE=01S00 at Noname1.pl line 13 Connection fai

Re: DBD::Oracle 1.18 installation problem

Gaul, Ken wrote: [snip] It's not really just because it is not generally a good idea, as far as I remember In order for it to work at all you have to compile any additional modules (or DBI and DBDs anyway) with the same compiler that perl was built with. Generally that is not available or prac

Re: Rows returned are out of sync with the request.

Jared Still wrote: On Tue, 2006-08-22 at 16:11 -0700, Stephen Carville wrote: I'm not quite sure how to describe this problem. When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. Is the Oracle versio

Re: Remote DB2 connectivity in Perl

As the doc from http://search.cpan.org/~ibmtordb2/DBD-DB2-0.80/DB2.pod states, you can create a connection without a DSN quite easily. Here is a small example: #!/usr/bin/perl use strict; use DBI; use DBD::DB2; my $db = "mydb"; my $hostname = "myhostname"; my $port = 6; my $user = "dbuser

Re: Rows returned are out of sync with the request.

On Tue, 2006-08-22 at 16:11 -0700, Stephen Carville wrote: > I'm not quite sure how to describe this problem. > > When I make a call to an Oracle 10g database using DBI and SQLRelay (for > connection pooling) I seem to get results from the previous SELECT. > Is the Oracle version 10.2? Are mul

RE: Oralce10g database compatible Perl version, DBD and DBI -on URGENT Basis

Please go to perl.com and download the current stable version of the Perl source code. It will be called stable.tar.gz. The version is 5.8.something. On Fri, 2006-08-25 at 09:51 +0530, Elangovan, Sasikala wrote: > Hi, > > I am new to this enviroinment. Kindly mention the version explicitly. >

RE: DBI to BerkeleyDB?

ManKyu Han wrote: > Hi. Again. > I did benchmark using BerkeleyDB (Hash) module (random select) and > the number I got was around 10,000 / sec. > I also did similar benchmark using DBD::DBM (with BerkeleyDB Hash > support). But this time, the number was too low. (less than 200 > /sec). > > I

Perl Error

Hello, I am trying to execute a procedure in perlscript from MSSQL server database.I am using CYGWIN console for executing the perl script. The DBI 1.28 is being used with perl5.8.7 here.s Sample code: my $sth = $dbh->prepare("{ call $VIOLATIONS_SP }"); $sth->trace(15); $sth->execute() || d

DBD-Oracle Compatibility

Hi, We have perl 5.6.0 installed here. Current version of DBI is 1.35 and that of DBD::Oracle is 1.12. Now I want to install DBI 1.5 and DBD::Oracle 1.17 so that I can connect to Oracle 10g databases. Will it be a problem? I wouldn't be using Oracle Binaries or Client Libraries. I would contin

Remote DB2 connectivity in Perl

Hello Sir/Madam, I am using the Active Perl for DB2 database automation. My DB2 database is on Linux system. I want to connect the database from windows machine(without DSN) using perl. I have installed all the perl module such as DBI, DBD, DB2, Proxy, JDBC. Please provide me the information abou

RE: Oralce10g database compatible Perl version, DBD and DBI -on URGENT Basis

Hi, I am new to this enviroinment. Kindly mention the version explicitly. Best Regards, Sasikala, GPSy Development Team, HP-GDIC,Chennai,India, Ph:+91-44-3985 3015. From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 11:21 PM To:

Oracle 10G Connectivity with DBI and DBD in UNIX

Hi, In my application, I am using perl version 5.6.1. I am currently using Oracle 9i database and I am using DBI and DBD modules for connecting the application to Oracle . Current Configuration of DBI and DBD: DBI v1.28 DBD-Oracle v1.15 Now I need to migrate my application to Oracle 10G. I wou

RE: DBD::Oracle 1.18 installation problem

>On 8/24/06, Lampang, Arman Elianto <[EMAIL PROTECTED]> wrote: >> >> >> *** Error code 2 >> make: Fatal error: Command failed for target `Oracle.o' >> >> I use perl 5.6.1 bundled with Solaris 10 and I got this error message >> Do anyone can help me ? >Use a current version of Perl. > >I don't kn

Re: DBD::Oracle 1.18 installation problem

Lampang, Arman Elianto wrote: erl5/5.8.4/lib/sun4-solaris-64int/CORE" -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1. 7.0\" Oracle.c "Oracle.xs", line 269: undefined symbol: startp "Oracle.xs", line 269: warning: argument #4 is incompatible with prototype: prototype: pointer to unsigned int : "