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: "Smith, Barry" <barry dot smith at csfb dot com>
Subject: RE: SybPERL and MS-SQL
Date: Dec 22 1998 8:07PM

With V7 of MSSQL Server, CTLIB will definitely be bounced, DBlib may get
through, but I suspect not.

They are dropping support for DBlib and moving on to OLEDB.


> -----Original Message-----
> From:	Michael Peppler []
> Sent:	Tuesday, December 22, 1998 6:42 PM
> To:	SybPerl Discussion List
> Subject:	SybPERL and MS-SQL
> >>>>> "Paul" == Paul Roberts  writes:
> Paul> I have been accessing Sybase using the CTlib and now I need to
> Paul> access a Microsoft SQL database so I have two questions.
> Paul> 1. Where is the best place for me to find out how to use SybPERL
> Paul> to access Microsoft SQL (if it can be done)?
> Paul> 2. Is there a way to access both Sybase and Microsoft SQL with
> Paul> SybPERL (and can I use the CTlib)?
> In general, for MS-SQL 6.5 and *before* you can access the server
> using either Sybase::DBlib or Sybase::CTlib. You just need to define
> an entry in the interfaces file for the MSSQL server.
> Client Library is a little more finicky, so you *may* get some
> protocol level errors when talking to an MS-SQL server with
> Sybase::CTlib. 
> With MSSQL 7.0 it appears that MS has changed the protocol somewhat,
> making the use of the Sybase libraries more problematic, although I
> don't have a lot of details on that.
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
>       -||-
> Int. Sybase User Group  -||-
> Sybase on Linux mailing list: