Re: Problems Installing DBD::MySQL

2004-12-23 Thread Lincoln A. Baxter
On Thu, 2004-12-23 at 18:07 -0800, Tony McCray wrote: In addition to everything other folks have said there is some something much more fundamentally wrong with this picture: [snip] (look at the perl version named:) > I have perl 5.8.6 built for i686-linux and mysql Ver 14.7... [snip] (look a

Re: Problems Installing DBD::MySQL

2004-12-23 Thread Tony McCray
Thanks Dave, you helped a lot actually. It turns out that I have a file in /lib called libnss_files.so.2. I made a copy of the file and got rid of the '.2' extension. I had to do the same thing with libnss_dns.so. I haven't tested it yet, but make, make test, and make install all seemed to work fin

Re: DBD Errors for New Oracle Install

2004-12-23 Thread Michael A Chase tech
On 12/23/2004 12:15 PM, Peter Barnett said: We have a new DBD install that is giving us trouble. The perl files are linked from a directory /obase/tools/perl/perl to /usr/bin/perl. The DBD is installed in the /obase/tools/perl/dbd directory. Not much to go on but the developers are very new to p

Re: Problems Installing DBD::MySQL

2004-12-23 Thread David N Murray
Tony, You seem to be missing libnss_files.so. I'm no familiar with SUSE, so I can't tell you where to obtain it from, or if its even used. On my RedHat box, it's in /lib. It implements the 'files' portion of the Name Service Switch system (but I don't know what that is, either). On my box, 'ma

Problems Installing DBD::MySQL

2004-12-23 Thread Tony McCray
I'm trying to install DBD::MySQL onto a SUSE Linux machine with the 2.4.19 kernel. I have perl 5.8.6 built for i686-linux and mysql Ver 14.7 Distribution 4.1.7 for pc-linux (i686). I have tried everything I can find on this and other lists to try, and as far as I can tell I have everything installe

DBD::SQLite and bind?

2004-12-23 Thread Owen
I have a DBD::SQLite program where one of the searches goes through the 10 columns looking for a match. Compared to a single column LIKE search, it's a bit slow -- $SQL = "select * FROM oz_boer order by ln"; $cursor = $dbh->prepare($SQL); $cursor->exe

Re: DBD::Sybase::db do failed: Server message number=2762

2004-12-23 Thread Michael Peppler
On Thu, 2004-12-23 at 15:10, Anderson, James (Company IT) wrote: > I googled and found a reference to this, but the link was dead :-( There > no longer appears to be anything in the mail archive. > > DBD::Sybase::db do failed: Server message number=2762 severity=16 > state=3 line=1 server=NYTIBA8

RE: DBD Errors for New Oracle Install

2004-12-23 Thread Reidy, Ron
And, the problems are? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Peter Barnett [mailto:[EMAIL PROTECTED] Sent: Thu 12/23/2004 1:15 PM To: dbi-users@perl.org Cc: Subject:DBD Errors for New Oracle Install We have a new DBD install that is giv

DBD Errors for New Oracle Install

2004-12-23 Thread Peter Barnett
We have a new DBD install that is giving us trouble. The perl files are linked from a directory /obase/tools/perl/perl to /usr/bin/perl. The DBD is installed in the /obase/tools/perl/dbd directory. Not much to go on but the developers are very new to perl and I am not too far ahead of them. ===

Fw: USE Statement

2004-12-23 Thread Ron Wingfield
Oops, . . .forgot to "reply to all". - Original Message - From: Ron Wingfield To: Hardy Merrill Sent: Thursday, December 23, 2004 2:15 PM Subject: Re: USE Statement First, from a "first-time'er", thanks to all who have responded. This is a GREAT forum! BTW, I'm running FreeBSD 4.8; M

RE: DBD::Sybase::db do failed: Server message number=2762

2004-12-23 Thread Anderson, James (Company IT)
Thanks! That seems to have solved it. -Original Message- From: Terence J. Young, D.C. [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 1:09 PM To: Anderson, James (Company IT); dbi-users@perl.org Subject: Re: DBD::Sybase::db do failed: Server message number=2762 try turning a

Re: DBD::Sybase::db do failed: Server message number=2762

2004-12-23 Thread Terence J. Young, D.C.
try turning autocommit to 1 (ktrue). Create Table cannot be done within an implied transaction. I believe you will alos have to have chained transactions turned off also. terry Anderson, James (Company IT) wrote: I googled and found a reference to this, but the link was dead :-( There no longer

Re: USE Statement

2004-12-23 Thread Hardy Merrill
Ron, your message did make it to the list :) And from 'perldoc -q use': == What's the difference between require and use? Perl offers several different ways to include code from one file into another. Here are the deltas between the va

RE: USE Statement

2004-12-23 Thread Moosmann, James
That is not recommended. You should instead use the fully qualified path. ie. Instead of: use customerDb select A.name, B.order frominfo A, orders B where A.id = B.customerId ... do this: select A.name, B.order from customerDb..info A, customerDb..info B where A.id = B.customerI

USE Statement

2004-12-23 Thread Ron Wingfield
I would like to the specify the USE argument dynamically as for example: USE $database; Apparently, the scalar is not recognized (compile error). Is it possible to provide a dynamic insertion such that a user could specify via a run-time parameter, which database the program is to use? BTW

Trying to install DBI-1.32 on Raq3: Test returned status 20 (wstat 5120, 0x1400)

2004-12-23 Thread Jim Byrne
Hi, I'm trying to install DBI module on my raq3 to connect with my Mysql databases. When I run the Makefile.PL for the latest version of the DBI module it quits with the error message: "Perl 5.006 required - this is only version 5.00503, stopped at Makefile.PL line 10". I am not keen to install

DBD::Sybase::db do failed: Server message number=2762

2004-12-23 Thread Anderson, James (Company IT)
I googled and found a reference to this, but the link was dead :-( There no longer appears to be anything in the mail archive. DBD::Sybase::db do failed: Server message number=2762 severity=16 state=3 line=1 server=NYTIBA8 text=The 'CREATE TABLE' command is not allowed within a multi-statement tr

Trying to install DBI-1.32 on Raq3: Test returned status 20 (wstat 5120, 0x1400)

2004-12-23 Thread Jim Byrne
Hi, I'm trying to install DBI module on my raq3 to connect with my Mysql databases. When I run the Makefile.PL for the latest version of the DBI module it quits with the error message: "Perl 5.006 required - this is only version 5.00503, stopped at Makefile.PL line 10". I am not keen to install