<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5730.11" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Not that I have any experience with the driver,
however:</FONT></DIV>
<DIV><FONT face=Arial size=2>Just try binary_to_list function, however eliminate
non-printable characters, like 0 (mind you this looks like array of
C-Strings):</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>instead of:</FONT></DIV>
<DIV><FONT face=Arial size=2>binary_to_list( <FONT face="Times New Roman"
size=3><<99,108,105,101,110,116,95,101,110,99,111,100,105,110,103,0,85,84,70,56,0>>)</FONT></FONT></DIV>
<DIV>do:</DIV>
<DIV>
<DIV><FONT face=Arial size=2>binary_to_list( <FONT face="Times New Roman"
size=3><<99,108,105,101,110,116,95,101,110,99,111,100,105,110,103,85,84,70,56>>)</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>and you'll get: "client_encodingUTF8"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>conversely: </FONT></DIV>
<DIV><FONT face=Arial size=2>binary_to_list( <FONT face="Times New Roman"
size=3><<68,97,116,101,83,116,121,108,101,73,83,79,44,32,77,68,89>></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>produce:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"DateStyleISO, MDY"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This looks to me like driver's
environment.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>V.</FONT></DIV></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=rsaccon@gmail.com href="mailto:rsaccon@gmail.com">Roberto Saccon</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=erlang-questions@erlang.org
href="mailto:erlang-questions@erlang.org">erlang-questions</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, February 09, 2007 8:16
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [erlang-questions] trouble with
postgresql driver</DIV>
<DIV><BR></DIV>Is anybody using the posgres driver ( <A
href="http://erlang-consulting.com/aboutus/opensource.html">http://erlang-consulting.com/aboutus/opensource.html</A>
) from erlang-consulting ? Couldn't find any documentation / examples and when
I try to start the driver I get human-unreadable messages, see below:
<BR><BR>5> application:start(psql).<BR>ok<BR>6> Event:
{psql,parameter_status,<BR>
<<99,108,105,101,110,116,95,101,110,99,111,100,105,110,103,0,85,84,70,56,0>>}<BR>Event:
{psql,parameter_status,
<BR>
<<68,97,116,101,83,116,121,108,101,0,73,83,79,44,32,77,68,89,0>>}<BR>Event:
{psql,parameter_status,<BR>
<<105,110,116,101,103,101,114,95,100,97,116,101,116,105,109,101,115,0,111,110,0>>}
<BR>Event:
{psql,parameter_status,<BR>
<<105,115,95,115,117,112,101,114,117,115,101,114,0,111,102,102,0>>}<BR>Event:
{psql,parameter_status,<BR>
<<115,101,114,118,101,114,95,101,110,99,111,100,105,110,103,0,85,84,70,56,0>>}
<BR>Event:
{psql,parameter_status,<BR>
<<115,101,114,118,101,114,95,118,101,114,115,105,111,110,0,56,46,49,46,52,0>>}<BR>Event:
{psql,parameter_status,<BR>
<<115,101,115,115,105,111,110,95,97,117,116,104,111,114,105,122,97,116,105,111,110,0,114,115,97,99,99,111,110,0>>}
<BR>Event:
{psql,parameter_status,<BR>
<<115,116,97,110,100,97,114,100,95,99,111,110,102,111,114,109,105,110,103,95,115,116,114,105,110,103,115,0,111,102,102,0>>}<BR>Event:
{psql,parameter_status,<BR>
<<84,105,109,101,90,111,110,101,0,65,109,101,114,105,99,97,47,70,111,114,116,97,108,101,122,97,0>>}
<BR>Event:
{psql,backend_key_data,<<0,0,77,165,116,138,156,44>>}<BR><BR><BR><BR>and
any attempt to execute a query sql:q/1 results in the following error:
<BR><BR>** exited:
{noproc,{gen_server,call,<BR>
[sql_pool_mgr_srv,<BR>
{reference,<0.347.0>,default}]}} **<BR><BR>With the same authorization
credentials, but different (non-erlang) client app I can connect to the db.
<BR clear=all>Does anybody know how to interpret this error messages and get
this driver to work ?<BR><BR>-- <BR>Roberto Saccon
<P>
<HR>
<P></P>_______________________________________________<BR>erlang-questions
mailing
list<BR>erlang-questions@erlang.org<BR>http://www.erlang.org/mailman/listinfo/erlang-questions<BR></BLOCKQUOTE></BODY></HTML>