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

2005-12-01 Thread Juan Jose Natera
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

Re: Windows - DBD::SQLite

2005-11-07 Thread Juan Jose Natera
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 Pe

Re: What is wrong with select?

2005-04-02 Thread Juan Jose Natera
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 '

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

2005-02-08 Thread Juan Jose Natera
--- > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > -Original Message- > From: Juan Jose Natera [mailto:[EMAIL PROTECTED] > Sent: Monday, February 07, 2005 11:55 AM > To: Reidy, Ron > Cc: DBI Users > Subject: Re: NLS issues if using DBD::Oracle from mod_perl2 &

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

2005-02-07 Thread Juan Jose Natera
Reidy > Lead DBA > Array BioPharma, Inc. > > > -Original 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 getti

NLS issues if using DBD::Oracle from mod_perl2

2005-02-07 Thread Juan Jose Natera
Hello, I am getting this error while trying to connect to an Oracle server from a custom perl module: DBI connect('','x',...) failed: ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.) I get this error _only_ if I use my module from mod_perl2, otherwise it works fine (a command lin

parameter binding issues with DBD::Oracle

2005-01-31 Thread Juan Jose Natera
Hi, I have a problem trying to make a few queries work with parameter binding: This code works fine: use DBI; use DBD::Oracle qw(:ora_types); my $dbh = DBI->connect($dsn,$user,$password); my $sth = $dbh->prepare('SELECT * FROM price WHERE id = 1'); $sth->execute(); my ($id,$price) = $sth->fetch

[Q] Connection to Sybase started to fail

2002-06-03 Thread Juan Jose Natera Abreu
Hello everyone, I have some applications running under Debian Woody connecting to a Sybase DB Server. they were working correctly until a few hours ago. No changes were made at the DB Server or the Debian Client, I get the same error msg with isql, sqsh or my dbi scripts, the error message is

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

2001-08-21 Thread Juan Jose Natera Abreu
Hi again, // Are you able to log in with sqlplus??? After doing some research, the answer is yes and no if i try to connect to that SID (development) i get the error described before, if I change to the production SID, then i can connect with sqlplus and even the script works. I guess i sho

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

2001-08-21 Thread Juan Jose Natera Abreu
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)

2001-08-21 Thread Juan Jose Natera Abreu
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.

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

2001-08-21 Thread Juan Jose Natera Abreu
Hello people, I just installed Oracle 8.1.7 for Linux on Slackware Linux 7.1, I am using Perl 5.6.1, DBI 1.19, and DBD-Oracle 1.07. After installing / compiling every thing i tryed the following script: # - #!/usr/bin/perl use DBI; $database = 'DB'; $driver = 'Oracle'; $user = 'USERNAME'; $

Re: can't use DBD::Sybase

2001-08-09 Thread Juan Jose Natera Abreu
Hello again, I Read some faqs, the script using DBD::Sybase doesnt segs faults anymore, after changing the locates.dat file of ASE 11.9.2 However now i get the following message: Server message number=17001 severity=10 state=0 line=0 server=MY_SERVER text=No language handler installed.Server me

can't use DBD::Sybase

2001-08-09 Thread Juan Jose Natera Abreu
Hello people, I have 2 days trying to figure out this, i still cannot see the light. I have tried with freetds and i get the 'seems_to_be_famous' no executing statement message, I have tried the ctlibs from the DBD::Sybase page, but the DBD::Sybase compilation fails and doesnt get compleate

[Q] Connecting to Oracle

2001-07-17 Thread Juan Jose Natera Abreu
Hello People, I need to be able to query an Oracle 7.3.X Server running on an AIX machine, I want to use Perl / DBI of course, running on Slackware Linux 7.1. I have a problem, which way to go, DBD::Oracle or DBD::ODBC?, lets try the "easy one" since i have used ODBC (not under Linux), then