<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link=blue vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>We did ODBC for a while. There are lots of small details that must be working perfectly for the stars to align. Think of this as a two step process: PH to ODBC and then ODBC to the database. I recommend looking for an ODBC driver that works with Postgresql. The PH to ODBC should be standard interface. However, there my be unique data types available in the database that the ODBC driver cannot translate properly and thus you may have problems. It took me a lot of experimentation to get everything working well. </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Good Luck!</p><p class=MsoNormal>Mike Godsey </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows</p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='border:none;padding:0in'><b>From: </b><a href="mailto:bob.deskin@me.com">Robert Deskin</a><br><b>Sent: </b>Thursday, June 15, 2023 3:04 PM<br><b>To: </b><a href="mailto:pierre.bouthillette@gmail.com">Pierre Bouthillette</a><br><b>Cc: </b><a href="mailto:powerh-l@lists.sowder.com">PowerHouse List</a><br><b>Subject: </b>Re: Database type odbc....</p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Don’t know if this went through the first time.<o:p></o:p></p><div><p class=MsoNormal><br><br><o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On Jun 15, 2023, at 2:50 PM, Robert Deskin <bob.deskin@me.com> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>I honestly don’t know. It’s been a very long time. Checking the supported environment document from 2012 says that ODBC is DataDirect 5.2 to MS SQL Server with additional support for DataDirect 5.3, 6.0, and 6.1 also to MS SQL Server.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I don’t recall whether anything else was ever tested nor whether any customers tried anything else. I also don’t know if the DataDirect driver is compiled in or can be changed, but I doubt it.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Maybe someone out there can provide a better answer.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Bob<o:p></o:p></p></div><div><div><p class=MsoNormal><br><br><o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On Jun 15, 2023, at 2:34 PM, Pierre Bouthillette <pierre.bouthillette@gmail.com> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>Hi Bob<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>we have powerhouse on solaris<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>works fine with oracle<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>my client is looking to access database postgresql<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>i have a question about odbc type...<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>doc says odbc is working with ms sql server <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>can we use another odbc driver instead ?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>is powerhouse looking for a specific driver?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>Thanks<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:18.0pt;font-family:"Comic Sans MS";color:#000099'>Pierre<o:p></o:p></span></p></div></div><div id=DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2><p class=MsoNormal><o:p> </o:p></p><table class=MsoNormalTable border=1 cellspacing=3 cellpadding=0 style='border:none;border-top:solid #D3D4DE 1.0pt'><tr><td width=55 style='width:41.25pt;border:none;padding:9.75pt .75pt .75pt .75pt'><p class=MsoNormal><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><span style='text-decoration:none'><img border=0 width=46 height=29 style='width:.4833in;height:.3in' id="_x0000_i1025" src="https://s-install.avcdn.net/ipm/preview/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"></span></a><o:p></o:p></p></td><td width=470 style='width:352.5pt;border:none;padding:9.0pt .75pt .75pt .75pt'><p class=MsoNormal style='line-height:13.5pt'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#41424E'>Virus-free.<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><span style='color:#4453EA'>www.avast.com</span></a><o:p></o:p></span></p></td></tr></table></div></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>