On Tue, 2004-07-13 at 18:51, William R. Mussatto wrote: > Hardy Merrill said: > > Janet, I think David was saying that you might(?) be able to use the > > DBD::Sybase driver to connect to MS SQL Server ;-) > > > > Hardy Merrill > > > >>>> Janet Goldstein <[EMAIL PROTECTED]> 07/13/04 11:14AM >>> > > David N Murray wrote: > >> > >> google turns up http://search.cpan.org/search?module=DBD::ADO > >> ADO & ODBC are your only options, AFAIK, on Windows. > >> Maybe someone more informed can comment on using the Sybase driver. > > > > Thanks for your reply, Dave. Actually, I'm not limited to Windows; I > > would just as soon access the database from my Unix box. However, it's > > not Sybase I'm trying to get to here; it's Microsoft SQL Server. > A bit of background might explain things. MSSQL was derived from Sybase. > Therefore its way of talking to the rest of the world is similar so the > Sybase module is the normal method of connecting.
Although it should be pointed out that backwards compatibility with Sybase's version of the protocol was broken in MS-SQL 2k, so using the Sybase *libraries* (i.e. Sybase OpenClient) does not work anymore. Hence the reference to using FreeTDS for the actual communication layer. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] 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
