Como vcs já tiveram experiencias com sql, alguem poderia me dar uma dica...pq tenho um extension com muito acesso ao banco e quando coloco mais de um ramal com vários acessos, ele fica doidão...<br><br>
<div><span class="gmail_quote">Em 18/11/05, <b class="gmail_sendername">Frederic Jean</b> <<a href="mailto:fjean@sunnetgroup.net">fjean@sunnetgroup.net</a>> escreveu:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="PT-BR" bgcolor="white" link="blue" vlink="purple">
<div><font face="Arial" size="2">Marcio,</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">Voce ate poderia tentar instalar o cliente Oracle.</font></div>
<div><font face="Arial" size="2"><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html" target="_blank">http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
</a></font></div><span class="sg">
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">Frederic Jean</font></div></span>
<blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><span class="q">
<div style="FONT: 10pt arial">----- Original Message ----- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title="marciootuca@uol.com.br" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:marciootuca@uol.com.br" target="_blank">Marcio Oliveira
</a> </div></span>
<div><span class="e" id="q_107a3af1b286499c_4">
<div style="FONT: 10pt arial"><b>To:</b> <a title="asteriskbrasil@listas.asteriskbrasil.org" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:asteriskbrasil@listas.asteriskbrasil.org" target="_blank">asteriskbrasil@listas.asteriskbrasil.org
</a> </div>
<div style="FONT: 10pt arial"><b>Sent:</b> Friday, November 18, 2005 11:33</div>
<div style="FONT: 10pt arial"><b>Subject:</b> RES: [AsteriskBrasil] Asterisk INTEGRAÇAO com o Oracle</div>
<div><br> </div>
<div>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Mas esse <span>driver</span> e pago ?? pelo que eu vi no <span>site</span> , a <span>lincença</span> <span>free</span>
e <span>so</span> por meses.</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Não teria como eu acessar o <span>oracle</span> através de suas <span>APIs</span> <span>( OCI</span> ) alguém já vez isso ??
</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Grato</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Márcio</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Mensagem original-----<br><b><span style="FONT-WEIGHT: bold">De:</span></b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org" target="_blank">
asteriskbrasil-bounces@listas.asteriskbrasil.org</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org" target="_blank">asteriskbrasil-bounces@listas.asteriskbrasil.org
</a>] <b><span style="FONT-WEIGHT: bold">Em nome de </span></b>Frederic Jean<br><b><span style="FONT-WEIGHT: bold">Enviada em:</span></b> sexta-feira, 18 de novembro de 2005 10:10<br><b><span style="FONT-WEIGHT: bold">Para:
</span></b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:asteriskbrasil@listas.asteriskbrasil.org" target="_blank">asteriskbrasil@listas.asteriskbrasil.org</a><br><b><span style="FONT-WEIGHT: bold">
Assunto:</span></b> Re: [AsteriskBrasil] Asterisk INTEGRAÇAO com o Oracle</span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Marcio,</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Se o seu banco de dado esta numa maquina remota,</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">voce teria que instalar os drivers do Oracle, primeiro, para</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">poder acessar-la.</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.easysoft.com/products/data_access/odbc_oracle_driver/#platforms" target="_blank">
http://www.easysoft.com/products/data_access/odbc_oracle_driver/#platforms</a></span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Tambem vc tem que instalar o unixODBC:</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.unixodbc.org/" target="_blank">http://www.unixodbc.org/
</a></span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Quando isto for feito, vc tem a opcao de usar de um script AGI (perl ou outro)</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">par mandar os queries a partir do seu extensions.conf. Assim vc pode acessar</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">o seu Oracle sem problema.</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Eu ja fiz a experiencia com SQL Server para armanezar os CDRs e funcionou</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">muito bem; ate a solucao ODBC para Linux e viavel porque se a conexao</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">for relachada, ele vai ser reconectada sem intervencao manual. Caso</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">acessar os drivers diretamente, vc nao vai ter esta funcionalidade.</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Boa sorte !</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Frederic Jean</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.sunnetgroup.net/br" target="_blank">
www.sunnetgroup.net/br</a></span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<blockquote style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt 0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none">
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----- Original Message ----- </span></font></p></div>
<div>
<p style="BACKGROUND: #e4e4e4; MARGIN-LEFT: 35.4pt"><b><font face="Arial" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">From:</span></font></b><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<a title="marciootuca@uol.com.br" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:marciootuca@uol.com.br" target="_blank">Marcio Oliveira</a> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><b><font face="Arial" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">To:</span></font></b><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<a title="AsteriskBrasil@listas.asteriskbrasil.org" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:AsteriskBrasil@listas.asteriskbrasil.org" target="_blank">'A Comunidade Brasileira do PBX OpenSource'
</a> </span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><b><font face="Arial" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sent:</span></font></b><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
Friday, November 18, 2005 10:15</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><b><font face="Arial" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Subject:</span></font></b><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
[AsteriskBrasil] Asterisk INTEGRAÇAO com o Oracle</span></font></p></div>
<div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" color="navy" size="3"><span style="FONT-SIZE: 12pt; COLOR: navy">Oi pessoal,</span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Gostaria de saber como <span>integrar o banco Oracle no asterisk , estou precisando</span>
em fazer umas consultas na base de dados mas não </span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Tenho q mínima idéia de como fazer tal coisa ...</span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Alguém poderia me ajudar ...</span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Grato </span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Márcio</span></font></p>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"><br>-- <br>Esta mensagem foi verificada pelo <br>Email-Seguro-Megaweb CONTRA VÍRUS acredita-se estar livre de perigo <br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.emailseguro.megabr.com.br/" target="_blank">http://www.emailseguro.megabr.com.br</a> </span></font></p>
<div style="MARGIN-LEFT: 35.4pt; TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p style="MARGIN-LEFT: 35.4pt"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">_______________________________________________<br>LIsta de discussões AsteriskBrasil.org<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:AsteriskBrasil@listas.asteriskbrasil.org" target="_blank">
AsteriskBrasil@listas.asteriskbrasil.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil" target="_blank">http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil
</a><br><br>_______________________________________________<br>Acesse o wiki AsteriskBrasil.org:<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.asteriskbrasil.org/" target="_blank">http://www.asteriskbrasil.org
</a></span></font></p></blockquote></div>
<p>
<hr>
<p></p>_______________________________________________<br>LIsta de discussões AsteriskBrasil.org<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:AsteriskBrasil@listas.asteriskbrasil.org" target="_blank">
AsteriskBrasil@listas.asteriskbrasil.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil" target="_blank">http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil
</a><br><br>_______________________________________________<br>Acesse o wiki AsteriskBrasil.org:<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.asteriskbrasil.org/" target="_blank">http://www.asteriskbrasil.org
</a>
<p></p></p></span></div></blockquote></div><br>_______________________________________________<br>LIsta de discussões AsteriskBrasil.org<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:AsteriskBrasil@listas.asteriskbrasil.org">
AsteriskBrasil@listas.asteriskbrasil.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil" target="_blank">http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil
</a><br><br>_______________________________________________<br>Acesse o wiki AsteriskBrasil.org:<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.asteriskbrasil.org/" target="_blank">http://www.asteriskbrasil.org
</a><br><br></blockquote></div><br>