rkv has asked for the wisdom of the Perl Monks concerning the following question:

I'm looking for ODBC drivers for UNIX - to access MS SQLServer 2000 from Perl on a Solaris box. Can anyone offer any advice about either Merant or OpenLink?? Thanks in advance for any help.

Replies are listed 'Best First'.
Re: UNIX ODBC
by IDStewart (Acolyte) on Jul 30, 2001 at 19:00 UTC
    From the DBD::ODBC FAQ:
    How do I access a MS SQL Server database from Linux?

    Try using drivers from http://www.openlinksw.com The multi-tier drivers have been tested with Linux and Redhat 5.1.

    Now, I haven't used DBD::ODBC to cross OS platforms, but have used it to talk to an MS Access database in Win2k with acceptable results.

      you could try stuff besides ODBC... right now I am trying to use TDS (tabular data stream) from a Sun sparc machine... Linux is a little ezier to use.... you may want to look up OpenSource ASE from Sybase... (unsure of the links off hand but look up sybase)
      these nodes also have some rather ok material writen by me but a seach for the database you are trying to connect to will turn up better results

      Ms SQL Server and perl.
      Microsoft SQL to Unix command

      A simple Mysql manager writen by me but soon will be upgraded.. feel free to use what ever you can from it.. It requires CGI , DBI ,and DBD::mysql
      MySQL Database Manager
Re: UNIX ODBC
by PsychoSpunk (Hermit) on Jul 30, 2001 at 21:26 UTC
    Perl, Solaris, MS SQL Server? No problem. OpenLink's solution worked for me. Another resource in the ODBC connection will be the iODBC page which covers the GPLed versions of OpenLink's driver suite (the Windows piece is on their main site however).

    ALL HAIL BRAK!!!