<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <tt>Hi Philip,<br>
      <br>
      There is the db_unixodbc module [1] the can be used from other
      modules or directly from script (via avpops queries [2])<br>
      <br>
      <br>
      [1] <a class="moz-txt-link-freetext" href="https://opensips.org/html/docs/modules/3.0.x/db_unixodbc.html">https://opensips.org/html/docs/modules/3.0.x/db_unixodbc.html</a><br>
      [2]
<a class="moz-txt-link-freetext" href="https://opensips.org/html/docs/modules/3.0.x/avpops.html#func_avp_db_query">https://opensips.org/html/docs/modules/3.0.x/avpops.html#func_avp_db_query</a><br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS Summit, Amsterdam, May 2020
  <a class="moz-txt-link-freetext" href="https://www.opensips.org/events/Summit-2020Amsterdam/">https://www.opensips.org/events/Summit-2020Amsterdam/</a>
OpenSIPS Bootcamp, Miami, March 2020
  <a class="moz-txt-link-freetext" href="https://opensips.org/training/OpenSIPS_Bootcamp_2020/">https://opensips.org/training/OpenSIPS_Bootcamp_2020/</a>

</pre>
    <div class="moz-cite-prefix">On 2/27/20 7:32 PM, Saint Michael
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAC9cSOByjy_J5_JPLTBuMDUBEgm3XtV0noMTbDhe1GkvzHAcyA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex"><span
              class="gmail_default" style="font-size:small">I am new to
              opensips. Right now I am using exec to interface with my
              database via php-odbc. Is there a native odbc module that
              would have less overhed than my current approach?</span></blockquote>
          <div><span class="gmail_default" style="font-size:small">Also,
              how do I get a record of the call written to a database or
              a file? basic information, caller ID, number, duration,
              and date</span></div>
          <div><span class="gmail_default" style="font-size:small">Philip
              Orleand</span></div>
          <div><span class="gmail_default" style="font-size:small"><br>
            </span></div>
          <div><span class="gmail_default" style="font-size:small"></span> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex"><span
              class="gmail_default" style="font-size:small"></span><br>
          </blockquote>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>