I have CMS Data base on Oracle 10 g , BO XI r2 on Sloaris and i have universes on Oracle and Sybase . I have configured EnvironmentVariables durinng installation. DO i need to configure Sybase Environment variables and i am using an odbc connection from client machine. what are the steps to be followed to configure ODBC drivers for sybase on Solaris?
Thanks
cooldude894d (BOB member since 2007-07-10)
If I follow your question correctly you do not need ODBC on the Solaris server, just the OpenClient software.
How you connect to the database your universe reports off of can be different from how your server connects. The client could use ODBC or OpenClient to connect.
jwhite9 
(BOB member since 2006-07-28)
My question is if i create a universe on Sybase and export it to repository. Do i have to configure any connection parameters on server for the universe which is created on Sybase? I can connect to sybase from a client machine using ODBC drivers.
cooldude894d (BOB member since 2007-07-10)
Is this Sybase ASE? The only supported data connector is Sybase Open Client.
Sybase Open Client has to be installed on your application server and you need to be sure the Sybase server is configured correctly in the sql.ini file on the application server. This is Sybase stuff, not BOE stuff.
Once that’s done, you should be able to use the Sybase ASE – Open Client connection selection in BOE for your universe.
I think if you absolutely want to use ODBC, you can use the Generic ODBC connection selection. Yuck…I think that’s a lot slower.
KSG (BOB member since 2002-07-17)
Thanks for the reply. Yes its Sybase ASE. My application server is Tomcat which is on Solaris Machine as well.
cooldude894d (BOB member since 2007-07-10)
We have Sybase ASA for new data instance? Can i use Sybase Open Client to connect to the Universe and run reports off it
CMS Data base is on Oracle 10 g , BO XI r2 on Sloaris and i have universes on Oracle and Sybase . How can i connect to Sybase ASA?
cooldude894d (BOB member since 2007-07-10)
Adaptive Server Anywhere (ASA) is another name for Sybase IQ. Install the IQ client drivers on the Solaris box, and then insert an entry into your odbc.ini file.
tedzonk 
(BOB member since 2006-03-29)
Do we have to install the IQ drivers seperately on Solaris box and what entry is to be inserted in the odbc.ini file?
Thanks.
cooldude894d (BOB member since 2007-07-10)
Yes, install the Sybase drivers separately (we use IQ12.7), usually under the sybase login and homedir.
here’s a snippet from a Installation document I wrote. You will obviously need to find out your ASA/IQ host/port.
tedzonk 
(BOB member since 2006-03-29)
“Also, copy the .odbc.ini file to the crystalreports installation area using the following command” Do you mean where BO XIR2 was installed and after this is Configured Do i need to use ODBC drivers in Designer??
cooldude894d (BOB member since 2007-07-10)
My instructions are particular to Crystal Reports Server XI R2 which is what we use. The reports (.rpt) will use this ODBC connection. I dont know of any other connection that will work with IQ.
tedzonk (BOB member since 2006-03-29)
Can we use the same for Business Objects Servers as well after sourcing the sybase variables??
cooldude894d (BOB member since 2007-07-10)
In this snippet does it assume that Sybase is installed on the same machine where BO is installed. If Sybase is installed on another machine what are the steps to be followed?
cooldude894d (BOB member since 2007-07-10)
No, the Sybase server is installed on a different host (identified by HOST=). The client drivers have to be installed on the BO box.
tedzonk (BOB member since 2006-03-29)
System configuration:
BO XI R2 is installed on solaris 10
My problem is as follows:
I am able to run sql queries from solaris prompt which hits to sybase database.
However I am not able to create a sybase open client in designer from my local system. It throws an error as “Data access driver is not available”.
pranavagarwal (BOB member since 2008-01-17)