cancel
Showing results for 
Search instead for 
Did you mean: 

BOBJ 4.0 Client Tools Configuration Help

Former Member
0 Kudos

i have 32 and 64 bit System DSN setup on the server using the 2005 drivers. 4.0 was installed with 2008 Express. i'm not sure if that has anything to do with it? dumb question, should it be set to the db or cms db?


i don't remember configuration being this confusing.

here's what it shows in CMC settings:

Image link


sia properties:

Image link


setting up new connection, i'm trying to use the credentials for the boe140 db. someone tried connecting to the SQL 2005 db and that makes a connection but i get errors.

Image link

created a new connection using IDT and the test worked:

Image link


imported and used the new connection for the universe i need. the test worked:

Image link


error in crystal reports:

Image link


webi error:

Image link

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

You would need to have 64-bit DSN to install BO. during the installation the DSNs are created automatically. This is what you showed us in the images.

Many client tools use both 32-bit / 64-bit drivers. This helps them to talk to CMS Db in right way. You were using a CMS Db connection to create Universes , crystal reports and webi reports. Please note these client tools retrieve data from Db's other than the CMS Db usually. It is not recommended and suggested to have data made out of CMS Db. You should use the audit Database to know about the activities happening within the server.

good luck!!