PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Does DBD::Sybase set 'hostname' and 'scriptName' automatically?
Date: Oct 29 2003 5:45PM

On Wed, 2003-10-29 at 08:33, Avis, Ed wrote:
> I am using DBD::Sybase version 1.01.  It lets you set 'hostname'
> and 'scriptName' for a connection but doesn't seem to set them
> automatically if not asked.  For example
> 
>     use DBI;
>     $dbh = DBI->connect('dbi:Sybase:server=SERVER',
>                         'user', 'secret');
>     sleep 1000;
> 
> does not produce any row in sysprocesses with my machine's
> hostname.  But if I say
> 
>     use DBI;
>     $dbh = DBI->connect('dbi:Sybase:server=SERVER;hostname=foo',
>                         'user', 'secret');
>     sleep 1000;
> 
> then a row with hostname = 'foo' does appear.
> 
> But according to
> 
> DBD::Sybase does fill in these two fields from hostname() and
> $0.  So what's happening?

Looks like a bug. The script name does get filled in correctly, but the
hostname doesn't get set correctly for some reason. I'll have to look
into that.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html