<HTML>
<HEAD>
<TITLE>Changes to how ODBC, SQL, etc works</TITLE>
</HEAD>
<BODY>
<FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>Hey Guys,<BR>
<BR>
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.<BR>
<BR>
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.<BR>
<BR>
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up<BR>
<BR>
The settings for this field have changed.<BR>
<BR>
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types)<BR>
odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: )<BR>
sqlite://filename for sqlite different SQLite Databases<BR>
<BR>
I think we still need to doc this up good, but its there and its coming strong...<BR>
<BR>
-- <BR>
Ken<BR>
<FONT COLOR="#0000FF"><U><a href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><BR>
<a href="http://www.ClueCon.com">http://www.ClueCon.com</a><BR>
<a href="http://www.OSTAG.org">http://www.OSTAG.org</a><BR>
</U></FONT>irc.freenode.net #freeswitch<BR>
</SPAN></FONT>
</BODY>
</HTML>