Hi Ravi,

You won't need ActivePerl; you can run OTRS with Microsoft SQL Server on any perl distribution, just as long as it is Perl 5.8 or 5.10. The major perl distributions for win32 are Strawberry Perl and Activestate Perl. 

To connect using ODBC you'd have to have DBD::ODBC module installed. You should see no error message if you'd issue the following statement:

perl -e"use DBD::ODBC;"

Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl


On Tue, May 19, 2009 at 18:46, ravi shanker <rshanker_ch@yahoo.com> wrote:
Hi Afshar,
To start with, is Active perl installation must for sqlserver to work for OTRS?
 i don't have active perl installation in my system.
#settings for mSsqlserver
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Server=58.2.71.49,1433;database=otrs;uid=otrs;pwd=password;";
$Self->{"Database::Type"} = 'mssql'; 
$Self->{DatabaseUserTable} = 'users'';

#--------------------------#

does config.pm checks "db.pm"  by anyway.
pls send any working config.pm,it would be of great help.thanks in advance afshar
 
Ravi Shankar




From: Afshar Mohebbi <afshar.mohebbi@gmail.com>
To: User questions and discussions about OTRS. <otrs@otrs.org>
Sent: Tuesday, May 19, 2009 10:17:04 AM
Subject: Re: [otrs] (no subject)

Could you provide your config.pm and your logs?

Afshar Mohebbi


On Mon, May 18, 2009 at 7:17 PM, ravi shanker <rshanker_ch@yahoo.com> wrote:
Hi ,
please help me with configuring sqlserver2005 to Otrs. i have added  DSN ->system DSN connecting to OTRS in Config.pm.
lndex.pl page is coming ,when i enter root@localhost and password.page can't found error is coming.
 

Regds

Ravi Shankar





---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/



---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/