Perl DBI Interfacer

2002-09-20 Thread Kevin
Hello, I was wondering if anyone knows PERL & DBI, if so please respond to [EMAIL PROTECTED] personally, or to the list My question is, I'm trying to build a 'custom' querier for a survey program... based on the information submitted, the program will generate an SQL Query statement. Th

Problem display MySQL blob properly

2002-09-20 Thread Howard Fuchs
Hi I am using the following PERL (dbi/dbd-mysql) code snippet to display a blob image (stored in a MySQL table) to browser. Problem is that it is displaying as low resolution I guess I am missing something. BTW it displays perfectly well using graphical interface MySQLFront. Any tips or hin

Rbase module?

2002-09-20 Thread Brad Smith
Is there a DBI module for retrieving info from Rbase? Or, am I stuck using the file converter in Rbase? Sincerely, Brad Smith

Problem with mysql permissions

2002-09-20 Thread purnima nagar
Hi, I have mysql installed in my linux instance, say ABC. I recently changed the login permissions only for a particulat instnace, say DEF. Now, when I try to login into mysql in ABC, I am being rejected saying "Access denied". How should I go about solving this problem? Purnima. _

BTrieve databases

2002-09-20 Thread William McKee
Hi all, I have a potential project to write a middleware program to read/write to a BTrieve database. I have found the Perl BTRIEVE::SAVE module on CPAN but it is not recognizing the data format (in particular it is having problems with a string type). I was wondering if anyone else on the lis

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread Tim Bunce
On Fri, Sep 20, 2002 at 07:03:59AM -0500, P. M. Wright wrote: > Here is the error log we get: > *** > [Fri Sep 20 06:02:50 2002] [error] [client 192.168.0.10] File does not > exist: /.../htdocs/funded/align="center" > install_driver(Pg) failed: Can't load > '/usr/local/lib/site_perl/i386-linux/aut

Re: (Fwd) cataloging mess

2002-09-20 Thread Ronald J Kimball
On Fri, Sep 20, 2002 at 03:44:31PM +0100, Tim Bunce wrote: > I need to be able to list all the tables in a connected database, > then for each table list of columns. I tried to use your table_info(), > column_info(), interface but it returns 'DBI::st=HASH(...blah...)'. > Trying to output that ref

(Fwd) cataloging mess

2002-09-20 Thread Tim Bunce
- Forwarded message from Avik <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Thu, 19 Sep 2002 18:06:29 -0700 (PDT) From: Avik <[EMAIL PROTECTED]> Subject: cataloging mess To: [EMAIL PROTECTED] Tim, I need to be able to list all the tables in a connected database, then for e

RE: C interface.

2002-09-20 Thread Sterin, Ilya
You would do the same from C using ODBC libs. But this it totally off-topic here. Ilya -Original Message- From: Janarthanan, Prasanna To: '[EMAIL PROTECTED]' Sent: 9/20/02 3:28 AM Subject: C interface. Is there any interfaces to connect to Driver Manager from c programs like we do from

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread William McKee
On 20 Sep 2002 at 9:40, P. M. Wright wrote: > I added an explicit lib statement to a script pointing to: > /usr/local/lib/perl5/site_perl/5.6.1/i686-linux > and it worked!!! > > Now, I have one more question. How can I add this to @INC so that I > don't need it in all our scripts? Paul, Did yo

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread P. M. Wright
Thanks to all who replied. I added the statement: use lib '/usr/local/lib/perl5/site_perl/5.6.1/i686-linux'; to our scripts, and that solved the problem. Apparently our @INC is incomplete. -- P. M. Wright Norwottuck Technology Resources, Inc. "technology made easy"

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread William McKee
On 20 Sep 2002 at 9:04, P. M. Wright wrote: > Thanks for your persistence. We have dozens of scripts. None that call > the dbi work, and all that don't do. I don't think that woody per se is the > problem. I suspect that it is either the fact that we are running > PostgreSQL version 7.1, manual

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread Waldemar Zurowski
On 20 Sep 2002 07:34:07 -0500 "P. M. Wright" <[EMAIL PROTECTED]> wrote: > On Fri, 2002-09-20 at 06:29, Waldemar Zurowski wrote: > > > > We installed DBI and DBD::Pg > > > > How did you installed it? Are they come from Debian packages, or you installed >them yourself from CPAN? > > > > Waldema

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread Jeff Seger
If the version of Perl that came with woody is a pre-compiled one, it's important to compile the DBD/DBD packages with the same compiler. You may want to re-install perl by compiling it from CPAN, then re-install DBI/DBD by compiling it yourself. HTH, jeff On Fri, 2002-09-20 at 08:34, William

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread William McKee
On 20 Sep 2002 at 8:07, P. M. Wright wrote: > Thanks. > I should have been a little more explicit in my original post. I used CPAN > to recompile DBI, DBD::Pg and Date::[various], AFTER the upgrade and still > no joy. :-( Hmm, have you tried a simple test script to rule out the possibility that

Re: How to execute file containing sql statements using dbi.

2002-09-20 Thread William McKee
On 19 Sep 2002 at 15:10, Arvind Raina wrote: > My requirement is to execute a set of sql statements which are stored in a > file . > > I wanted to know if there is any method of doing the same using dbi . Sure, open the file with 'open', read the commands and pass them to dbi. If you are using

Re: Broken DBI after upgrading debian to Woody

2002-09-20 Thread Waldemar Zurowski
On 20 Sep 2002 07:03:59 -0500 "P. M. Wright" <[EMAIL PROTECTED]> wrote: > We recently upgraded our server to woody, which brought perl up to > 5.6.1. > After the upgrade our CGI Postgres scripts don't work. > Other CGI scripts (with no database interface) work, and psql works in > interactive mod

Broken DBI after upgrading debian to Woody

2002-09-20 Thread P. M. Wright
We recently upgraded our server to woody, which brought perl up to 5.6.1. After the upgrade our CGI Postgres scripts don't work. Other CGI scripts (with no database interface) work, and psql works in interactive mode. We are running PosrgreSQL 7.1, which was manually compiled (before the upgrade).

How to execute file containing sql statements using dbi.

2002-09-20 Thread Arvind Raina
Hi , My requirement is to execute a set of sql statements which are stored in a file . I wanted to know if there is any method of doing the same using dbi . If not can you suggest some methods of doing the same. Thanks , Arvind - Do you Yahoo!? New DSL Inte

C interface.

2002-09-20 Thread Janarthanan, Prasanna
Is there any interfaces to connect to Driver Manager from c programs like we do from perl using ODBC.pm? Please suggest me some links as where i can get to know about this? thanks Prassana