Ah, thank you, that example helped. I would have expected the output to be<div>"Connected: No" instead of no output - the current way of (not) displaying it is somehow confusing.<br><br><div class="gmail_quote">2012/8/19 Bryant Zimmerman <span dir="ltr"><<a href="mailto:BryantZ@zktech.com" target="_blank">BryantZ@zktech.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span style="font-family:Arial,Helvetica,sans-serif;font-size:10pt"><p>Dough<br>
<br>
Here is an example from one of our production server. You can see the connection info in red. If you are not connected you don't usually get that. <br>
<br>
ODBC DSN Settings<br>
-----------------</p>
<p> Name: AsteriskCxxxxx<br>
DSN: Ast_Cxxxxx</p><div class="im"><br>
Last connection attempt: 1969-12-31 19:00:00<br>
</div><strong><span style="color:#c00000"> Pooled: No<br>
Connected: Yes</span></strong><p></p>
<p> Name: AsteriskFxxxxx<br>
DSN: Ast_Fxxxxx</p><div class="im"><br>
Last connection attempt: 1969-12-31 19:00:00<br></div>
<strong><span style="color:#c00000">Pooled: No<br>
Connected: Yes</span></strong><p></p>
<p> <br>
<strong><span style="color:#c00000">NOT CONNECTED:</span></strong><br>
<strong>Name: AsteriskFxxxxx_B1<br>
DSN: Ast_Fxxxxx_B1<br>
Last connection attempt: 2012-08-10 09:19:52</strong></p>
<p> Name: AsteriskVOIPxxxxx<br>
DSN: AST_MxxxxxVOIP</p><div class="im"><br>
Last connection attempt: 1969-12-31 19:00:00<br></div>
<span style="color:#c00000"><strong> Pooled: No<br>
Connected: Yes</strong></span><p></p>
<p> Name: AsteriskVOIPxxxxx_B1<br>
DSN: AST_MxxxxxVOIP_B1</p><div class="im"><br>
Last connection attempt: 1969-12-31 19:00:00<br></div>
<span style="color:#c00000"><strong>Pooled: No<br>
Connected: Yes<br>
</strong></span><br>
zktech<br>
<span style="font-family:tahoma,arial,sans-serif;font-size:10pt"><br>
<hr width="100%" size="2" align="center">
<b>From</b>: "Doug Lytle" <<a href="mailto:support@drdos.info" target="_blank">support@drdos.info</a>><br>
<b>Sent</b>: Sunday, August 19, 2012 10:02 AM<br>
<b>To</b>: "Asterisk Users Mailing List - Non-Commercial Discussion" <<a href="mailto:asterisk-users@lists.digium.com" target="_blank">asterisk-users@lists.digium.com</a>><br>
<b>Subject</b>: Re: [asterisk-users] Verifying if Asterisk is connected using ODBC?</span><div><div class="h5"><br>
<br>
Stefan at WPF wrote:<br>
> how can I verify if Asterisk is connected to a database using the ODBC <br>
> connection I configured? <br>
<br>
Mine shows:<br>
<br>
odbc show<br>
<br>
ODBC DSN Settings<br>
-----------------<br>
<br>
Name: MySQL-Administration<br>
DSN: MySQL-Administration<br>
Last connection attempt: 1969-12-31 19:00:00<br>
<br>
Name: MySQL-CID<br>
DSN: MySQL-CID<br>
Last connection attempt: 1969-12-31 19:00:00<br>
<br>
Name: MySQL-Conferencing<br>
DSN: MySQL-Conferencing<br>
Last connection attempt: 1969-12-31 19:00:00<br>
<br>
Name: MySQL-blacklisted<br>
DSN: MySQL-blacklisted<br>
Last connection attempt: 1969-12-31 19:00:00<br>
<br>
<br>
Doug<br>
<br>
<br>
-- <br>
Ben Franklin quote:<br>
<br>
"Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."<br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
<br>
</div></div><p></p></span>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>