Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

system DSN related issue

Received Response
4
Views
8
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics Lead
edited Aug 13, 2024 5:17PM in Oracle Analytics Cloud and Server

Hello Experts ,

How I can determine that which ODBC I need to use for creating system DSN:

pastedImage_1.png

Why I am asking this because I read that I need system DSN with BI server driver  for Direct Database Request connection. However BI Server Driver is listed only under 64 bit.

When I tried to connect with that getting below error:

the setup routine for oracle bi server odbc driver could not be loaded due to system error code 1114: A dynamic link library initialization routine failed

pastedImage_2.png

Thanks

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    If you don't have a time machine and are writing this from 15 years ago you need 64bit

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Thanks Chris

    Not sure why I am getting this error and what should I do, may be I can try my luck by reinstalling ODBC 64 bit driver.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Sangeeta Pandey wrote:Why I am asking this because I read that I need system DSN with BI server driver for Direct Database Request connection.

    I'm not sure to understand that and what you did read ...

    Do you want to do a Direct Database Request analysis? Because I don't see the link between the ODBC connection you try to define with the DDR analysis ...

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Hi Gianni,

    Thanks for your help !!! Yes , I want to do a Direct Database Request analysis.

    I thought I would need a system DSN for that.

    Do I need to pass connection pool like below:

    localhost:1521/orcl

    pastedImage_0.png

    Tried and got error like below:

    pastedImage_1.png

    This is very first time I am using this DDR and not sure if this is the right way?

    Below is working connection pool  at Admin tool:

    pastedImage_0.png

    Thanks,

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Oh for DDR, not for the RPD.

    If you have a connection pool in the RPD which works then in DDR you just reference the logical be - for you OBIEECP in this case.

    And your data source name in the RPD isn't a connect string. You need a tnsnames on your machine and the DSN in the RPD references the alias in the tnsnames.

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Thanks Chris !!!

    Please find below screenshot, where I can query the table without error , however I can see only column names and not data.

    Whilst table is having data as well. Kindly help if I am missing some thing here.

    pastedImage_0.png

    pastedImage_0.png

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Got it !!! I need to go to result tab for seeing data Thank you all , it solved.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    One more hint: If your connection pool is ambiguously defined (i.e. there are more of the same name in different database objects) then you'll need a fully qualified name like "YourDatabase"."OBIEECP"