system DSN related issue

Sangeeta Pandey

Hello Experts ,

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

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

Thanks

[Deleted User]

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

Sangeeta Pandey

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

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

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

Tried and got error like below:

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:

Thanks,

[Deleted User]

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

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.

Sangeeta Pandey

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

[Deleted User]

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"