<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<br />
Last connection attempt: 1969-12-31 19:00:00<br />
<strong><span style="color: #c00000;"> Pooled: No<br />
Connected: Yes</span></strong></p>
<p> Name: AsteriskFxxxxx<br />
DSN: Ast_Fxxxxx<br />
Last connection attempt: 1969-12-31 19:00:00<br />
<strong><span style="color: #c00000;">Pooled: No<br />
Connected: Yes</span></strong></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<br />
Last connection attempt: 1969-12-31 19:00:00<br />
<span style="color: #c00000;"><strong> Pooled: No<br />
Connected: Yes</strong></span></p>
<p> Name: AsteriskVOIPxxxxx_B1<br />
DSN: AST_MxxxxxVOIP_B1<br />
Last connection attempt: 1969-12-31 19:00:00<br />
<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" <support@drdos.info><br />
<b>Sent</b>: Sunday, August 19, 2012 10:02 AM<br />
<b>To</b>: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br />
<b>Subject</b>: Re: [asterisk-users] Verifying if Asterisk is connected using ODBC?</span><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 http://www.api-digital.com --<br />
New to Asterisk? Join us for a live introductory webinar every Thurs:<br />
http://www.asterisk.org/hello<br />
<br />
asterisk-users mailing list<br />
To UNSUBSCRIBE or update options visit:<br />
http://lists.digium.com/mailman/listinfo/asterisk-users<br />
<br />
</p></span>