Re: MS Access

Install DBI Install DBD-ODBC Use a DSNLess Connction On Fri, 1 Jun 2001 15:50:04 +0530 (IST), Suresh Kannan wrote: I would like to access Microsoft Access database file ie .mdb, through perl under Unix/ Linux platform. Please guide me whether this is possible or not with some

Re: Accented Characters.

A simple solution is: Select column_name from my_table where column_name like 'jose' or you can replace the accented e with the while card % ie 'jos%' Cheers Julio Santiago From: webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Accented Characters. Date: Thu, 24 May 2001 18:30:59

Re: Oracle DBI on Windows NT

Check the TNSNAMES.ORA file on each machine. They shoud only differ on the IP address From: Jones Robert Contr 81 CS/SCK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Oracle DBI on Windows NT Date: Wed, 23 May 2001 16:04:05 -0500 We have Oracle version 8 loaded on Windows NT boxes.

DB Connection

PATH ) Is there a way to conect to a remote DB? Thanks Julio Santiago _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Re: DB Connection

my machine I keep getting the following error: ( DBD:login failed, check ORACLE_HOME/bin is on your PATH ) Is there a way to conect to a remote DB? Thanks Julio Santiago _ Get Your Private, Free E-mail from MSN Hotmail

Re: Problem installing DBD-Oracle

You need to have BDI installed before installing DBD. if you are using ActivePerl the take advantage of the PPM. Open a MSDOS window at command prompt type ppm install nameofthemodule Cheers Julio Santiago From: VIDYASAGAR R NALLU [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problem

DB Connection (Dumb Question)

Hello, I am having a hard time trying to connect to a Oracle DB. If I use: my $dbh = DBI-connect('dbi:Oracle:', $user/$passwd\@$sid, , { AutoCommit = 0, RaiseError = 1, PrintError = 1 }) or die Can't connect:$DBI::errstr; the connection works fine and everything runs smooth. When I try

Error Handling

know that it woulld be good if I upgrade to the latest versions (Perl, DBD and DBI), but that is out of my hands. Any comments, hints or solutions would be appreciate Julio Santiago Unisys Venezuela _ Get Your Private, Free E

RE: Error Handling

; } $insertar_tipo_caso-finish; #fin de la insercción } The ID field must be a unique name, so if the query finds the same ID it should return a message. Instead, the application hangs, the db hangs and I have to wait 10 to 15 minutes for the db to recover. Thanks for your help Julio Santiago From

Re: DBI connection - Another issue

Michael, fellow listers The problem is with the Oracle Web Server, it seems that every time a script is uploaded, it takes several minutes to the server to update the script logs and the Perl Cartridge. Thanks for the help. From: "Michael A. Chase" [EMAIL PROTECTED] To: "

DBI connection - Another issue

Philip, Thanks for the help. I can connect now to the DB but every time I make changes to the file, I have to wait some time before the server can connect again to the DB. From: "Philip Newton" [EMAIL PROTECTED] To: "Julio Santiago" [EMAIL PROTECTED], [EMAI

DBD Oracle Problem

/nsPerl5.005_03/lib/site_perl .) at (eval 2) line 3. Perhaps the DBD::Oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'Oracle' isn't right. Available drivers: ADO, ExampleP, Multiplex, Proxy. at miprueba.pl line 46 Any hints? Thanks Julio Santiago