Connect to Sysbase IQ from Business Object 3.1

D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc

modify the jdbc.sbo file

<DataBase Active=”Yes” Name=”Sybase Adaptive Server 15″>
<Class JARFile=”dbd_jdbc,dbd_sybase”>com.businessobjects.connectionserver.java.drivers.jdbc.sybase.SybaseDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
      <ClassPath>
        <Path>d:\Test\jconn3.jar</Path>
      </ClassPath>
<Parameter Name=”JDBC Class”>com.sybase.jdbc3.jdbc.SybDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sybase:Tds:$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sybase</Parameter>
<Parameter Name=”Version”>sybase_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sybase</Parameter>
<Parameter Name=”SQL Parameter File”>sybase</Parameter>
<Parameter Name=”Strategies File”>sybase</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sybase15,sybase,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>

Leave a Reply

Your email address will not be published. Required fields are marked *