<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">What platform is the PowerHouse system on? What version of SQL Server are they using?<div><br></div><div>Only the Windows version of PowerHouse supported SQL Server officially. Unless there’s a gateway that makes it look like another supported database they may be out of luck unless it’s PowerHouse on Windows.</div><div><br></div><div>If it is PowerHouse on Windows, the connection is done through the dictionary via ODBC.</div><div><br></div><div>You can find the current Supported Environments document here: <a href="http://www-01.ibm.com/support/docview.wss?rs=3626&uid=swg27014142">http://www-01.ibm.com/support/docview.wss?rs=3626&uid=swg27014142</a>, at least until Unicom takes over. </div><div><br></div><div>Bob</div><div><br><div><div>On Feb 25, 2014, at 1:04 PM, John Stires <<a href="mailto:pencarver@sbcglobal.net">pencarver@sbcglobal.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="background-color: rgb(255, 255, 255); font-family: arial, helvetica, sans-serif; font-size: 10pt;"><div>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 id="misspell-0" class="mark">SQL</span> Server database from Powerhouse. Some how, I cannot believe that this <span id="misspell-1">should</span> be all that much of a challenge.</div><div> </div><div>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.</div><div> </div><div>Thanks for any help on this.</div><div> </div><div>pencarver</div><div>(John Stires)</div></div></div>--<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">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:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</blockquote></div><br></div></body></html>