Problem with a conection...

Hi. I have a program that takes around six or seven hours to execute. I don't kwon when but, during the execution of a SELECT statement, I get this error: DBD::Oracle::db prepare failed: ORA-02396: exceeded maximum idle time, please connect again (DBD ERROR: OCIStmtExecute/Describe) [for

Re: Problems with Oracle 8 and 9

At 12:34 14/02/2006, you wrote: Thanks to all for yours answers. I could connect with the batabase because the problem isn't with it, but with the SYNONYMS. If I connect from a Oracle 9 database and trie to use a synonym that connects with a Oracle 8 DB I can't. I always obtain this error:

Re: [cgiapp] Best free DB for a web-based Perl app response results...

Maybe you should try its correct spelling, SQLite :) On 12/1/05, Jesse Erlbaum [EMAIL PROTECTED] wrote: Hey Jeff -- Regarding teh rest of your email, I have got to agree with you, most web apps use way more resources than they could possibly need, but you know what ? As a counter to your

Re: Windows - DBD::SQLite

Yes, you can install it using ppm, Of course you could have known this by yourself by typing search DBD::SQLite at the ppm prompt. On 11/7/05, Owen [EMAIL PROTECTED] wrote: Can any Windows user advise me if the module DBD::SQLite is available as part of the windows packaging system with Perl

Re: What is wrong with select?

Hi, It works. But when I do: $StateProvince = 'PA'; my $sql1 = SELECT id, name_short, name_long FROM states WHERE name_short=$StateProvince; $sth1 = $dbh-prepare($sql1); # $sth1-execute(); I get a message that: DBD::mysql::st execute failed: Unknown column 'PA' in 'where clause'

Re: NLS issues if using DBD::Oracle from mod_perl2

Actually, Andrew Hartford pointed me to the answer: http://marc.free.net.ph/message/20020822.021000.44773e7a.en.html Thanks everybody, Juan Natera On Tue, 8 Feb 2005 11:25:54 -0700, Reidy, Ron [EMAIL PROTECTED] wrote: Sounds like a permissions problem. - Ron Reidy Lead

NLS issues if using DBD::Oracle from mod_perl2

connection error. Any pointer? Thanks in Advance. Juan Natera

Re: NLS issues if using DBD::Oracle from mod_perl2

Message- From: Juan Jose Natera [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 11:45 AM To: DBI Users Subject: NLS issues if using DBD::Oracle from mod_perl2 Hello, I am getting this error while trying to connect to an Oracle server from a custom perl module: DBI connect

parameter binding issues with DBD::Oracle

? Thanks in advance, Juan Natera

RE: DBI-connect using 'old-style' syntax

Ok Michael... then I am going to remove it Thank you. -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 12:16 AM To: Juan Arturo Veliz Carmona; [EMAIL PROTECTED] Subject: Re: DBI-connect using 'old-style' syntax On Mon, 25 Aug 2003 17

RE: (Fwd) DBI-connect using 'old-style' syntax

, ora_session_mode = ORA_SYSDBA }) or die DBI-errstr; Sorry, for my english. Thank You. Juan -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 4:31 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: (Fwd) DBI-connect using 'old

FW: Connection to remote DB

I want connect to a remote Oracle server host. Into the client I don't have install Oracle, so when I install DBD-Oracle fails because I don't have the ORACLE_HOME... into my system. How can I do it? Must to be Oracle and Perl into the same machine? -Original Message- From: Juan David

Connection to remote DB

At this moment,I only have done connections to local DB. But, can I do connections from a host without a DB, installing into the client the correct DBD, to a host DB server? Does the S.O. must be the same into client and server? Thanks

[Q] Connection to Sybase started to fail

is as follows: Open Client Message Layer 5, Origin 3, Severity 5, Number 6 ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect Software Versions: Perl 5.6.1 DBI 1.21 DBD Sybase 0.94 Any suggestions? Juan Natera

dbd::oracle support for oracle 9?

is there any support for dbd::oracle on oracle 9 yet?

RE: How to get out of dbi-users

O.K Thankyou Users, please remove me from these lists [EMAIL PROTECTED] as per the given instructions below: Best Rgds Juan -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 10:18 AM To: [EMAIL PROTECTED]; John P Crisci Subject

Problems connecting to Oracle (ORA-01034: ORACLE not available)

/ocommon/nls/admin/data Any help will be appreciated. Regards, Juan Jose -- fortune generated signature: Vote anarchist

Re: Problems connecting to Oracle (ORA-01034: ORACLE not availabl e)

Hi, On Tuesday 21 August 2001 11:26, you wrote: // Well do you have the DB server running? // // Ilya Yeah, It's Oracle 7.3 running on an IRIX server regards, Juan Jose -- fortune generated signature: Don't let your mind wander -- it's too little to be let out alone.

Fwd: Re: Problems connecting to Oracle (ORA-01034: ORACLE not availabl e)

hi again Sorry, i meant an AIX server regards, Juan Jose -- fortune generated signature: (null cookie; hope that's ok)

Re: Problems connecting to Oracle (ORA-01034: ORACLE not availabl e)

should talk to the DBA right? Regards, Juan Jose -- fortune generated signature: Death is nature's way of saying `Howdy'.

can't use DBD::Sybase

line 451 that is in the install_driver part. I really need to get this working, if any of you can point me to the right direcction... I use Perl 5.6.0 on Slackware Linux 7.1, I need to query a database on a Win NT server with Sybase ASE 11.9.2 Thanks in advance, Juan Jose -- fortune generated

Re: can't use DBD::Sybase

message number=17001 severity=10 state=0 line=0 server=MY_SERVER text=Language cmd: select * from fault Any ideas? Regards, Juan Jose -- fortune generated signature: If you didn't get caught, did you really do it?

[Q] Connecting to Oracle

this? Then i tried the other way DBD::Oracle, when i start reading the README files i see i need some ORACLE_HOME env. variable and some libraries and other stuff, i go to Oracle's Site and i couldnt find what i am looking for. Can someone give me a hand? I am compleatly clueless Regards, Juan Jose

Installing DBI on Linux

Hello, I installed DBI-perl-bin-0.93-1cl.i386.rpm and then mysql-DBI-perl-bin-1.825-1cl.i386.rpm, but I can not connect with the database. Perl and MySQL are already running. Is this the right process? Am miss something? Am I have to install perl-DBD-MySQL-1.2215-1.i386.rpm too? TIA, Juan.

Connecting to MySQL

??? TIA, Juan.

RE: Connecting to MySQL

$DBI::errstr\n; ? I tried see the result: http://www.farmaceutico-online.com.br/cgi-local/mysqlt.cgi Is it possible that the server don't have DBI instaled? Thank you very much. Juan

Re: Connecting to MySQL

, and I just get the title returned. Thanks. Juan.

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Hi, I get the error when I try to connect.. :o(( What's wrong? TIA, Juan.

Installing DBI

Hi, I'm trying to install DBI for use with mySQL without success. I'm following this steps: 1. perl Makefile.PL 2. make Here I get an error that float.h were not found. glibc-devel is installed ... What am I doing wrong? Does DBD::MySQL must be installed first? TIA, Juan.

Funny Error at DBD::ADO

nd with the CPAN installation module, trying to install the ODBC driver without success finally I realised I did not need it. But now the computer is failing whenever I run the script above, the error says something like No type library matching "Microsoft Activex Data Objects 2.0 Library" found at C:/Apache/site/lib/DBD/ADO.pm line xxx. Any idea how to fix this stupid error I made ? Rgds, Juan Antonio

Re: MSAccess DB Problem

using the IndigoPerl one cause it comes with the Apache Web Server integrated. Regarding helping you I am still in nappies but If you indicate me where to start working I will be happy to give the community a hand. Best regards, Juan Antonio Celaya

MSAccess DB Problem

SN available Proxy -No DSN available mysql -No DSN available Aplicacion de acceso a la Base de Datos de Conectividad/BODY/HTML Sorry I a sent you such a huge email, I am not even registered in your email List, but I want you to have the whole picture. Could you please register me, My n

RE: MSAccess DB Problem

Hi Phil, When I used [0] I was trying to refer to the ADO DSNs but it doesnt matter really, by changing this sentence I will get the DSNs for every Driver Installed, see what I got replacing the sentence. Content-Type: text/html !DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"