Re: [otrs] Otrs installation for Mssqlserver2005

2009-05-20 Thread Michiel Beijen
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  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 
> *To:* User questions and discussions about OTRS. 
> *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 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 r...@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/
>
-
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/

Re: [otrs] Otrs installation for Mssqlserver2005

2009-05-19 Thread ravi shanker
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={SQLServer};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 
To: User questions and discussions about OTRS. 
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  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 r...@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/