I have to send excel data to databse.
I have created dsn for exceldriver. Tried connecting to database using driver: sun.jdbc.odbc.JdbcOdbcDriver and URL: jdbc:Odbc:<<DSN Name>>.
But getting an exception while testing connection.
BW-JDBC-100034 "Configuration Test Failed. Exception [java.sql.SQLException] occurred.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
Please let me know the solution
Windows 7 OS
You can also get information regarding SAP Oracle