<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>In thhis case, unfortunately, they are running on an Alpha with open VMS <font size="2" face="r_ansi"><font size="2" face="r_ansi">V7.3-2. Does not sound good, but thanks. I will have to keep that in mind for future reference.</font></font></span></div><div><span><font face="r_ansi"></font></span> </div><div><span><font face="r_ansi"><var id="yui-ie-cursor"></var>John</font></span><span><font size="2"><font size="2"></div><div></font></font></span></div><div><br></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <div style="margin: 5px 0px; padding: 0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" class="hr" contentEditable="false"
readonly="true"></div> <font size="2" face="Arial"> <b><span style="font-weight: bold;">From:</span></b> Charles Finley <cfinley@xformix.com><br> <b><span style="font-weight: bold;">To:</span></b> 'John Stires' <pencarver@sbcglobal.net>; powerh-l@lists.sowder.com <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, February 25, 2014 12:50 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> RE: Accessing SQL Server tables from Powerhouse<br> </font> </div> <div class="y_msg_container"><br>
<div id="yiv625300463"><style><!--
#yiv625300463
_filtered #yiv625300463 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv625300463 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv625300463 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv625300463
#yiv625300463 p.yiv625300463MsoNormal, #yiv625300463 li.yiv625300463MsoNormal, #yiv625300463 div.yiv625300463MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv625300463 a:link, #yiv625300463 span.yiv625300463MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv625300463 a:visited, #yiv625300463 span.yiv625300463MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv625300463 span.yiv625300463mark
{}
#yiv625300463 span.yiv625300463EmailStyle18
{font-family:"Calibri", "sans-serif";color:#1F497D;}
#yiv625300463 .yiv625300463MsoChpDefault
{font-size:10.0pt;}
_filtered #yiv625300463 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv625300463 div.yiv625300463WordSection1
{}
--></style><div><div class="yiv625300463WordSection1"><div class="yiv625300463MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri", "sans-serif"; font-size: 11pt;'>If your customer is not on Windows but is on UNIX or Linux you can use our TurboIMAGE/Eloquence libraries and tell Power house it is using Eloquence. You will then also need some ODBC products that we can identify. It should then be possible to access the SQL Server database hosted on a Windows platform. It is part of our Transport Migration Toolset http://modernization.xformix.com/?page_id=422 </span></div><div class="yiv625300463MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri", "sans-serif"; font-size: 11pt;'> </span></div><div><div class="yiv625300463MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri", "sans-serif"; font-size: 11pt;'>Charles Finley</span></div><div class="yiv625300463MsoNormal"><span
style='color: rgb(31, 73, 125); font-family: "Calibri", "sans-serif"; font-size: 11pt;'>(619) 795-0720</span></div></div><div class="yiv625300463MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri", "sans-serif"; font-size: 11pt;'> </span></div><div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) currentColor currentColor; padding: 3pt 0in 0in;"><div class="yiv625300463MsoNormal"><b><span style='font-family: "Tahoma", "sans-serif"; font-size: 10pt;'>From:</span></b><span style='font-family: "Tahoma", "sans-serif"; font-size: 10pt;'> powerh-l-bounces+cfinley=xformix.com@lists.sowder.com [mailto:powerh-l-bounces+cfinley=xformix.com@lists.sowder.com] <b>On Behalf Of </b>John Stires<br><b>Sent:</b> Tuesday, February 25, 2014 10:05 AM<br><b>To:</b> powerh-l@lists.sowder.com<br><b>Subject:</b> Accessing SQL Server tables from Powerhouse</span></div></div></div><div
class="yiv625300463MsoNormal"> </div><div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'>I just started a new client that is trying to migrate to a new system from their current system written, mostly in Powerhouse. One of several reason for making this migration is that they have not found a way to access their <span class="yiv625300463mark">SQL</span> Server database from Powerhouse. Some how, I cannot believe that this should be all that much of a challenge.</span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'> </span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'>Can anyone out there offer some guidance on
how to do this? I think it should be straight forward and done through the dictionary as it does for other databases.</span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'> </span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'>Thanks for any help on this.</span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'> </span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family: "Arial", "sans-serif"; font-size: 10pt;'>pencarver</span></div></div><div><div style="background: white;" class="yiv625300463MsoNormal"><span style='color: black; font-family:
"Arial", "sans-serif"; font-size: 10pt;'>(John Stires)</span></div></div></div></div></div></div><br><br></div> </div> </div> </div></body></html>