On Wed, 22 Jan 2003, Ron Stephan wrote:
..
> I have two old dinosaur apps in FoxPro 2.5 DOS (50 to 150k records
> relational).
If the data format is dBase III/IV then use DBD::XBase to read them.
---
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
Thanks to all for the answers. To summarize:
DBD::Oracle generally preferable for cross-platform portability and
performance, but for some specific issues (like inter-database
portability) DBD::ODBC may be necessary.
Much appreciated folks,
Paul
On Wed, 22 Jan 2003, Steve Haslam wrote:
> > I a
On Wed, Jan 22, 2003 at 11:25:59AM -0800, Ron Stephan wrote:
> I have two old dinosaur apps in FoxPro 2.5 DOS (50 to 150k records
> relational).
> My goal is to move them to the net with Perl 5.8 using MySQL running on
> a RedHat Box.
> What format is the easiest way to get my data ported over?
Hi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jan 22, 2003 at 06:00:58PM -0500, [EMAIL PROTECTED] wrote:
> DBD::Oracle::db do failed: ORA-00054: resource busy and acquire with
> NOWAIT specified (DBD ERROR: OCIStmtExecute) at D:\dev\ff\bin/FFOra.pm
> line 1012.
> ORA-00054: resource busy a
I believe you can to it tWo ways (both specific to oracle): Set Transaction
(something) may do it, and I am pretty sure you can do it right in your sql
statement. If you do, the script will hang forever until the resource is
available or the database is shutdown. You can also loop on attempting
>
>
> Firstly, I want to apologise for disturbing you, but I am
> unsure how to proceed with this.
No problem.
> Basically, I used a PC for quitre a few years, regularly
> running perl scripts to take Lotus Notes data into an Access
> database, and then produce various reports from vari
>
> > I am confused on which DBD to choose, though. Should I use
> DBD::ODBC
> > or DBD::Oracle? I can set up ODBC DSNs on each computer
> without much
> > problem so both are equally convenient. But is there any
> other reason
> > or criteria I can use to make this choice, perhaps based
>
> I installed the DBI and DBD::Oracle modules on a server by
> copying all the
> required files from my workstation. I had originally used
> the files that I had
> pulled from ActiveState via ppm. When I encountered issues
> (DBD::Oracle is old
> on ActiveState), I downloaded the latest
I'm running into a sporadic error in a perl script that is accessing an
Oracle database, sometimes at the same time that other perl scripts are
also accessing the same database. Apparently, I'm getting into some
resource-sharing trouble, but I don't know how to avoid it. I'm
occasionally getting
Steve Haslam [[EMAIL PROTECTED]] wrote:
> > I am confused on which DBD to choose, though. Should I use DBD::ODBC or
> > DBD::Oracle? I can set up ODBC DSNs on each computer without much problem
> > so both are equally convenient. But is there any other reason or criteria
> > I can use to make th
Help - again.
I have two old dinosaur apps in FoxPro 2.5 DOS (50 to 150k records
relational).
My goal is to move them to the net with Perl 5.8 using MySQL running on
a RedHat Box.
What format is the easiest way to get my data ported over?
Ron "Elvis" Stephan
310-840-4111
[EMAIL
> I am confused on which DBD to choose, though. Should I use DBD::ODBC or
> DBD::Oracle? I can set up ODBC DSNs on each computer without much problem
> so both are equally convenient. But is there any other reason or criteria
> I can use to make this choice, perhaps based on performance or stabi
Hi all,
I am about to start working on an Oracle 9i DB within a very small (4
computer) network. The entire network is behind a firewall and is on a
local IP range (i.e. 192.168.xxx.xxx). I will be writing DBI scripts to
access the DB from any of these computers. This is *not* CGI, just
plain-o
Hi Aigar,
Directly from the DBI documentation:
'There is no need to quote values being used with Placeholders and Bind
Values.'
So the driver is flawed if you need to be doing this. If it works and you
can live with the untidyness though, stick with it. I suggest you report
your bug as well
Same script with Apache 1.3.27, DBD-ODBC 1.03, DBI 1.32 and Perl 5.8.804
works without any problems! sounds like a PerlIS Bug...
Alex
At 11:42 -0500 1/22/03, Tay, William wrote:
Hi,
I am developing a Web application that invokes a Perl script, which in turn
access a mysql database.
I have copied a sample database named books to the directory
/usr/local/mysql/data of a Linux machine,
Bzzzt!!
That will *not* work unless t
How about supplying an 'ls -l' listing of the
/usr/local/mysql/data/books directory. Also give us the
database connect code, and a snippet of you "select" code.
I haven't used mysql in a while, but it looks to me like there
are some case sensitive issues with your file names.
--
Hardy Merrill
S
How does mysql know where to look for the files you moved?
Your perl sounds fine, but mysql can't find the files that
make up your database.
1)
Set up a database through mysql, instead of moving files around.
2)
Modify the vars in your script to use that database.
3)
Run the new script
It will
Hi,
I am developing a Web application that invokes a Perl script, which in turn
access a mysql database.
I have copied a sample database named books to the directory
/usr/local/mysql/data of a Linux machine, where I have also installed an
Apache Web server, mysql, DBI module and a DBD::mysql dr
Hi Laird,
You're right. The typos where unnecessary, but as you say: they don't affect
the real problem.
The code I refer to is in mysqlPP.pm. The most interesting part is on line
312 (for version 0.03):
$statement =~ s/\?/$quoted_param/e;
This clearly shows that if the $quoted_param do
Hi Aigars,
Firstly you have a couple of typos:
*in the table metadata - should be "primary key" not "primary_key".
*in the script,
$sth->execute($id, $data); should be
$sth->execute($data, $id);
*in the SQL: "INSERT INTO test_blobs" is not valid; should be
"INSERT INTO test_blobs (data
Hi,
Since I've gotten no answer from the maintainer of the DBD::mysqlPP driver,
I thought I'd forward my question here, so that if anyone here has an answer
or hint they might tell me.
TIA
--
Aigars Grins
-Original Message-
From: Aigars Grins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
22 matches
Mail list logo
