Cannot Open Database - Unknown Database Connector

[Gwired]

I am getting the Errors: Cannot Open Database and then Unknown Database Connector when attempting to connect a report to a Business View that is using a Dynamic Data Connection (it also happens if I don't make it Dynamic). I am using Integrated Security on the Data Connection.

The Business Objects solution says this:

http://technicalsupport.businessobj...=c2018336&sliceId=&dialogID=5692746&stateId=1

0 5694786

However that does not help me. I've set the rights for myself as the document says. Basically I made it so that all rights are granted to all levels from the DataConnection up through to the Business View. None of this changed the error. I've also simplified down to a single table in the foundation up to the view.

Business Objects says:

The connection information is set in the Business View Manager and the prompt setting is set to 'Never Prompt'. However, the password for the connection information was mistyped or left blank in the Business View Manager.

My problem is:

I do not have a password as I'm using Integrated Security on the Database Connection. At the server I see everything in the Business Element from the Foundation. I see fields and indexes and can browse the data. The server has rights. I'm not sure how to make my credentials work through to the dataview.

Too frustrating!!!

 

[satinsilhouette]

Gwired,

Do you have a generic userid on the database with a password? That would be the credentials it is looking for.

Thanks so much!
satinsilhouette

 

[Gwired]

Thanks for the response!

On the Server we have a Crystal user set up that has rights to the necessary databases. When I write the report I have no way of setting whom I am connecting to the business view as. I believe that since the Business View has a way to assign rights that I should be presenting as "the user" aka me. However it's not working. I can see the fields of the business view in my report but when I try to refresh I get the Cannot Open Database error.

I tried to set up a simple connection with a single table, single data view, single DF, and this came up with the same error. I'm wondering if I'm presenting as DOMAIN\username but the rights in the business view are based just on username. This is all supposed to work with AD.

Any other test I could do? Or setting I could check?

 

[satinsilhouette]

I believe if you have to get at the data with a user/id then you have to set the DF with that when it connects. Otherwise it sees you as your network id/password.

Thanks so much!
satinsilhouette

 

[Gwired]

Ok,

That doesn't seem like it should be that way. I would think that as a Business View user (which you'd have to have rights to see the View) you'd be able to access that data. Since you are building the Data Connections on the Server it must be the servers credentials that are being used to talk to the database. However I'm not above being incorrect...

Is there any versioning I have to look for. We are up to date on all service packs but how can I check if I'm using the version on my computer that enterprise expects on the server.

 

[Gwired]

Problem Solved,

It appears that in Business Objects XI if you are working with Business Views then you must save the report you are working on at the Server. Otherwise you get the errors above. In one book it said a Business View is essentially the same as a Data Connection. Well I guess one of the essentials is that you need to save the report you made in the Enterprise Repository.