Problem to connect to SQL Server 2005 with odbc driver

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Evilduky
Posts: 3
Joined: 20 May 2011, 14:57

Problem to connect to SQL Server 2005 with odbc driver

Post by Evilduky »

Hi,

I get the following message when I try to install Mantis 1.2.5:
Attempting to connect to database as admin
BAD
Does administrative user have access to the database? ( [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application )
Is there anybody who can help me to connect to SQL Server 2005 with odbc_mssql type?

My configuration:
Windows 2008 R2 standard 64 bits
php 5.3.6 (32 bits)
IIS 7.0
Mantis 1.2.5
SQl Server 2005 SP2
ODBC drivers:
- SQL native client version: 2005.90.3042.00 SQLNCLI.DLL 10/02/2007
- SQL Server 6.01.7600.16385 SQLSRV32.dll 14/07/2009

I connected successfully to my database with a php script which use this odbc drivers.
Bernd
Posts: 4
Joined: 03 Jun 2011, 17:56
Location: Eschwege, Germany
Contact:

Re: Problem to connect to SQL Server 2005 with odbc driver

Post by Bernd »

This message occurs if a 32-Bit Applikation (PHP) tries to use a 64-Bit ODBC-Connection or vice versa.

Open C:\Windows\SysWOW64\odbcad32.exe (don't worry about syswow64 here it is misleading, it is the 32-Bit folder...) to setup a 32-Bit ODBC-Connection.

64-Bit ODBC-Connection (for 64-Bit Applikations) are created with C:\Windows\System32\odbcad32.exe (again don't worry about the system32 here, it is the 64-Bit folder).

However, I tried to get Mantis to work with a similar configuration and had no luck. I have posted my successful approach here http://www.mantisbt.org/forums/viewtopi ... =4&t=19421
Evilduky
Posts: 3
Joined: 20 May 2011, 14:57

Re: Problem to connect to SQL Server 2005 with odbc driver

Post by Evilduky »

thanks for your tip, I'll try it !
Post Reply