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: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: :Sybase 1.03 / sybperl 2.17
Date: Jun 14 2004 2:48PM

On Mon, 2004-06-14 at 16:35, Pantera, Joseph F. wrote:
>  Michael:
> 	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").

Too bad...

> 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 don't have an MSSQL server handy to test, but here's the situation as
I understand it:

Sybase's OpenClient Client-Library works with MS-SQL 6.x, and 7 sp2 (or
sp3). The connection drops down to TDS 4.2, so no placeholder support,
no numeric/decimal, no wide varchars. It does NOT work at all with
MS-SQL 2k.

Sybase's OpenClient DB-Library works, provided that
dbsetversion(DBVERSION_100) is NOT called.

FreeTDS's implementation of Client Library works with all versions of
MS-SQL, but not all the CT-Lib functionality has been implemented - in
particular placeholder support (ct_dynamic() and friends) aren't there
yet (AFAIK).

To translate this to perl APIs - DBD::Sybase can be used with MS-SQL by
building/installing FreeTDS, Sybase::DBlib can be used with Sybase's
OpenClient installation (AFAIK - untested!), and Sybase::CTlib can be
used with FreeTDS.

Discussion of FreeTDS issues is on the FreeTDS mailing list (more info
at, though issues relating directly to
DBD::Sybase (or Sybase::CT/DBlib) are of course welcome here.


> -----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.
> Thanks!
> 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()
> (thanks
> 	to Merijn Broeren)
> 	Fix Makefile.PL umask() issue on Win32 (thanks to Darin
> Delegal).
> 	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
Michael Peppler                              Data Migrations, Inc.             
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions -