Wim De Hul wrote:
> I tried to use the gcc -compiler (it is installed on my Sun and the dir
> is in my $PATH) but after the CC=gcc perl Makefile.PL,
I might be wrong. But if you use Solaris and your shell is (t)csh
(and not bash or ksh), then "CC=gcc perl Makefile.PL" won't work.
Try "perl Make
"Scott T. Hildreth" wrote:
>
> I fixed it by setting the 'SHELL=/usr/local/bin/zsh' so
> the LD_LIBRARY_PATH is getting set before Perl is executed.
Why not just set the LD_LIBRARY_PATH and then execute
the Perl-script instead of changing sh to zsh?
> I'm not sure why the behavior changed, but
Hi,
I don't know the best answer for you question,
Klaus Dittrich wrote:
> The following SQL generates Output in Fixed-Format:
>
> select
> isnull(convert(char(4 ), gewinnspiel_nr ), space(4))
have you tried
rtrim (gewinnspiel_nr)
here?
>,isnull(convert(char(8 ), gue
Cliff wrote:
> Has anyone seen this error before? I am trying to track it down and fix it,
> but I am still quite new to all this. Any advice welcome.
> Error returned:-
> $h->rows count is incomplete before all rows fetched.
Have you read "perldoc DBI"?
`rows'
$rv = $sth->rows;
Wayne Cain wrote:
> I've installed the openlink ODBC driver on a Solaris 2.8 box, and the broker
> on a NT SQL 7 box.
> The odbctest app connection works great! Now the next step is loading Perl
> DBI and ODBC module to connect
> Rational's ClearCase and a SQL 7 database using perl scripts. See be
"Guangzu Wang (Houston)" wrote:
> I downloaded DataDirect Connect ODBC yesterday and installed on my Redhat
> Linux 6.1. I then installed DBI-1.15 and DBD:ODBC 0.28. I tested
> successfully DBD:ODBC with Openlink before. But when I re-install it for
> DataDirect, "make test" failed and indicated a
Nick Chirca wrote:
> @arr = $dbh->query('select * from pet');
> print "@arr\n";
> $sth = $dbh->listfields('pet');
> print "$sth\n";
>
> _
>
> pet
> Mysql::Statement=HASH(0x80fed3c)
> Mysql::Statement=HASH(0x80fee5c)
Read "perldoc perlref"
roberto l wrote:
> $ENV{THREADS_FLAG}=qq|native|;
> $ENV{JAVA_HOME}=qq|/usr/java|;
> $ENV{LANG}=qq|en_US|;
> As you can see I've setup every single variable to connect, but still no
> success, I'm still getting the message "Total Environment allocation
> failure! Did you set up
> your DB2 clien
Everett Hickey wrote:
> First... does anyone know how to get a unix system (linux in particular, running
>perl 5.004) to connect to a microsoft SQL database running on the same network?
http://www.xray.mpe.mpg.de/mailing-lists/dbi/2001-01/msg00311.html
Hi Michael,
thanks for your reply.
Michael Peppler wrote:
> If the return status can be more than a fail/success value then I
> would fetch it in a normal fetch loop and check the result type
> (CS_STATUS_RESULT).
Is it reliable to use the string "COL(1)" to fetch that value
or will that string
Amit wrote:
> You see I have designed a chat interface in perl which connects to mysql to
> store chat transacripts and to show the chat sessions. Eg. Say I am
> chatting, I type a message it stores it into mysql. Now, the place where the
> chat appears, the page is refreshed every 5 seconds to ge
Hi,
I have the following simple stored prcedure,
which returns 1 on any error or 0 on success:
create procedure insert_update_sub @sub varchar (20),
@path varchar (255)
as
begin tran
if exists (select * from SUBSYSTEMS where SUB = @sub)
Karen Ellrick wrote:
> > What does the
> > ldd /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so
> > print? Are the correct libraries loaded?
>
> Well, I don't know what the correct libraries are (or even what the ldd
> command does), but the output is as follows:
> libodb
Karen Ellrick wrote:
> Once upon a time, I successfully compiled and installed the DBI and
> DBD::ODBC modules to use with EasySoft's ODBC-ODBC-Bridge. But now I have a
> new Linux box, and although I tried to do everything the same way as before
> (within the limits of my memory), I get the foll
Tommy Wareing wrote:
> On Wed, Apr 11, 2001 at 07:53:03PM +0300, N Sikkandar Dulkarnai wrote:
> > I added the below line into httpd.conf file under Apacheroot/conf
> >
> > SetEnv ORACLE_HOME=/data1/u01/app/oracle/product/8.1.5
> >
> > Is it correct ???
No it is not, see http://httpd.apache.org/do
luozhenyu wrote:
> I'm new to the list. I just begin to learn perl, and I want some other mail
> list about perl programming (like CGI, GUI, Network, IPC, RPC, etc) besides
> DBI. Who can tell me. Thanks a lot!!!
http://lists.perl.org
> > fukushi wrote:
> > > #! /good_directory_for_perl/perl -w
> > > $ENV{SYBASE} = "/good_direcroty_for_freetds/freetds";
> > > $ENV{LD_LIBRARY_PATH} = $ENV{SYBASE}."/lib";
> >
> > I believe, that you can't set the LD_LIBRARY_PATH variable this way
> > (just from within of you Perl-script and wi
fukushi wrote:
> #! /good_directory_for_perl/perl -w
> # fttest -- access MS-SQL7 using freetds
>
> use strict;
> use DBI;
>
> $ENV{SYBASE} = "/good_direcroty_for_freetds/freetds";
> $ENV{LD_LIBRARY_PATH} = $ENV{SYBASE}."/lib";
I believe, that you can't set the LD_LIBRARY_PATH variable this w
Hi,
Scott Phelps wrote:
> I am new to DBI and have been trying to find an example of running a stored
> procedure in MS-SQL. I have a simple search stored procedure that I need to
> pass keywords to and receive a recordset back from. Would anyone mind
> terribly giving any examples?
I think it i
Curt Russell Crandall wrote:
> Connecting to 'dbi:Sybase:server=SERVER1 user_name passwd' as ''...
> DBI->connect failed: server message number=4002 severity=14 state=1 line=8
> server=SERVER1 text=Login failed.
> OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER = (44)
> Message
Curt Russell Crandall wrote:
> No that wasn't the case here. Each select only produces 1 result row.
Are you really sure it was 1 row?
> So, I just did a
>
> $sth->execute() or die(...);
> $href = $sth->fetchrow_hashref();
I would try
while ($href = $sth -> fetchrow_hashref)
instead
Hi Curt,
Curt Russell Crandall wrote:
> I ran into a similar problem with Sybase. I had a statement prepared
> using placeholders (a select statement) and I had to loop several times as
> I processed transactions and each time through the loop I had to execute
> the prepared statement. Perl a
Andreas-Schmitz wrote:
> Whats the difference between DBI 1.13 and 1.14?
I have a "Gegenfrage": why don't you download
http://www.perl.com/CPAN-local/modules/by-category/07_Database_Interfaces/DBI/DBI-1.14.tar.gz
and read the "Changes" file?
Ahmed Shaikh wrote:
> DBI->connect failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5)
> NUMBER = (4)
> Message String: ct_connect(): network packet layer: internal net library error:
> Net-Lib protocol driver call to connect two endpoints failed
> Operating System Error: Socket c
Richard Lytle wrote:
> I'm new to perl and am trying to create an access to db's on an NT sql
> server via a web page. Can anyone suggest a good example or some
> relevant documentation?
http://www.perl.com/pub/1999/10/DBI.html
http://dbi.symbolstone.org/
http://stein.cshl.org/WWW/software/CGI
Hi Michael,
thanks again for your helpful response!
I have just 2 more questions:
Michael Peppler wrote:
> One, you need to check $sth->{syb_result_type} to see what sort of
> result row you are retrieving. It you "use DBD::Sybase" you'll have
> the symbolic values available (CS_COMPUTE_RESULT,
Hi guys,
I have the following stored procedure:
1> select_man_hours aso1, 2001
2> go
KEY NEEDMAN ALLOCMAN
--- ---
bta1/2001/3 NULLNULL
bta1/2001/4 NULLNULL
bta1/2001/11N
Hi,
I have a web page for deleting so-called OWNER's
with the help of this stored procedure:
create procedure delete_owner @owner char(7)
as
delete HOURS where BTA in (select BTA from BTAS where OWNER = @owner)
delete BTAS where OWNER = @owner
delete OWNERS where OWNER =
> I am very new to Perl Programming. I need to use Perl
> to talk to SQL Server Database. I have not yet
> installed Perl on my machine.
>
> Now, how do I go about doing these things?
> ie, installing Perl and as well as talking to
> SQLServer.
>
> Please guide me on the above with step by step
Lee Jonas wrote:
> I am an experienced Windows C++ developer and I know how to use debuggers
> generally. I *am* new to UNIX, Perl, DBI and PerlXS though. The main
> question I face is how can I debug DBD Perl XS C/C++ modules? What are the
> special steps I have to take to get a DBD module run
30 matches
Mail list logo
