Wednesday, August 14, 2013

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

If you have already google this error message and still not satisfied with the 64 bit driver solution you are on the right place.

With SAP BI 4.0 the new BO infrastructure is based on 64 bit technology BUT only on the server side. The client tools (universe designer, webi rich client etc.) are still 32 bit applications.

Many forums offers to create both 32 and 64 bit odbc for your file with the same name. One for client tools one for server.

OK, that's fine but did you realize that e-fashion has only one odbc and it is 32 bit, and it is still running on the server???

If e-fashion can do that why can't you? Here is the answer. I assume that you are using an Excel file as source. You created an odbc (32 bit odbc) for your excel file (on the server). Now go to the universe designer choose new connection. On the drop down box select "MS Excel 2007 ODBC Driver"


click next next finish. Enjoy it. Yes, that's all. Nothing to do else.

No comments:

Post a Comment