All,
Apologies if this has been round before, but I am new to OTRS, and perl
and apache.....
I have installed OTRS 2.4.5 on a Windows 2003 server box, using all the
default settings.
I want to collect customer data from a SQL Server database on another
box, and have set up an ODBC connection to that box.
In Defaults.pm I have set up the following as described in the admin
manual:
$Self->{CustomerUser2} = {
Name => 'Customer Database Backend',
Module => 'Kernel::System::CustomerUser2::DB',
Params => {
# if you want to use an external database, add the
# required settings
DSN => 'DBD:odbc:Intranet',
User => 'sa',
Password => '',
Table => 'vwOTRS_LocationData',
But get error : "Unknown database type! Set option Database::Type in
Kernel/Config.pm to (mysql|postgresql|oracle|db2|mssql)."
If I change the DSN to be :
DSN => 'DBI:mssql:database=intranet;host=europa',
I get the error :
install_driver(mssql) failed: Can't locate DBD/mssql.pm in @INC (@INC
contains: ../../ C:/Program
Files/OTRS/OTRS/bin/cgi-bin/../../Kernel/cpan-lib C:/Program
Files/OTRS/OTRS/bin/cgi-bin/../..
C:/PROGRA~1/OTRS/StrawberryPerl/perl/lib
C:/PROGRA~1/OTRS/StrawberryPerl/perl/site/lib . C:/Program
Files/OTRS/OTRS/bin/cgi-bin/../.. C:/Program
Files/OTRS/OTRS/bin/cgi-bin/../../Kernel/cpan-lib) at (eval 61) line 3.
Perhaps the DBD::mssql perl module hasn't been fully installed,
Has anybody had this sort of error?
Any help appreciated.
Thank you
Jeff Dunn
-----------------------------------------------------------------------------------------------------------------------------
The receiver of this message is required to check if he/she has received it
erroneously. If so, the receiver is requested to immediately inform the sender
and - in consideration of the responsibilities arising from undue use or
disclosure of the message or the information contained therein - destroy the
original message and any copy or printout thereof.
Amplifon Ltd
Registered and Head Office : Ultravox House, Styal Road, Manchester M22 5WY
Registered In England No 1315581
VAT No 596 2575 91
-----------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------
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/
