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

Universe....error on data provider warning......

Hi,

i created a universe when i am using the universe in QAAWS.i`m getting error like this get data provider warning....Data Source name not found and no default driver specified.....

how can i set default drivers?? where can i set?? can anyone give me a guide please....

Thanks,

Sella Perumal P

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 20, 2011 at 10:28 AM

    Hi,

    Data source name not found is an ODBC message, you manage your ODBC data sources on your own pc.

    Universe designer also runs on your pc, as does WebI rich client and DeskI.

    So if those work, it means you defined the ODBC name on your pc the right way.

    Now QAAWS is server based, meaning it will try to find the ODBC name on the BOE server, not on your pc.

    Same is true if you try to run a WebI report from Infoview (HTML or java, not rich client). So a simple test can confirm, try running a webi from InfoView and see if you get the same errormessage.

    Then you know for sure you will have to make the ODBC name available on the BOE server.

    Work with the system administrator to make it available.

    This also means that the actual database should be accessable from the server too.

    So if you try to use an access database on your own pc for instance, this will not be possible.

    The user that owns the server processes should have access to it.

    Good luck,

    Marianne

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2011 at 10:19 AM

    Hi,

    While creating universe in Designer try to test universe connection given to it. If it works then there shouldn't be any problem.

    Cheers,

    Suresh Aluri.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      If you used and ODBC connection to SQLserver, it is better to use the OLE DB connection type that is also available for SQL server.

      This way you put the information needed to connect to SQL server all in the connection, instead of partly in the connection (which ODBC name) and partly in the ODBC name definition, making it available to everyone with access to the connection without having to have the ODBC name definition too.

      If you really want to keep using ODBC, you have to define the ODBC name on the BOE server machine too...

      Good luck,

      Marianne

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.