Problem: Issues while installing EMC Content Server 6.6 on Windows 7 (64bit) machine.
Environment: Windows7 (64bit), SQL Server 2008 R2 (64bit) and Content Server 6.5/6.6 on a single machine.
Error: “The specified DSN contains an architecture mismatch between the Driver and Application ERROR(-1) “
Scenario: Tried installing Content Server but it throws aforementioned error while setup program tries to use the Data Source Name(DSN) to use existing SQL database or attempts to create a new database in order to create/configure a repository.
Solution: It is assumed that SQL Server 2008 R2 is installed on the machine.
When DSN is created on 64 bit machine it is meant to be used by a 64bit application. The Content Server setup is a 32 bit installation so cannot used 64bit System DSN and as a result throws error and cannot proceed. Follow below steps to rectify this issue:
a). Download and Install patch KB956717 for 64 bit machine from the Microsoft Technical Support website.
b). Create a case sensitive database using SQL Server Config manager. Visit http://social.msdn.microsoft.com/Forums/en/transactsql/thread/f5cd6d91-0a0e-41be-8801-97d5b7bef98b for more information.
Note: If the database is not created as a case sensitive DB, the Content Server installer throws error similar to the one “Database is not case sensitive”.
c). Create a new user and make sure this user has appropriate access so that new DB and required objects like Tables, views etc are created during installation.
d). Download SqlCmdLnUtils utility (SqlCmdLnUtils-2008-64bit.msi, SqlCmdLnUtils-2008-32bit.msi) from Microsoft Website and install it on the machine (Windows 7).
e). Start odbcad32.exe from %WINDIR%\SysWOW64\ location. This program is referred to as ODBC Configurator. Create a System DSN by selecting SQL Server driver. Test the connection to make sure DSN has been configured as expected. The following SQLCMD command can be used to test the DSN:
C:\sqlcmd –S <SQLServer> -U <UserID> -P <Password>
Note: Make sure SQLCMD.exe is installed at C:\Program Files \Microsoft SQL Server\90\Tools or C:\Program Files \Microsoft SQL Server\100(90)\Tools location.
f). Check the below path exists for SQL Server 2008
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn; and add it to the PATH environment variable.
- Right click on ‘Computer’ icon on desktop and choose ‘Properties’ option.
- Click on ‘Advanced system settings’ in the left pane.
- Click ‘Advanced’ tab in the System Properties window and click on ‘Environment variables’
- Find PATH variable under System Variables section and edit it as explained above.
For more information visit
