<div>Hi,</div>
<div> </div>
<div>is it possible that it is the '.dll' that needs to be in the variable?</div>
<div> </div>
<div>This has worked for me so far (on a Windows XP SP3 'proof-of-concept' installation, Version 8.0 of Eloquence, and 8.41G of Powerhouse ):</div>
<div> </div>
<div>PH_IMAGE_LIB=C:\Program Files\Eloquence\8.0\bin\image3k.dll</div>
<div> </div>
<div>I have not had to set SHLIB_PATH so far...</div>
<div> </div>
<div>Michel</div>
<div><br> </div>
<div class="gmail_quote">On Tue, Apr 12, 2011 at 3:31 PM, Conrad Whittall <span dir="ltr"><<a href="mailto:Conrad.Whittall@ca.ibm.com">Conrad.Whittall@ca.ibm.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><font face="Cambria" size="2">I think we're on the right track, but I found that you might need two environment variables set...one for the library location and then one for the shared library (or DLL on Windows).</font> <br>
<br><font face="Cambria" size="2">From an old Cognos support knowledge base document for UNIX...</font> <br><br><font face="Cambria" size="2">1. Ensure that the location of the Eloquence libraries are contained in the SHLIB_PATH environment variable, for example</font> <br>
<br><font face="Cambria" size="2">SHLIB_PATH=$SHLIB_PATH:/opt/eloquence6/lib/pa20_32</font> <br><br><font face="Cambria" size="2">where the .../pa20_32 directory contains the 32-bit libraries</font> <br><br><font face="Cambria" size="2">2. Ensure that the PH_IMAGE_LIB variable contains the name of the object library which contains the Eloquence execution time routines, for example</font> <br>
<br><font face="Cambria" size="2">PH_IMAGE_LIB=<a href="http://libimage3k.sl/" target="_blank">libimage3k.sl</a> </font><br><br><font face="Cambria" size="2">My guess is that the same two environment variables are needed for Windows too. Maybe...</font> <br>
<br><font face="Cambria" size="2">SET SHLIB_PATH=C:\PROGRA~1\ELOQUE~1\8.1\lib</font> <br><font face="Cambria" size="2">
<div class="im">SET PH_IMAGE_LIB=C:\PROGRA~1\ELOQUE~1\8.1\lib\image3k.lib<br><br></div>Regards,<br>Conrad</font> <br><br><br><br><br><font face="sans-serif" color="#5f5f5f" size="1">From: </font><font face="sans-serif" size="1">Michael Cousins/Ottawa/IBM@IBMCA</font> <br>
<font face="sans-serif" color="#5f5f5f" size="1">To: </font><font face="sans-serif" size="1">"Larry Watt" <<a href="mailto:Larry.Watt@speedware.com" target="_blank">Larry.Watt@speedware.com</a>></font> <br>
<div class="im"><font face="sans-serif" color="#5f5f5f" size="1">Cc: </font><font face="sans-serif" size="1">Ken Langendock <<a href="mailto:ken.langendock@rogers.com" target="_blank">ken.langendock@rogers.com</a>>, <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a></font> <br>
</div><font face="sans-serif" color="#5f5f5f" size="1">Date: </font><font face="sans-serif" size="1">2011-04-12 15:32</font> <br>
<div class="im"><font face="sans-serif" color="#5f5f5f" size="1">Subject: </font><font face="sans-serif" size="1">RE: [Bulk] I get the error PH_IMAGE_LIB does not specify a valid library when I ty to access an Eloquence database with Powerhouse 4GL 8.41 E on Windows 2k3</font> <br>
</div><font face="sans-serif" color="#5f5f5f" size="1">Sent by: </font><font face="sans-serif" size="1">powerh-l-bounces+conrad.whittall=<a href="http://ca.ibm.com/" target="_blank">ca.ibm.com</a>@<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a></font> <br>
<hr noshade>
<br><br><br><font size="3">Well - the next thing I would try is setting it to the location and not the library.<br></font><font face="Arial" color="#000080" size="3"><br>PH_IMAGE_LIB="C:\PROGRA~1\ELOQUE~1\8.1\lib"</font><font size="3"><br>
<br>/mc<br><br><br></font><img alt="Inactive hide details for "Larry Watt" ---04/12/2011 03:00:40 PM---Michael, I tried what you suggest, and the variable seems to" src="cid:_1_0BE1B7380BE1B3F80076338685257870"><font color="#424282" size="3">"Larry Watt" ---04/12/2011 03:00:40 PM---Michael, I tried what you suggest, and the variable seems to be set properly. I tried it with eloqdb</font><font size="3"><br>
</font>
<table width="100%">
<tbody>
<tr valign="top">
<td width="9%"><img height="1" src="cid:_1_0BE1C6180BE1C2440076338685257870" width="96"><font color="#5f5f5f" size="2"><br>From:</font>
<td width="90%"><img height="1" src="cid:_1_0BE1CD580BE1C9580076338685257870" width="1"><font size="2"><br>"Larry Watt" <Larry.Watt@Speedware.com></font>
<tr valign="top">
<td><img height="1" src="cid:_1_0BE1D3300BE1CF5C0076338685257870" width="96"><font color="#5f5f5f" size="2"><br>To:</font>
<td><img height="1" src="cid:_1_0BE1D9080BE1D5340076338685257870" width="1"><font size="2"><br>Michael Cousins/Ottawa/IBM@IBMCA</font>
<tr>
<td valign="top"><img height="1" src="cid:_1_0BE1DEE00BE1DB0C0076338685257870" width="96"><font color="#5f5f5f" size="2"><br>Cc:</font>
<td><img height="1" src="cid:_1_0BE1E4B80BE1E0E40076338685257870" width="1"><font size="2"><br>"Ken Langendock" <<a href="mailto:ken.langendock@rogers.com" target="_blank">ken.langendock@rogers.com</a>>, <<a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a>>, <powerh-l-bounces+michael.cousins=<a href="http://ca.ibm.com/" target="_blank">ca.ibm.com</a>@<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a>></font>
<tr valign="top">
<td><img height="1" src="cid:_1_0BE1EA900BE1E6BC0076338685257870" width="96"><font color="#5f5f5f" size="2"><br>Date:</font>
<td><img height="1" src="cid:_1_0BE1F0680BE1EC940076338685257870" width="1"><font size="2"><br>04/12/2011 03:00 PM</font>
<tr valign="top">
<td><img height="1" src="cid:_1_0BE1F6400BE1F26C0076338685257870" width="96"><font color="#5f5f5f" size="2"><br>Subject:</font>
<td><img height="1" src="cid:_1_09C760D809C75F880076338685257870" width="1"><font size="2"><br>RE: [Bulk] I get the error PH_IMAGE_LIB does not specify a valid library when I ty to access an Eloquence database with Powerhouse 4GL 8.41 E on Windows 2k3</font></td>
</td></tr></td></td></tr></td></td></tr></td></td></tr></td></td></tr></tbody></table><br>
<hr noshade>
<font size="3"><br><br></font><font face="Arial" color="#000080" size="3"><br>Michael, I tried what you suggest, and the variable seems to be set properly. I tried it with eloqdb32.lib and image3k.lib. It fails with both. </font><font size="3"><br>
<br></font><font face="Arial" color="#000080" size="3"><br>ACTION:evarPH_IMAGE_LIB="C:\PROGRA~1\ELOQUE~1\8.1\lib\eloqdb32.lib"<br>Press RETURN to continue.</font><font size="3"><br></font><font face="Arial" color="#000080" size="3"><br>
ACTION:evarPH_IMAGE_LIB="C:\PROGRA~1\ELOQUE~1\8.1\lib\image3k.lib"<br>Press RETURN to continue.</font><font size="3"><br><br></font><font face="Arial" color="#000080" size="3"><br>Thanks, Larry</font><font size="3"><br>
<br></font>
<div align="center"><br>
<hr>
</div><br><font face="Tahoma" size="3"><b>From:</b> Michael Cousins [</font><a href="mailto:Michael.Cousins@ca.ibm.com" target="_blank"><font face="Tahoma" color="blue" size="3"><u>mailto:Michael.Cousins@ca.ibm.com</u></font></a><font face="Tahoma" size="3">] <b><br>
Sent:</b> Tuesday, April 12, 2011 2:33 PM<b><br>To:</b> Larry Watt<b><br>Cc:</b> Ken Langendock; <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a>; powerh-l-bounces+michael.cousins=<a href="http://ca.ibm.com/" target="_blank">ca.ibm.com</a>@<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a><b><br>
Subject:</b> RE: [Bulk] I get the error PH_IMAGE_LIB does not specify a valid library when I ty to access an Eloquence database with Powerhouse 4GL 8.41 E on Windows 2k3</font>
<p><font face="Times New Roman" size="4">I've never used but I would look at what PH sees when it's running<br><br>Qdesign<br>>scr x menu<br>>def rcom char*40 = 'set | find "PH_IMAGE_LIB"'<br>
>proc des evar nod<br>>beg<br>>run com rcom now resp<br>>end<br>>go<br><br>enter evar in the action field to see what PH_IMAGE_LIB looks like to PH.<br><br>/mc<br><br><br><br></font><font size="3"><br></font><img alt="Inactive hide details for "Larry Watt" ---04/12/2011 12:50:22 PM---Thanks for the suggestion Ken, unfortunately, these don't to" src="cid:_1_09C77B3C09C776040076338885257870"><font face="Times New Roman" color="#424282" size="4">"Larry Watt" ---04/12/2011 12:50:22 PM---Thanks for the suggestion Ken, unfortunately, these don't to work either</font><font size="3"> </font>
<p>
<table width="100%">
<tbody>
<tr valign="top">
<td width="8%"><img src="cid:_1_09C78C6C09C788980076338885257870"><font face="Times New Roman" color="#5f5f5f" size="3"><br>From:</font>
<td width="91%"><img src="cid:_1_09C7924409C78E700076338885257870"><font face="Times New Roman" size="3"><br>"Larry Watt" <<a href="mailto:Larry.Watt@speedware.com" target="_blank">Larry.Watt@speedware.com</a>></font>
<tr valign="top">
<td><img src="cid:_1_09C7981C09C794480076338885257870"><font face="Times New Roman" color="#5f5f5f" size="3"><br>To:</font>
<td><img src="cid:_1_09C79DF409C79A200076338885257870"><font face="Times New Roman" size="3"><br>"Ken Langendock" <<a href="mailto:ken.langendock@rogers.com" target="_blank">ken.langendock@rogers.com</a>>, <<a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a>></font>
<tr valign="top">
<td><img src="cid:_1_09C7A3CC09C79FF80076338885257870"><font face="Times New Roman" color="#5f5f5f" size="3"><br>Date:</font>
<td><img src="cid:_1_09C7A9A409C7A5D00076338885257870"><font face="Times New Roman" size="3"><br>04/12/2011 12:50 PM</font>
<tr valign="top">
<td><img src="cid:_1_09C7AF7C09C7ABA80076338885257870"><font face="Times New Roman" color="#5f5f5f" size="3"><br>Subject:</font>
<td><img src="cid:_1_09C7B55409C7B1800076338885257870"><font face="Times New Roman" size="3"><br>RE: [Bulk] I get the error PH_IMAGE_LIB does not specify a valid library when I ty to access an Eloquence database with Powerhouse 4GL 8.41 E on Windows 2k3</font>
<tr valign="top">
<td><img src="cid:_1_09C7B9A009C7B8500076338885257870"><font face="Times New Roman" color="#5f5f5f" size="3"><br>Sent by:</font>
<td><img src="cid:_1_09C7C09C09C7BC9C0076338885257870"><font face="Times New Roman" size="3"><br>powerh-l-bounces+michael.cousins=<a href="http://ca.ibm.com/" target="_blank">ca.ibm.com</a>@<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a></font></td>
</td></tr></td></td></tr></td></td></tr></td></td></tr></td></td></tr></tbody></table><br>
<hr noshade>
<font face="Times New Roman" size="4"><br><br></font><font face="Arial" color="#000080" size="4"><br><br>Thanks for the suggestion Ken, unfortunately, these don’t to work either<br><br>SET PH_IMAGE_LIB=C:\PROGRA~1\ELOQUE~1\8.1\lib\eloqdb32.lib<br>
SET PH_IMAGE_LIB=C:\PROGRA~1\ELOQUE~1\8.1\lib\image3k.lib</font><font face="Times New Roman" size="4"><br></font><font face="Arial" color="#000080" size="4"><br><br>I installed Eloquence after I installed Powerhouse, is it possible that Eloquence needs to be installed first, or that the Powerhouse programs need to be relinked with the Eloquence libraries ? </font><font face="Times New Roman" size="4"><br>
</font><font face="Arial" color="#000080" size="4"><br><br>Thanks, Larry</font>
<div align="center"><br>
<hr>
</div><br><font face="Tahoma" size="4"><b>From:</b> Ken Langendock [</font><a href="mailto:ken.langendock@rogers.com" target="_blank"><font face="Tahoma" color="blue" size="4"><u>mailto:ken.langendock@rogers.com</u></font></a><font face="Tahoma" size="4">] <b><br>
Sent:</b> Tuesday, April 12, 2011 11:19 AM<b><br>To:</b> Larry Watt; <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><b><br>Subject:</b> RE: [Bulk] I get the error PH_IMAGE_LIB does not specify a valid library when I ty to access an Eloquence database with Powerhouse 4GL 8.41 E on Windows 2k3</font><font face="Times New Roman" size="5"><br>
<br>I was not able to get PH to talk to ANYTHING with a space in the path.<br>Do a DIR/X to get the short path name.<br>Or try<br><br>SET PH_IMAGE_LIB=C:\</font><font face="Times New Roman" color="red" size="5">Progra~1\</font><font face="Times New Roman" size="5">Eloquence\8.1\lib\eloqdb32.lib<br>
<br>Ken</font><font face="Times New Roman" size="4"><br></font><font face="Times New Roman" size="5"><b><br><br>From:</b> powerh-l-bounces+ken.langendock=<a href="http://rogers.com/" target="_blank">rogers.com</a>@<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a> [</font><a href="mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com" target="_blank"><font face="Times New Roman" color="blue" size="5"><u>mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com</u></font></a><font face="Times New Roman" size="5">] <b>On Behalf Of </b>Larry Watt<b><br>
Sent:</b> April 12, 2011 11:05 AM<b><br>To:</b> <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><b><br>Subject:</b> [Bulk] I get the error PH_IMAGE_LIB does not specify a valid library when I ty to access an Eloquence database with Powerhouse 4GL 8.41 E on Windows 2k3<br>
<br>My eloquence server is the same Windows 2k3 server. I am able to access it with no problems using query3k.<br><br>According to the Powerhouse documentation, I should be able to set the PH_IMAGE_LIB variable to the Eloquence library. <br>
<br>Here is my Eloquence lib directory. <br><br>04/11/2011 02:36 PM <DIR> .<br>04/11/2011 02:36 PM <DIR> ..<br>02/02/2010 04:19 PM 5,795 dbutil.dlg<br>09/11/2010 12:29 AM 54,856 dbutil.hlp<br>05/19/2010 06:35 PM 23,429 dbutil.inc<br>
08/30/2010 12:13 PM 9,285 dbutilj.dlg<br>05/05/2009 06:28 PM 6,058 eloqdb32.def<br>09/16/2010 01:31 PM 17,386 eloqdb32.lib<br>09/16/2010 02:00 PM 87,728 eloqdll.lib<br>05/05/2009 06:28 PM 1,948 fwutil.def<br>09/16/2010 01:38 PM 5,786 fwutil.lib<br>
09/16/2010 02:27 PM 6,405 ide-adlg-old.cfg<br>09/16/2010 02:27 PM 9,539 ide-adlg.cfg<br>09/16/2010 03:02 PM 47,616 ide-adlg.dll<br>09/16/2010 02:27 PM 10,184 ide-idm.cfg<br>09/16/2010 03:02 PM 46,592 ide-idm.dll<br>05/05/2009 06:28 PM 3,297 image3k.def<br>
09/16/2010 01:57 PM 15,616 image3k.lib<br>05/05/2009 06:28 PM 3,312 image3kC.def<br>09/16/2010 01:58 PM 15,058 image3kC.lib<br>02/02/2000 02:53 PM 126 local.eloq<br>09/16/2010 02:00 PM 131,072 mod_eloq2.so<br>09/16/2010 02:00 PM 131,072 mod_eloq22.so<br>
04/11/2011 02:36 PM <DIR> nls<br>01/02/2003 01:59 PM 140 query.eloq<br><br>I have tried all of the following, and get the same error. <br><br>SET PH_IMAGE_LIB=C:\Program Files\Eloquence\8.1\lib\eloqdb32.lib<br>SET PH_IMAGE_LIB=C:\Program Files\Eloquence\8.1\lib\eloqdll.lib<br>
SET PH_IMAGE_LIB=C:\Program Files\Eloquence\8.1\lib\image3k.lib<br>SET PH_IMAGE_LIB=C:\Program Files\Eloquence\8.1\lib\image3kC.lib<br><br>I also tried adding the directory path to my PATH variable and got the same error.<br>
<br>Any help would be appreciated.<br><br>Thanks, Larry</font><font face="Times New Roman" size="4"><br></font><font face="Courier New" size="3"><br><br>-- <br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a></font><font color="blue" size="3"><u><br>
</u></font><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank"><font face="Courier New" color="blue" size="3"><u>http://lists.sowder.com/mailman/listinfo/powerh-l</u></font></a><font face="Courier New" size="3"><br>
This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.</font><font size="3"><br>
</font><tt><font size="2">-- <br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br></font></tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank"><tt><font size="2">http://lists.sowder.com/mailman/listinfo/powerh-l</font></tt></a><tt><font size="2"><br>
This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.</font></tt> <br>
<p></p>
<p></p><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:<a href="http://lists.sowder.com/" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.<br>
</p></p></blockquote></div><br>