Re: Help!

2002-06-21 Thread Jonathan Leffler
Andrew Crum wrote: > Yes. > gcc does not understand -KPIC. For gcc, substitute -fPIC. > Look for it in the Makefile.PL or possibly in the Makefile generated by > 'make Makefile.PL'. It isn't that simple, in general. If you don't have the same compiler as was used to build Perl, life is going

Re: help with dbd::informix

2002-06-21 Thread Jonathan Leffler
Kirk wrote: >>What is in your $INFORMIXDIR/etc/sqlhosts file? > > ifmx_mother ontlitcp mother ifmx_srvc > #ifmx_mothermother.claimport.com > demo_on onipcshmon_hostname on_servername > demo_se seipcpipse_hostname sqlexec Delete the two demo lines; they don't do

RE: Using Linux and Perl to Access Oracle on NT

2002-06-21 Thread Mark Charshaf
I have a similar situation here with my Oracle 8i database residing on W2k and my client Perl program running on a Linux/RedHat 7.2 machine. After reading about how DBI:Proxy works, I took the existing Perl program and changed the connect to look like this: ### Build Connect Parame

RE: Using Linux and Perl to Access Oracle on NT

2002-06-21 Thread Garrett Ellis
I received a number of replies privately and publicly, and my thanks and appreciation to all who took the time to respond. By installing the Oracle 8i Linux client with the "Programmer" option selected, I was able to acquire all of the necessary libraries for compiling DBD::Oracle. After installa

Re: Using Linux and Perl to Access Oracle on NT

2002-06-21 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Jun 21, 2002 at 02:49:18PM -0700, Garrett Ellis wrote: > My big question is, am I pursuing the proper course of action if I am to use > Perl from Linux to access Oracle on NT? Or is there something else I could > do to accomplish this? No, yo

Using Linux and Perl to Access Oracle on NT

2002-06-21 Thread Garrett Ellis
All, I have a Debian Linux machine which runs the following: Perl 5.005_03 DBI 1.25 [hopefully] DBD::Oracle 1.12 I need to write scripts which will access an Oracle 8i service which is hosted on Windows NT 4. My problem is that I am unable to build DBD::Oracle since it seems to require Oracle d

Re: DBD:Sybase installation

2002-06-21 Thread Michael Peppler
On Fri, 2002-06-21 at 13:56, Bai, Amos wrote: > Now the following was what I did to install DBD::Sybase driver for DBI > == > > # Download Syabse ASE12.5 eval OpenClient library ( for Linux/Red Hat) from > sybase site. The two

DBD:Sybase installation

2002-06-21 Thread Bai, Amos
FYI Here is what I've done this afternoon to install DBD::Sybase driver, and hope that might be of help to those who had troubles in installing: Operating system running: (gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)) #1 Some prerequisites: # you might need to download a binary di

Re: Where is the archive for this list?

2002-06-21 Thread Michael Peppler
On Fri, 2002-06-21 at 10:42, Karyn Ulriksen wrote: > I'd like to bookmark the mail archive site so that I don't have to go to the > list to ask for the umpteenth million time what I know has been asked on > this list... > > I'm having problems with calling an MS SQL stored procedure via DBI (usin

Re: help with dbd::informix

2002-06-21 Thread Kirk
> What is in your $INFORMIXDIR/etc/sqlhosts file? ifmx_mother ontlitcp mother ifmx_srvc #ifmx_mothermother.claimport.com demo_on onipcshmon_hostname on_servername demo_se seipcpipse_hostname sqlexec > What is the value of $INFORMIXSERVER? %> env | grep -i informi

MS SQL Stored Procedure Calls Somewhat Resolved (Was RE: Where is the archive for this list?)

2002-06-21 Thread Karyn Ulriksen
After reading through archives, DBD::Sybase man pages, Perl DBI, google, etc., I finally tried the following and it worked: my($statement) = 'exec myprocedure var1, var2'; my $sth = $dbh->prepare("$statement"); $sth->execute(); $sth->finish(); skipping the whole "do" thing, which somehow seems u

Re: Where is the archive for this list?

2002-06-21 Thread Jonathan Leffler
If it were Informix, you'd use: execute procedure myprocedure($param1, $param2) after worrying about whether the parameter values need to be quoted or not, or: execute procedure myprocedure(?,?) and provide the parameters when you execute the statement. The backslashes would be super

Re: Help!

2002-06-21 Thread Andrew Crum
Yes. gcc does not understand -KPIC. For gcc, substitute -fPIC. Look for it in the Makefile.PL or possibly in the Makefile generated by 'make Makefile.PL'. At 03:55 PM 6/21/2002 +0200, you wrote: >Hallo, >I have tried to install the Mysql module. By the instruction of >http://www.mysql.com/doc

Re: Where is the archive for this list?

2002-06-21 Thread Bart Lateur
On Fri, 21 Jun 2002 10:42:58 -0700, Karyn Ulriksen wrote: >I'd like to bookmark the mail archive site so that I don't have to go to the >list to ask for the umpteenth million time what I know has been asked on >this list... If all else fails, ask Google. But, anyway, links exist both at the Per

Where is the archive for this list?

2002-06-21 Thread Karyn Ulriksen
I'd like to bookmark the mail archive site so that I don't have to go to the list to ask for the umpteenth million time what I know has been asked on this list... I'm having problems with calling an MS SQL stored procedure via DBI (using FreeTDS DBD::Sybase). I've tried the following formats: $

RE: help with dbd::informix

2002-06-21 Thread Jonathan Leffler
What is in your $INFORMIXDIR/etc/sqlhosts file? What is the value of $INFORMIXSERVER? Where is the database server running? What is the value of DBSERVERNAME and DBSERVERALIASES in the database server configuration ($ONCONFIG)? Are you even running IDS, or are you using SE, or XPS, or what? Is th

Re: Passing cmd line args to MySQL from Perl

2002-06-21 Thread Bart Lateur
On Fri, 21 Jun 2002 06:56:51 -0700 (PDT), Tom Atwater wrote: >I am trying to use the LOAD DATA LOCAL INFILE MySQL >command from Perl. Perhaps you can run mysql from the command line, with system()? -- Bart.

Re: Passing cmd line args to MySQL from Perl

2002-06-21 Thread Paul DuBois
At 6:56 -0700 6/21/02, Tom Atwater wrote: >Hello, > >I am trying to use the LOAD DATA LOCAL INFILE MySQL >command from Perl. >(I have Perl v5.6.1 . DBI.pm is dated Feb 6 2002.) > >As of version MySQL 3.23.49 (which is what I have), >MySQL changed so that this command was only >allowed under certai

Help!

2002-06-21 Thread jingyuan wang
Hallo, I have tried to install the Mysql module. By the instruction of http://www.mysql.com/doc/P/e/Perl_installation.html I have a problem in the 3 step:make!!!(I have the sun solaris 8 system.) I have following errors:gcc -c -xO3 -xdepend -DVERSION=\"2.101\" -DXS_VERSION=\"2.101\" -KPIC -

Passing cmd line args to MySQL from Perl

2002-06-21 Thread Tom Atwater
Hello, I am trying to use the LOAD DATA LOCAL INFILE MySQL command from Perl. (I have Perl v5.6.1 . DBI.pm is dated Feb 6 2002.) As of version MySQL 3.23.49 (which is what I have), MySQL changed so that this command was only allowed under certain conditions (see http://www.mysql.com/doc/L/O/LOAD

Re: pdf file -> txt file

2002-06-21 Thread Jeff Seger
Wrong list. This is not a DBI/DBD related question. On Thu, 2002-06-20 at 16:40, perl is wrote: > I want to find a way from PDF file to TXT file (may be > use PDF package in perl). Does anyone know how to do > that, with an example? thank you very much. > > Ping > 6/20/02 > > __

RE: pdf file -> txt file

2002-06-21 Thread Gaul, Ken
Don't know about perl but my linux distribution comes with the Xpdf package which contains the pdftotext utility. I dare say it will be available for most systems. Ken. -Original Message- From: perl is [mailto:[EMAIL PROTECTED]] Sent: 20 June 2002 21:41 To: [EMAIL PROTECTED] Subject: pdf

Re: DBI Prepare statement not working...

2002-06-21 Thread Michael A Chase
On Fri, 21 Jun 2002 00:34:11 -0700 Emma Grant <[EMAIL PROTECTED]> wrote: > Hey Everyone, > > I have a strange problem. > > I have been working with mysql and dbi most of the day, I am just new to > it all. > > I am able to connect my database using the DBI module. When I run the > scri

DBI Prepare statement not working...

2002-06-21 Thread Emma Grant
Hey Everyone, I have a strange problem. I have been working with mysql and dbi most of the day, I am just new to it all. I am able to connect my database using the DBI module. When I run the script on my command line it runs fine, and I get the data that I asked for. But when I try to r

pdf file -> txt file

2002-06-21 Thread perl is
I want to find a way from PDF file to TXT file (may be use PDF package in perl). Does anyone know how to do that, with an example? thank you very much. Ping 6/20/02 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifawor

Re: Exporting umlaut characters using DBD::Oracle

2002-06-21 Thread Dr. Frank Ullrich
I think it's the other way round: On the client side (perl cgi) set NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1;export NLS_LANG (syntax: NLS_LANG = language_territory.charset) Oracle documentation: Choosing a Locale with NLS_LANG A locale is a linguistic and cultural environment in which a system or p