Issue creating oracle ODBC connection on SOLARIS

[Former Member]

Hi all,

We have BO X! 3.1. We have created some webi reports. Our universe connection is created using following method.

= Created a DSN connection for oracle 10g database

= created Bo connection object by selecting Generic ODBC connection

= in the service name we have given DSN name and tested successfully.

• we have created reports universe under Windows environment.

= Now we deployed Biar file of the same on SOLARIS server.

We have created odbc connection in odbc.ini on solaris.

we have used path "/../boxir3/bobje/odbc.ini"

We have used "/BOXIR3/bobje/enterprise120/solaris_sparc/odbc/lib/libsqora.so.10.1" driver

But when we test connection after deployment connection fails. giving error

" A database error occured. The database error text is:. (WIS 10901)"

Can anybody suggest me right method to create ODBC connection for oracle 10g on SOLARIS.

Thanks in advance.

Saurabh

[Former Member]

Can i know how your Universe is creating ?

I mean its on Oracle schema? or how. If you use Oracle native drivers it will work.

[Former Member]

Dear Anil,

Yes. Backend is Oracle 10g.

If we use oracle native driver then it works fine. But we want to use odbc because it gives flexibility in deploying BO package (reports/universes) at various locations with different USERNAME and PASSWORD which is required.

By using oracle native drivers we have to create different connection for each deployment which we can not afford.

Can you suggest me further on odbc issue.

Regards,

Saurabh