[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Dri

shitalt

Hi,

I am facing issue related to database connectivity.

The error which I am getting is :
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
My application details are as follows:

Documentum version : 6.7
OS : Windows server 2008 (64- bit)
Database : SQL Server 2008 (64- bit)
JVM : 32-bit
JDBC Driver : 64-bit present in C:\Windows\System32\odbcad32.exe

I used below code for connectivity :

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
Connection connection = DriverManager.getConnection("jdbc:odbc:SQL_DSN", "aaa", "abc");
System.out.println("connection :"+ connection);

Can anyone please help me out with this problem I am facing.

Thanks in advance,
Shital

Haroon_A

See if this is of any help:

The specified DSN contains an architecture mismatch between the Driver and Application