Skip to Content
0
Former Member
Aug 20, 2009 at 06:57 AM

Issue creating oracle ODBC connection on SOLARIS

17 Views

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