<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span>se vc nao conseguir abrir os anexos</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span style="font-weight: bold; font-size: 32px;">freetds.conf</span></div><div style="color: rgb(0, 0, 0); font-size: 16px;
font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="background-color: transparent;"># $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $</div><div style="background-color: transparent;">#</div><div style="background-color: transparent;"># This file is installed by FreeTDS if no file by the same</div><div style="background-color: transparent;"># name is found in the installation directory.</div><div style="background-color: transparent;">#</div><div style="background-color: transparent;"># For information about the layout of this file and its settings,</div><div style="background-color: transparent;"># see the freetds.conf manpage "man freetds.conf".</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"># Global settings are overridden by those in a
database</div><div style="background-color: transparent;"># server specific section</div><div style="background-color: transparent;">[global]</div><div style="background-color: transparent;"> # TDS protocol version</div><div style="background-color: transparent;"> tds version = 8.0</div><div style="background-color: transparent;"> port = 1433</div><div style="background-color: transparent;"> try server login = yes</div><div style="background-color: transparent;"> try domain login = no</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"> dump file = /tmp/freetds.log</div><div style="background-color: transparent;"> debug level = 10</div><div style="background-color: transparent;"> timeout =
10;</div><div style="background-color: transparent;"> connect timeout = 10;</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"> # Whether to write a TDSDUMP file for diagnostic purposes</div><div style="background-color: transparent;"> # (setting this to /tmp is insecure on a multi-user system)</div><div style="background-color: transparent;">; dump file = /tmp/freetds.log</div><div style="background-color: transparent;">; debug flags = 0xffff</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"> # Command and connection timeouts</div><div style="background-color: transparent;">; timeout = 10</div><div style="background-color:
transparent;">; connect timeout = 10</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"> # If you get out-of-memory errors, it may mean that your client</div><div style="background-color: transparent;"> # is trying to allocate a huge buffer for a TEXT field.</div><div style="background-color: transparent;"> # Try setting 'text size' to a more reasonable limit</div><div style="background-color: transparent;"> text size = 64512</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"># A typical Sybase server</div><div style="background-color: transparent;">[egServer50]</div><div style="background-color: transparent;"> host = symachine.domain.com</div><div style="background-color: transparent;">
port = 5000</div><div style="background-color: transparent;"> tds version = 5.0</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent;"># A typical Microsoft server</div><div style="background-color: transparent;">[egServer70]</div><div style="background-color: transparent;"> host = ntmachine.domain.com</div><div style="background-color: transparent;"> port = 1433</div><div style="background-color: transparent;"><span></span></div><div style="background-color: transparent;"> tds version = 7.0</div><div><br></div><div><span style="font-size: 32px;"><br></span></div><div><span style="font-size: 32px;">odbc.ini</span></div><div><span><div><span style="font-size: small;">;[asterisk]</span></div><div><span style="font-size: small;">;Description = FreeTDS</span></div><div><span
style="font-size: small;">;Driver = FreeTDS</span></div><div><span style="font-size: small;">;Servername = 192.168.10.223</span></div><div><span style="font-size: small;">;Database = agenda</span></div><div><span style="font-size: small;">;UID = sa</span></div><div><span style="font-size: small;">;PWD = teste123</span></div><div><span style="font-size: small;">;Port = 1433</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;">;[asterisk]</span></div><div><span style="font-size: small;">;description = Asterisk ODBC for MSSQL</span></div><div><span style="font-size: small;">;driver = FreeTDS</span></div><div><span style="font-size: small;">;server = 192.168.10.223</span></div><div><span style="font-size: small;">;port
= 1433</span></div><div><span style="font-size: small;">;database = agenda</span></div><div><span style="font-size: small;">;tds_version = 8.0</span></div><div><span style="font-size: small;">;language = us_english</span></div><div><span style="font-size: small;">;UID = sa</span></div><div><span style="font-size: small;">;PWD = teste123</span></div><div><span style="font-size: small;">[asterisk]</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;">Driver = FreeTDS</span></div><div><span style="font-size: small;">Database = dados</span></div><div><span style="font-size: small;">Server = 192.168.1.103</span></div><div><span style="font-size: small;">UserName
= sa</span></div><div><span style="font-size: small;">Password = teste123</span></div><div><span style="font-size: small;">Trace = No</span></div><div><span style="font-size: small;">TDS_Version = 8.0</span></div><div><span style="font-size: small;">Port = 1433</span></div><div style="font-size: 32px;"><br></div><div><div><span style="font-size: 32px;">odbcinst.ini</span></div><div style="font-size: 32px;"><br></div></div><div style="font-size: 32px;"><br></div><div><div><span style="font-size: small;"># Example driver definitions</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"># See /usr/share/doc/unixODBC*/README.64bit for more information</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size:
small;"><br></span></div><div><span style="font-size: small;"># Use these definitions with the original unixODBC package</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"># Driver from the postgresql-odbc package</span></div><div><span style="font-size: small;"># Setup from the unixODBC-libs package</span></div><div><span style="font-size: small;">[PostgreSQL]</span></div><div><span style="font-size: small;">Description = ODBC for PostgreSQL</span></div><div><span style="font-size: small;">Driver = /usr/lib/psqlodbc.so</span></div><div><span style="font-size: small;">Setup = /usr/lib/libodbcpsqlS.so</span></div><div><span style="font-size: small;">Driver64 = /usr/lib64/psqlodbc.so</span></div><div><span style="font-size: small;">Setup64 =
/usr/lib64/libodbcpsqlS.so</span></div><div><span style="font-size: small;">FileUsage = 1</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"># Driver from the mysql-connector-odbc package</span></div><div><span style="font-size: small;"># Setup from the unixODBC-libs package</span></div><div><span style="font-size: small;">[MySQL]</span></div><div><span style="font-size: small;">Description = ODBC for MySQL</span></div><div><span style="font-size: small;">Driver = /usr/lib/libmyodbc3_r.so</span></div><div><span style="font-size: small;">Setup = /usr/lib/libodbcmyS.so</span></div><div><span style="font-size: small;">Driver64 = /usr/lib64/libmyodbc3_r.so</span></div><div><span style="font-size: small;">Setup64
= /usr/lib64/libodbcmyS.so</span></div><div><span style="font-size: small;">FileUsage = 1</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"># Use these definitions with the unixODBC64 package</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"># Driver from the postgresql-odbc64 package</span></div><div><span style="font-size: small;"># Setup from the unixODBC64-libs package</span></div><div><span style="font-size: small;">[PostgreSQL64]</span></div><div><span style="font-size: small;">Description = ODBC for PostgreSQL (64 bit)</span></div><div><span style="font-size: small;">Driver = /usr/lib/psqlodbcw.so</span></div><div><span style="font-size: small;">Setup =
/usr/lib/libodbcpsqlS64.so</span></div><div><span style="font-size: small;">Driver64 = /usr/lib64/psqlodbcw.so</span></div><div><span style="font-size: small;">Setup64 = /usr/lib64/libodbcpsqlS64.so</span></div><div><span style="font-size: small;">FileUsage = 1</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;"># Driver from the mysql-connector-odbc64 package</span></div><div><span style="font-size: small;"># Setup from the unixODBC64-libs package</span></div><div><span style="font-size: small;">[MySQL64]</span></div><div><span style="font-size: small;">Description = ODBC for MySQL (64 bit)</span></div><div><span style="font-size: small;">Driver = /usr/lib/libmyodbc5.so</span></div><div><span style="font-size: small;">Setup
= /usr/lib/libodbcmyS64.so</span></div><div><span style="font-size: small;">Driver64 = /usr/lib64/libmyodbc5.so</span></div><div><span style="font-size: small;">Setup64 = /usr/lib64/libodbcmyS64.so</span></div><div><span style="font-size: small;">FileUsage = 1</span></div><div><span style="font-size: small;"><br></span></div><div><span style="font-size: small;">[FreeTDS]</span></div><div><span style="font-size: small;">Description=ODBC for SQL Server</span></div><div><span style="font-size: small;">Driver= /usr/local/freetds/lib/libtdsodbc.so</span></div><div><span style="font-size: small;">Setup= /usr/local/freetds/lib/libtdsodbbc.so</span></div><div><span style="font-size: small;">FileUsage=1</span></div><div style="font-size: 32px;"><br></div></div><div style="font-size: 32px;"><br></div></span></div><div><span style="font-size:
32px;"><br></span></div><div class="yahoo_quoted" style="display: block;"> <br> <br> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> Em Quarta-feira, 22 de Janeiro de 2014 12:23, Bernini Asterisk <asterisk_ti@yahoo.com.br> escreveu:<br> </font> </div> <div class="y_msg_container"><div id="yiv2188911700"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"><div><span>boa tarde</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style:
normal;"><span>segue em anexo as confs e abaixo o comando que usei</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span><br clear="none"></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><span> linhas do comando</span></div><div style="background-color:transparent;"><span style="font-weight:bold;">[root@IPBX-Linux ~]# isql -v asterisk</span></div><div style="background-color:transparent;"><span style="font-weight:bold;">[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source</span></div><div style="background-color:transparent;"><span style="font-weight:bold;">[08S01][unixODBC][FreeTDS][SQL Server]Unable to connect:
Adaptive Server is unavailable or does not exist</span></div><div style="background-color:transparent;"><span style="font-weight:bold;"></span></div><div style="background-color:transparent;"><span style="font-weight:bold;">[ISQL]ERROR: Could not SQLConnect</span></div><div>valeuuuu</div><div>att</div><div>Breno Bernini</div><div><br clear="none"></div><div><br clear="none"></div><div class="yiv2188911700yqt2483471693" id="yiv2188911700yqt23694"><div class="yiv2188911700yahoo_quoted" style="display: block;"> <br clear="none"> <br clear="none"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> Em Quarta-feira, 22 de Janeiro de 2014 12:05, Bernini Asterisk <asterisk_ti@yahoo.com.br> escreveu:<br clear="none">
</font> </div> <div class="yiv2188911700y_msg_container"><div id="yiv2188911700"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"><div>opa , vou preparar o email e ja te mando ok ?</div><div><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">muito obrigado msm!!</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent;
font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">em alguns minutos ja envio</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">att</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px;
font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">Breno</div><div class="yiv2188911700yqt0522794290" id="yiv2188911700yqt57747"><div class="yiv2188911700yahoo_quoted" style="display:block;"> <br clear="none"> <br clear="none"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> Em Quarta-feira, 22 de Janeiro de 2014 11:46, Bernini Asterisk <asterisk_ti@yahoo.com.br> escreveu:<br clear="none"> </font>
</div> <div class="yiv2188911700y_msg_container"><div id="yiv2188911700"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"><div>Então instalei o <span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;">UNIXODBC + FREETDS, porém quando tento usar o comando isql -v DNS não consigo efetuar a conexão.. </span></div><div style="color: rgb(0, 0, 0); font-size: 12pt; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;">Aparece o erro s100008s01</span></div><div style="color: rgb(0, 0, 0); font-size: 12pt; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;"><br clear="none"></span></div><div
style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;"><br clear="none"></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;">usei como base esse tutorial aqui
http://herson.objectis.net/artigos/instalando-freetds-e-unixodbc </span></div><div style="color: rgb(0, 0, 0); font-size: 12pt; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;"><br clear="none"></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;">, estou usando centOS </span></div><div style="color: rgb(0, 0, 0); font-size: 12pt; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;"><br clear="none"></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier
New'; white-space: pre; font-size: 12pt;">você teria alguma dica ? ta osso to no desespero vei hehhehe valeu mesmo brother</span></div><div style="color: rgb(0, 0, 0); font-size: 12pt; font-family: 'Courier New'; background-color: transparent; font-style: normal;"><span style="font-family: 'Courier New'; white-space: pre; font-size: 12pt;"><br clear="none"></span></div><div class="yiv2188911700yqt8217982539" id="yiv2188911700yqt30546"><div class="yiv2188911700yahoo_quoted" style="display:block;"> <br clear="none"> <br clear="none"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> Em Quarta-feira, 22 de Janeiro de 2014 11:16, Bernini Asterisk <asterisk_ti@yahoo.com.br> escreveu:<br clear="none"> </font>
</div> <div class="yiv2188911700y_msg_container"><div id="yiv2188911700"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12pt;"><div>bom dia rapaziada</div><div><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">alguem ai por acaso ja integrou o ms sql ao asterisk ?</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent;
font-style: normal;">estou com uma solicitação aqui porém não consigo fazer nem fudendo</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">ja tentei com freetds porem não consegui =S</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style:
normal;">alguem pode ajudar ?</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">att</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;"><br clear="none"></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family:
HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;">Breno </div></div></div></div><br clear="none"><br clear="none"></div> </div> </div> </div></div>
</div></div></div><br clear="none"><br clear="none"></div> </div> </div> </div></div> </div></div></div><br clear="none"><br clear="none"></div> </div> </div> </div></div> </div></div></div><br><br></div> </div> </div> </div> </div></body></html>