otrs on linux, database on MSSQL: Data source name not found, and no default driver specified

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
participants (1)
-
Leonardo Certuche