Re: DBD::ODBC does not support bind_param_inout?

2007-08-01 Thread Bart Lateur
Sorry for the late reply, but I'm only scanning my inbox now. On Wed, 18 Jul 2007 17:35:51 +0800, hu.darren wrote: my $csr = $dbh-prepare(q{ BEGIN :whoami := PLSQL_EXAMPLE_DARREN.FUNC_NP; END; }); but I failed with: Can't bind unknown placeholder ':whoami' at

Re: error

2007-08-01 Thread Martin Evans
Samuel_Zheng wrote: this is the error message, Because it on a Chinese 2003 server and the chinese is missing some bytes. I cannot read what it says. Does anyone can tell what it means and suggest things to try? thanks, samuel Software error: DBI connect('btn','',...) failed: [Microsoft][ODBC

Re: error

2007-08-01 Thread Samuel_Zheng
Hi Martin, I know Chinese. Just that it is not displayed properly Icannot read it. what more info is needed? Do you think. I use the excel to open the ACCESS97 database and it was fine. regards, samuel - Original Message - From: Martin Evans [EMAIL PROTECTED] To: dbi-users@perl.org

Re: Comments on stability of SQLite for storage

2007-08-01 Thread Hildo Biersma
Daniel Kasak wrote: Greetings. I'm beginning a project where I have to store some stuff on the disk somehow. At present, I'm using SQLite *only* for temporary storage. I had planned to dump data ( which is basically config data, but is absolutely critical in terms of keeping the project held

Re: error

2007-08-01 Thread Martin Evans
Samuel_Zheng wrote: Hi Martin, I know Chinese. Just that it is not displayed properly Icannot read it. what more info is needed? Do you think. I use the excel to open the ACCESS97 database and it was fine. regards, samuel With a 42000 error should be some text describing the error - the

Re: Comments on stability of SQLite for storage

2007-08-01 Thread rahed
[EMAIL PROTECTED] (Daniel Kasak) writes: Greetings. I'm beginning a project where I have to store some stuff on the disk somehow. At present, I'm using SQLite *only* for temporary storage. I had planned to dump data ( which is basically config data, but is absolutely critical in terms of

RE: Guidance on setting up multiple database handles to be used in one script

2007-08-01 Thread Rutherdale, Will
It's not clear from your message what you want. If you mean that you want to open a db handle or set of handles in the same way with the same options across a number of scripts, why don't you just create a function for that? You can create your own Perl module exporting that function and just

Re: Cross-Database query engine?

2007-08-01 Thread Jenda Krynicky
On 25 Jul 2007 at 9:43, Daniel Kasak wrote: Greetings. We've been stuck for quite a while between SQL Server and MySQL, and while doing cross-database queries is drop-dead simple in MS Access, it's relatively painful in Perl. Are there any solutions at present for running queries across

Re: Guidance on setting up multiple database handles to be used in one script

2007-08-01 Thread John Costello
On Tue, 31 Jul 2007, Russ wrote: Over time the need to connect to the same database in different scripts became apparent. To do this I began by creating a package that contained all the $dbh handles (not advisable) as if one fails then your whole script is no good. So I then split them

Bundle::DBI Failure

2007-08-01 Thread Scott T. Hildreth
When I run 'cpan' and try to install Bundle::DBI, DBI::Shell fails...but more importantly PlRPC-0.2020 fails with, Writing Makefile for RPC::PlServer perldoc -t lib/RPC/PlServer.pm README No documentation found for lib/RPC/PlServer.pm. make: *** [README] Error 1

Re: dbi access ODBC

2007-08-01 Thread Jenda Krynicky
Hi Martin, you directed me to an article by microsotf to fix an error which is caused when my perl script access a access97 file.The article tell to chk the windows temp folders. that time I got the problem fixed on my XP machine. This time, I am having the same error on a windows server

Re: dbi access ODBC

2007-08-01 Thread Samuel_Zheng
= [EMAIL PROTECTED] === http://Jenda.Krynicky.cz = When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery __ NOD32 2431 (20070801) Information __ This message was checked by NOD32 antivirus system

Re: Cross-Database query engine?

2007-08-01 Thread Daniel Kasak
On Wed, 2007-08-01 at 22:13 +0200, Jenda Krynicky wrote: On 25 Jul 2007 at 9:43, Daniel Kasak wrote: Greetings. We've been stuck for quite a while between SQL Server and MySQL, and while doing cross-database queries is drop-dead simple in MS Access, it's relatively painful in Perl.

Re: Guidance on setting up multiple database handles to be used in one script

2007-08-01 Thread Henri Asseily
Defining connections in one place is one thing. Using the same connection from different places is another. The first point, defining connections in one place, is something quite trivial that is unnecessary to discuss. Basically it means specifying the dsn string, and that can be done in a

most common kinds of cross-database queries

2007-08-01 Thread Darren Duncan
At 9:03 AM +1000 8/2/07, Daniel Kasak wrote: Nice suggestion ( we do this from Excel sometimes ), but I'm actually planning on *competing* with Access, and not using it to do the heavy lifting for me. ie this is for a generic query engine, and not for a specific task I have in mind. As a

Re: most common kinds of cross-database queries

2007-08-01 Thread Amos Shapira
On 02/08/07, Darren Duncan [EMAIL PROTECTED] wrote: What do you think would be the most common scenarios of a cross-database query? Speaking only theoretically for now but one use case I can vaguely imagine would be something we are working on right now: We have a large SQL Server database