Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Pantera, Joseph F dot " <JPantera at gibsondunn dot com>
Subject: RE: :Sybase 1.03 / sybperl 2.17
Date: Jun 14 2004 2:35PM

	Hate to respond to this with a "generality" kind of question,
but I ended up kind of "dropping off" of the use of Sybperl after we
migrated over to MSSQL (from Sybase last year..., "not my decision").
My questions relate to MSSQL connectivity.  I'm not going to ask about
the generic "DBD::MSSQL" type of question I see posted all over the
internet...  However, I wasn't supported in my desire to get an ODBC
connectivity via my Unix / Apache web servers here (where I used all of
my Sybperl CGI scripts).  I've either lost this functionality, tried to
come up with "other means", or coped in one way or another...  

	Was just re-reading some old doc on "connecting to MSSQL2000 via
DBD::Sybase using TDS 7.0 legacy support" (via FreeTDS and setting up
config to use 7.0).  I seem to recall something coming up here about
something with those (version 7.0 TDS) libraries possibly having issues
connecting to MSSQL (maybe after Microsoft introduced SP3, or ??).  Does
this type of thing still work (and worth pursuing)?  If so / not, is
there a group somewhere (if this is not the correct one) you can point
me to in case I have more questions on this subject (I tried doing this
a while back, on my HP-UX server(s), trying to point back to MSSQL, but
now realize I "made a few flaws in my logic...")?

- Joe Pantera

Joe Pantera 
Sr. Systems, Database & Network Administrator 
work: (213) 229-7673 
Gibson, Dunn, & Crutcher LLP
333 South Grand Ave. | Suite 4138 | Los Angeles, CA 90071
 main: 213-229-7673 | fax: 213-229-6673

-----Original Message-----
From: Michael Peppler [] 
Sent: Monday, June 14, 2004 4:09 AM
To: Sybperl-L Mailing List
Subject: DBD::Sybase 1.03 / sybperl 2.17

I'm getting ready for a new release for DBD::Sybase and sybperl.

If your favorite pet-peeve (or bug) hasn't been addressed in the CHANGE
logs listed below, please raise your hand (or send me an email :-) so
that I can consider it for this release.


CHANGES for DBB::Sybase 1.03:

	Added linking of threaded Sybase libs if perl is built with
	threading turned on.
	Added CLONE() method.
	Minor changes to dbdimp.c to be thread-safe.
	Added t/thread.t test script.
	Changes to Makefile.PL to make configuration easier.
	Add support for Kerberos-based network login.
	Handle new library names (libsybct vs. libct).
        Make sure that cached statement handle attributes (NAME_lc, etc)
	are cleared when multiple result sets are processed.
	Add host and port connection properties, to allow connections
        to ASE servers that are not defined in the interfaces file
        (requires OCS 12.5.1)
	Add ability to dynamically increase the maximum number of 
	connections (thanks to Ed Avis).
	Add ability to ignore stored proc return status in nsql()
	to Merijn Broeren)
	Fix Makefile.PL umask() issue on Win32 (thanks to Darin

	Bugs Fixed:

	541 - $sth->{NAME} fails right after prepare().
	551 - Tests fail when using perl 5.6.1.
	556 - Add support for user-supplied SSL certificate file.
	557 - type_info_all broken with ASE 11.0.x
	562 - syb_flush_finish doesn't work during the connect() phase.
	563 - Memory leak when syb_binary_images is set.

CHANGES for sybperl 2.17:

	connection properties in Sybase::CTlib.
	Support CS_SERVERADDR connection properties in Sybase::CTlib,
	and also allow the $server parameter to ct_connect to be
	specified as "host:port" (requires OpenClient 12.5.1 or later).
	Some documentation changes/improvements in Sybase::CTlib.

	Bug Fixes
	546	umask checking doesn't work on Windows.
	555	blk_rowxfer doesn't handle datatype conversion errors.
	560	Long binary columns are truncated by ct_fetch.
	542	Fetch binary in raw format.

Michael Peppler                              Data Migrations, Inc.             
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions -

"MMS " made the following annotations.

This message may contain confidential and privileged information.  If it has been sent to you in error, please reply to advise the sender of the error and then immediately delete this message.