Configuring ODBC for XI 3.1 on a 64bit Operating System

So you’ve got a nice shiny new box running 64bit Windows Server 2008 and SQL Server 2008.

It’s going to run XI 3.1, so you go in to SQL Server and create your Business Objects repository.

You then go into the ODBC data source administrator and set up your ODBC connection. You test the connection, it works fine. Great.

You then kick off the XI 3.1 installation, and you get to the screen to select your database. No problem. I’m using SQL Server, I’ve created the database and I’ve created the ODBC connection.

So where is my ODBC connection?

You may have spotted a new check box on the SQL Server Logon screen ‘Consume DSN created under WOW64’.

“Never seen that before”, you say. “I’ll uncheck it”. And voila, your ODBC connection appears.


That connection have been created using the 64bit version of the ODBC data source administrator.

You need to go back and recreate your ODBC connection using the 32bit ODBC data source administrator. Eh? What’s that all about?

To save yourself from a sore head, take a look at the posting provided by Dallas Marks. All will be revealed.

Many thanks Dallas.



As I’ve mentioned in previous postings, a SAP User ID is now required if you want to take a SAP Business Objects exam.

I regularly receive emails asking how you go about getting one of these ID’s, especially if you are not a partner/customer.

Note that this blog is not connected with SAP so I can’t tell you for sure. However, two options seem to work:

1. Register at the following link. This will take you to the SAP site where you can register your details.
2. Call the SAP education department in your country

It takes a couple of weeks to get the User ID through, so be patient.

New Certification Exams – Data Integrator now added

Further information regarding the new Business Objects exams. Data Integrator is going to be added to the list of available exams.

More info can be found here.

Note that existing BOCP holders do not need to recertify:

“…individuals holding a current valid BusinessObjects certification will not need to recertify.”

Also nice to see that existing holders of the BOCP certifcation can use the new titles:

‘…those holding the valid BusinessObjects certification in the latest release are entitled to use the SAP Associate certification logo and title but no new certificates will be issued.”

One thing to point out though, if you are BOCP-BOE certified to XIR2 and haven’t yet taken the XI3 upgrade SABE501, you may want to do it before the exam is removed:

“If a test taker is certified on BusinessObjects Certified Professional – Business Objects Enterprise XI R2 and requires only the XI 3.0 upgrade exam (SABE 501) to qualify for the XI 3.0 certificate what should he/she do?

To avoid taking the full certification exam after the retirement of the XI 3.0 upgrade exam the final exam should be taken prior to its retirement at the end of April.”

Get your skates on! There may be limited places in your chosen test centre.

%d bloggers like this: