|
|
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 http://www.freetds.org), though issues relating directly to
DBD::Sybase (or Sybase::CT/DBlib) are of course welcome here.
Michael
> -----Original Message-----
> From: Michael Peppler [mailto:mpeppler@peppler.org]
> 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:
>
> Support for CS_SEC_NETWORKAUTH and CS_SEC_SERVERPRINCIPAL
> 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.
mpeppler@peppler.org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html
|
