AW: How to upload binary in Mysql through DBI/Perl?

2003-05-30 Thread André Halama
> My question is if anyone has any samples of code on how to > properly handle a > POST form submition that contains a binary file. Then how to insert this > data into Mysql through perl/DBI module. hi, recently i wrote some script that uploads solutions to perl excercises for a class i'm teachi

RE: Fw: DBD-Oracle-1.14, Oracle 9.2.0, Linux (debian woody)

2003-05-30 Thread Steve Haslam
Hm, sorry to chip in at this point-- I didn't see any earlier messages in this thread. > On Sat, May 03, 2003 at 10:37:52PM -0500, Jay Strauss wrote: > > Found my problem, thought it was an oracle issue, but it was DBI (as you > > probably already know). But it's interesting. I used apt-get to i

Re: Fw: DBD-Oracle-1.14, Oracle 9.2.0, Linux (debian woody)

2003-05-30 Thread Dr. Frank Ullrich
Hi, Tim Bunce schrieb: > > On Sat, May 03, 2003 at 10:37:52PM -0500, Jay Strauss wrote: > > Found my problem, thought it was an oracle issue, but it was DBI (as you > > probably already know). But it's interesting. I used apt-get to install > > DBI. There is no apt package for DBD-Oracle, so I

Re: shutdown

2003-05-30 Thread Tim Bunce
No. Sorry. Tim. On Thu, May 29, 2003 at 03:10:55PM -0500, Jones Robert Contr TTMS Keesler wrote: > > Is there a way to shut down an Oracle database with DBI? > > > Robert Jones, BSCS, BSP > >

Re: DBD::Oracle1.13 Supports TIMESTAMP datatype of Oracle9i, recommen dation.

2003-05-30 Thread Tim Bunce
TIMESTAMP will be supported in the next release. Thanks. Tim. On Thu, May 29, 2003 at 04:45:23PM +0800, XIE,KE-XIAN (HP-China,ex2) wrote: > Hi bunce, > I have compiled your DBD::Oracle1.13 on HP-UX11i together with perl > 5.8.0 64bit, DBI 1.30 64bit. > When I use dbi to fetch the data ty

How does DBI::ProxyServer work ?

2003-05-30 Thread Anil Menon
Hi All, I was just going thru the CPAN Site to find a ODBC solution and found this one. I have a couple of queries regarding its usage. It would b of great help if someone could put me on the right track. my queries are 1) Currently I talk to a FileMaker DB thru ODBC (openLink DAS), from my linu

(Fwd) DBI::ProxyServer 0.3005 (1.37)

2003-05-30 Thread Tim Bunce
- Forwarded message from Dan Wilga <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Thu, 29 May 2003 16:27:02 -0400 To: [EMAIL PROTECTED] From: Dan Wilga <[EMAIL PROTECTED]> Subject: DBI::ProxyServer 0.3005 (1.37) Hi there, I would have posted this to perl.dbi.dev, but my news

dbi to P4 Service Center database?

2003-05-30 Thread Fernando Ochoa de Zuazola
Hello, Does somebody know if there is some DBI driver developed for accessing to Peregrine Service Center database? I tried the ODBC driver (it works for Crystal Reports) but can't access. Regards, fernando. Fernando Ochoa de Zuazola T-Systems ITC Services España, S.A. Técnico de Sistemas

[Fwd: Re: non-ascii text]

2003-05-30 Thread Jonathan Leffler
I saw the question on [EMAIL PROTECTED] and accidentally replied to just the questioner and not the mailing list too - sorry. The questioner also asked the question on the comp.databases.informix news group, so I'm copying my answer there too; there shouldn't be a need for others to chip in unl

Re: query (urgent)

2003-05-30 Thread Anil Menon
hi, The best and fastest solution create a new user name with password in mysql and use this in yr DBI->connect. ps: test the new user name and passwd from the cmd prompt as mysql -u -p -h ++ We have developed forum scripts in Perl-Cgi. When our script runs on the web server using mysql da

Re: query (urgent)

2003-05-30 Thread David N Murray
My initial reaction is to say RTFM, but since this is so urgent, that's probably not an option. The error you seem to be reporting is a trivial one and is covered quite well in the MySQL documentation regarding security. If I were to be rude, I'd say 'use the correct password', or 'make sure you

Re: non-ascii text

2003-05-30 Thread Víctor A. Rodríguez
Hi Brian, Brian McLaughlin said: > How can I copy the contents of one char column to another if the data > contains "illegal characters" ?? A trick that can be used is to code it base64 prior to store and decode it after retrieve : X = unbase64( read( write ( base64 ( X ) ) ) ) Hope this helps

Re: Problem testing Sybase Perl module

2003-05-30 Thread Dave Miller
On 5/29/2003 3:25 PM -0400, PETRY, MICHAEL D (AIT) wrote: > We are upgrading our Sybase from 11.0 to 12.5. I am having problems testing > the DBD-Sybase-1.00 module on Solaris 2.8. > > I set > EXTRA_LIBS=-ltli > In the config file. > > ENVIRONMENT VARIABLES ARE SET TO: > $ echo $SYBASE > /opt/syb

Re: non-ascii text

2003-05-30 Thread John Saylor
hi ( 03.05.29 13:08 -0700 ) Brian McLaughlin: > The problem is that the encrypted passwords have non-ascii characters. > How can I copy the contents of one char column to another if the data > contains "illegal characters" ?? schema change. -- \js

Re: query (urgent)

2003-05-30 Thread John Saylor
hi ( 03.05.29 18:09 +0530 ) OMKAR (Pramod Shanbhag): > LoveMatch has exited with the following error: > Can't connect to mySQL database. Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) > Kindly provide us the solution on urgent basis. too much hate. -- \js

RE: Query(urgent)

2003-05-30 Thread Herbold, John W.
Ummm two thing about your request... 1) It might help if you give us the error. 2) It might help if you say please. Thanks, John W. Herbold Jr. IS Specialist/DBA -Original Message- From: OMKAR (Pramod Shanbhag) [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 7:37 AM To: [EMAIL

shutdown

2003-05-30 Thread Jones Robert Contr TTMS Keesler
Is there a way to shut down an Oracle database with DBI? Robert Jones, BSCS, BSP

Re: How to upload binary in Mysql through DBI/Perl?

2003-05-30 Thread David N Murray
I haven't played with file uploads in awhile, but it seems to me that the easiest way would be to upload the binary as a file, then read the file and store it into the BLOB column, deleting the file when done. Are you actually collecting the binary data off the form, as an INPUT item, or will the

Problem testing Sybase Perl module

2003-05-30 Thread PETRY, MICHAEL D (AIT)
We are upgrading our Sybase from 11.0 to 12.5. I am having problems testing the DBD-Sybase-1.00 module on Solaris 2.8. I set EXTRA_LIBS=-ltli In the config file. ENVIRONMENT VARIABLES ARE SET TO: $ echo $SYBASE /opt/sybase12.5 $ echo $SYBASE_OCS OCS-12_5 $ echo $LD_LIBRARY_PATH /opt/sybase12.5

non-ascii text

2003-05-30 Thread Brian McLaughlin
Hi all. I have two Informix servers -- a production box and a test box. Passwords to our vendor's software are stored encrypted in a char(20) column. I want to copy passwords from production to test. I've written a perl script to fetch the password from production and I want to put that passwor

query (urgent)

2003-05-30 Thread OMKAR \(Pramod Shanbhag\)
We have developed forum scripts in Perl-Cgi. When our script runs on the web server using mysql database we get following error. LoveMatch CGI Error LoveMatch has exited with the following error: Can't connect to m

Query(urgent)

2003-05-30 Thread OMKAR \(Pramod Shanbhag\)
We have developed forum scripts in Perl-Cgi. When our script runs on the web server using mysql database we get following error. Kindly provide us the solution on urgent basis. Regards Pramod

DBI->connect(AVSEDWT) failed: ERROR OCIEnvInit

2003-05-30 Thread Ahsen Javaid
We have shifted from Oracle 8i to Oracle 9i on Solaris. Perl DBI was working fine. While shifted to Oracle 9i, Perl DBI is giving error as mentioned in the subject Any work around regarding any update and settings required is urgently required. Thanks and Regards, Ahsen

DBD::Oracle1.13 Supports TIMESTAMP datatype of Oracle9i, recommen dation.

2003-05-30 Thread XIE,KE-XIAN (HP-China,ex2)
Hi bunce, I have compiled your DBD::Oracle1.13 on HP-UX11i together with perl 5.8.0 64bit, DBI 1.30 64bit. When I use dbi to fetch the data typed of TIMESTAMP of Oracle9i, during the prepare station, error occurs that "data type 187 is not supported". And I search the file oci8.c and db

RE: DBI->connect failing when run from inetd, but not from comman dline hp-ux

2003-05-30 Thread LBaxter
You need to ensure the SHLIB_PATH is correctly set in your environment for the oracle lib directory against which you linked. This must be set PRIOR to loading DBD::Oracle. You could do it in a BEGIN block in your main script. Or you could wrap your script invocation with a shell script that does

DBI->connect failing when run from inetd, but not from commandline hp-ux

2003-05-30 Thread Joshua Horton
Hi, This is my first post, but it is definitely a plea for help, as I have not found anyone else with this particular issue. I have been using DBI and DBD::Oracle for three years now on four enterprise systems. I have upgraded the system once already successfully, due to the requirement to u

Re: Thanks

2003-05-30 Thread Jeff Zucker
David Wilson wrote: The page works fine, and submitting the form invokes the CGI script. However, if I browse the page via its MS file name, that is C:\Program Files\Apache Group\...page01.htm That may be what you type into a browser, but what the browser translates that to is: file:///c:

Thanks

2003-05-30 Thread David Wilson
I wanted to say thanks to all those who helped me through the initial bumps with Apache and DBI. Over the course of maybe a week and a half, I have installed and set up a local Apache server on Win XP, got CGI's working properly, and am doing some elementary DBI and SQL. MySQL and DBD::mysql are

How to upload binary in Mysql through DBI/Perl?

2003-05-30 Thread Vinnie Lima
Hi, First post to the group so please take it easy on me =) I need to be able to allow a user (through the use of forms) to upload a binary into a mysql table. I have the table somewhat defined with "BLOB" column type and all. My question is if anyone has any samples of code on how to properly