Re: [TWiki-Dev] ms sql db access from twiki

[Peter T. <pe...@th...>]

Hi Jeremiah,

This is more a DBD Perl question, not so much a TWiki question.

I have done the integration for an MS QSL database once, it is  
possible but a bit tricky. Digging out my notes:

    * Installed DatabasePlugin
    * Installed DBD::ODBC Perl lib and dependent C-libs:
      ftp://rpmfind.net/linux/dag/redhat/el5/en/i386/dag/RPMS/perl-DBD-ODBC-1.17-1.el5.rf.i386.rpm
      ftp://ftp.muug.mb.ca/mirror/centos/5.2/os/i386/CentOS/unixODBC-2.2.11-7.1.i386.rpm
    * That did not work out well, so we went the DBD::Sybase route:
    * Installed DBD::Sybase Perl lib and dependent C-libs:
      http://packages.sw.be/perl-DBD-Sybase/perl-DBD-Sybase-1.08-1.el5.rf.i386.rpm
      ftp://fr.rpmfind.net/linux/EPEL/5/i386/freetds-0.64-6.el5.i386.rpm
    * Configure DatabasePlugin to connect to MS-SQL Server 2000 via
      DBD::Sybase and FreeTDS libraries

Could you please open up a support question in the Support forum on  
TWiki.org? That way we get a growing knowledge base.

Regards,
Peter


On Apr 24, 2012, at 12:44 PM, Jester, Jeremiah D wrote:

> Hello,
>
> I'm trying to find out if there is any mechanism to connect to a MS  
> SQL
> db from Twiki? I have used the DatabasePlugin
> (http://twiki.org/cgi-bin/view/Plugins/DatabasePlugin) with MySQL but
> have not seen any documentation related to MS SQL. I would appreciate
> any information on this.
>
> Thanks,
> Jeremiah

-- 
   * Peter Thoeny     - peter09[at]thoeny.org
   * http://TWiki.org - is your team already TWiki enabled?
   * Knowledge cannot be managed, it can be discovered and shared
   * This e-mail is:   (_) private    (x) ask first    (_) public