Skip to Content
author's profile photo Former Member
Former Member

u201CCannot Open databaseu201D u201CUnknown Database Connector Erroru201D business views

I’m unable to run a report when I design a report with business view

which has data connection with SQL2000 & Oracle 9i db's. Getting error

message like “cannot open database” & unknown database connection error.Environment: BO Enterprise XI Rel 2 running on Windows 2003

Database: Oracle 9i running on Win 2003; SQL 2000 running on wintel.

Note that, I can design/run a report if the business view connecting

only to SQL2000 or Oracle 9i.

Have anybody come across this situation? Any inputs please?

Thanks,

Krishna

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 25, 2008 at 04:58 PM

    Hi,

    Try to recreate the connections and try again.

    -Shreyash.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 01:07 PM

    Hi Krishna,

    Are you using the Dynamic data connection for connecting to the two data sources i.e. are you adding the two data connections for SQL and Oracle in the Dynamic data connection.?

    Regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 02:00 PM

    Hi Krishnaraj,

    In this case you are using Dynamic data connection to point the connection to different databases like SQl Server 2000 and Oracle 9i.

    Please try the following steps in Business View Manager:

    NB: Please ensure that the properties Use Owner and Use Catalog are set to False in each Data Connection.

    1. Open or create the Data Connection within the Business View Manager.

    2 Go to the Property Browser.

    3. Click to the right of True (the default value) beside Use Owner, and choose False in the drop-down menu.

    4. Repeat for the Use Catalog property.

    5. Save the Data Connection.

    Please let me know if you have any issues related to the above mentioned workaround.

    Regards,

    Arun Sasi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks for the response.

      we are Not using the Dynamic data connection, instead directly using the 2 data connections in the Data foundation and creating the BV.

      Does the resolution of setting those properties still apply in this scenario?

      Regards,

      Krishnaraj

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.