Information

Title	Connection to SQL Server fails with architecture mismatch error

URL Name	000030002

Article Number	000173605

Environment	OpenEdge 10.2B 64-bit, 11.x 64-bit Windows x64

Question/Problem Description

When establishing a connection to the SQL Database using the DataServer in Data Administration tool error 6142 is returned.

The connection using the same DSN with the AppServer works properly.

However the use of the same DSN to establish the connection via the Data Administration tool fails with error (6142)

Steps to Reproduce

Clarifying Information

Using the OpenEdge 64-bit edition for Windows.

Error Message	The specified DSN contains an architecture mismatch between the Driver and Application Failed to connect to the MSS database (6142)

Defect Number

Enhancement Number

Cause

The Data Administration tool is a 32-bit executable, is build on the prowin32.exe GUI client. This executable needs to use a 32-bit ODBC driver to connect to the SQL Server database.

The character client and the server processes on the 64-bit OpenEdge edition for Windows are a 64-bit executables that need to use a 64-bit ODBC driver to connect to the SQL Server database.

Resolution

To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe.

To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. In Administrative Tools on a 64-bit Windows 8 operating system, there are icons for both the 32-bit and 64-bit ODBC Data Source Administrator dialog box.

Workaround

Notes

References to Online Documentation:
Managing Data Sources

Keyword Phrase

Last Modified Date	9/13/2015 11:50 PM

Connection to SQL Server fails with architecture mismatch error

Information