Hi all,

I have done a little bit research about using JDBC or Ingres .Net
Dataprovider as an alternative to the full-blown Ingres.Net + ODBC
client installation.

I have managed to get it running with JDBC (iijdbc.jar) but not with
the .Net Dataprovider (ingres.client.dll). If anybody has an idea
for .Net Dataprovider, please let me know.

I *think* the solution for ingres.client.dll may be creating a so-
called UDL file...
http://msdn.microsoft.com/en-us/libr...8VS.71%29.aspx
.... but I have no idea how such a file would look like for
ingres.client.dll

Here is how I got things running for JDBC:
1. install CR 2008 Development
2. no need to "install" any Ingres software on the PC, just copy
iijdbc.jar to any folder, for example c:\Programme\JDBCDrivers
3. Tweak the CLASSPATH setting in C:\Programme\Business Objects\Common
\4.0\java\CRconfig.xml so it includes full path to the iijdbc.jar
---snip---
<Javaserver-configuration>
<DataDriverCommon>
<JavaDir>C:\Programme\Business Objects\javasdk\bin</JavaDir>
<Classpath>C:\Programme\JDBCDrivers\iijdbc.jar;C:\ Programme
\Business Objects\Common\4.0\java/lib/crlovmanifest.jar;C:\Programme
\Business Objects\Common\4.0\java/lib/CRLOVExternal.jar;C:\Programme
\Business Objects\Common\4.0\java/lib/CRDBJDBCServer.jar;C:\Programme
\Business Objects\Common\4.0\java/lib/CRDBXMLServer.jar;C:\Programme
\Business Objects\Common\4.0\java/lib/CRDBJavaBeansServer.jar;C:
\Programme\Business Objects\Common\4.0\java/lib/external/log4j.jar;C:
\Programme\Business Objects\Common\4.0\java/lib/CRDBSForceServer.jar;C:
\Programme\Business Objects\Common\4.0\java/lib/external/
CRDBSForceExternal.jar;C:\Programme\Business Objects\Common\4.0\java/
lib/external/CRDBXMLExternal.jar;${CLASSPATH}</Classpath>
<IORFileLocation>${TEMP}</IORFileLocation>
<JavaServerTimeout>1800</JavaServerTimeout>
---snip---

---> Now you can use Ingres' JDBC driver from within CR2008


Regards
Gerhard