Gecko [ 122.154.134.11 ]

Name	Size	Permission
config-opt.html	6 KB	-rw-r--r--
config.html	13.76 KB	-rw-r--r--
faq.html	28.33 KB	-rw-r--r--
howto-accesslo.html	2.35 KB	-rw-r--r--
howto-accessvba.html	6.24 KB	-rw-r--r--
howto-bo.html	1.67 KB	-rw-r--r--
howto-ch.html	4.04 KB	-rw-r--r--
howto-csharp.html	4.95 KB	-rw-r--r--
howto-vb.html	3.42 KB	-rw-r--r--
howto-vblo.html	8.52 KB	-rw-r--r--
index.html	4.35 KB	-rw-r--r--
license.txt	25.14 KB	-rw-r--r--
readme.txt	1.35 KB	-rw-r--r--
release.html	43.97 KB	-rw-r--r--
unix-compilation.html	2.35 KB	-rw-r--r--
win32-compilation.html	3.83 KB	-rw-r--r--

Code Editor : howto-bo.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=US-ASCII">
 <title>psqlODBC HOWTO - Business Objects</title>
 </HEAD>

<body bgcolor="#ffffff" text="#000000" link="#ff0000" vlink="#a00000" alink="#0000ff">
 
<h1>psqlODBC HOWTO - Business Objects</h1>

Author: Peter S. Hamlen (phamlen@teachforamerica.org) 
Release Date: 26 May 2003 
Description: PostgreSQL and Business Objects

 
Will Postgresql ODBC work with Business Objects?
 
Yes, with three caveats:

<ol>
<li>Technically, Business Objects does not support PostgreSQL. They do
support generic ODBC access to databases, however. &nbsp;</li>

<li>You must change the ODBC parameter file on any machine that uses
Designer. The ODBC file is usually C:\Program Files\Business
Objects\Data Access X.X\ODBC\ODBC10EN.PRM. You must change the OWNER
parameter to N and the QUALIFIER parameter to N (ie, OWNER=N,
QUALIFIER=N). 
 NOTE: It is only necessary to change this file for people who use
Designer. BusinessObjects, WebIntelligence, and all other BO programs
that use existing Universes are unaffected. &nbsp;</li>

<li>As with all other generic ODBC connections, you cannot do outer
joins in Designer. &nbsp;</li>
</ol>

Mart&iacute;n de la Herr&aacute;n also adds the following notes:

Also add the following parameters to C:\Program Files\Business Objects\Data Access X.X\ODBC\ODBC10EN.PRM

BACK_QUOTE_SUPPORTED=Y 
TABLE_DELIMITER="

These parameters are necessary to use tables with spaces and unusual chararacters in them.

</body>
</html>

${this.title}

Code Editor : howto-bo.html