Hello list,
This is my firt attempt to connect to a MSSQL database from linux so please be patient
Our client wants OTRS 2.4.5 on linux but its database on Microsoft SQL Server.
I first tried with fedora 11 in which I got install_driver(ODBC) failed so I tried with opensuse 10.3 in which I installed the following packages:
perl-DBI-1.58-17
perl-DBD-ODBC-1.14-13
unixODBC-2.2.12-55
Then I modified my Config.pm file with the instructions provided in http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=121
After that, I ran /opt/otrs/bin/CheckDB.pl, its output is the following:
DBI connect('driver={SQL Server};Server=10.1.1.44,1433;database=DB_Otrs;uid=App_otrs;pwd=pd0tr&228;','otrs',...) failed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1) at /opt/otrs/Kernel/System/DB.pm line 214
ERROR: OTRS-CheckDB-10 Perl: 5.8.8 OS: linux Time: Wed Oct 28 07:14:01 2009
Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)
Traceback (17481):
Module: Kernel::System::DB::new (v1.105.2.1) Line: 188
Module: CheckDB.pl (v1.22) Line: 53
No database connect!
Any help is much appreciated.
Thanks in advance,
Leonardo Certuche