From: Arpit2 G/MUM/TCS
Date: 12/08/2009 05:57PM
Subject: Architecure mismatch between the Driver and Apllication( MSSQL)

Hello All,

I was trying to configure OTRS on a system which has Windows Server 2008 installed.My MSSQL server is installed on different System when I was trying to connect with MSSQL server but it gives me following error.

"[ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (SQL-IM014)"

I guess OTRS is using 32 bit driver of MSSQL. Can't we install OTRS on 64 bit Server.Following is the Database part of my Config.pm file.

 

$Self->{'DatabaseHost'} = '*.*.*.*';

$Self->{'Database'} = 'OTRS';

$Self->{'DatabaseUser'} = 'otrs';

$Self->{'DatabasePw'} = '******';

$Self->{DatabaseDSN} = "DBI:ODBC:$Self->{Database}";

$Self->{'Database::Type'} = 'mssql';

Please tell me where am i wrong.

 

Thanks & Regards

Arpit Gupta
ESM Sub Focus Area, TEG Open Source Platform
Tata Consultancy Services
Ph:- +91-22-67782544
Mailto: arpit2.g@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________