I used the following command to connect to the MS SQL (Server 2000)<br><br><br> isql -v <ODBC-DSN> sa *******<br><br>and it worked. But if u can recomend another tool that i can use toi test this, pls do.<br><br>thanks
<br><br><br><br><div><span class="gmail_quote">On 5/19/06, <b class="gmail_sendername">Sean Cook</b> <<a href="mailto:scook@kinex.net">scook@kinex.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
have you tested to make sure that you can connect to the odbc resource<br>outside of asterisk via perl/php/(insert random language here)? Make<br>sure odbc is setup correctly and working before proceeding with the<br>asterisk part.
<br><br><br>Sean<br><br>Dumpolid Exeplish wrote:<br>> Hi,<br>> I have duetifully followed the instructions in the cdr.txt but<br>> asterisk still cannot connect to the MS SQL server. I can connect<br>> using the ODBC native connector bu asterisk still cannot
<br>><br>> On 5/16/06, *Bruce Reeves* <<a href="mailto:asterisk@nortex-networks.com">asterisk@nortex-networks.com</a><br>> <mailto:<a href="mailto:asterisk@nortex-networks.com">asterisk@nortex-networks.com</a>
>> wrote:<br>><br>> Yes you can use MSSQL with the ODBC driver, I have it working for<br>> CDR logs, I had to install unixODBC and configure it then use the<br>> cdr_odbc.conf file to specify. Check in your source files or svn
<br>> checkout for a docs folder and the cdt.txt file.<br>><br>><br>> On 5/16/06, *Dumpolid Exeplish* < <a href="mailto:dumpexec@gmail.com">dumpexec@gmail.com</a><br>> <mailto:<a href="mailto:dumpexec@gmail.com">
dumpexec@gmail.com</a>>> wrote:<br>> Hi All,<br>> How can i use Microsoft SQL server with asterisk, Can the unix<br>> ODBC diriver interface MSQL?? and what module would i be using to<br>> access ODBC from asterisk??
<br>><br>><br>> _______________________________________________<br>> --Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com</a><br>> <<a href="http://Easynews.com">
http://Easynews.com</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">http://lists.digium.com/mailman/listinfo/asterisk-users
</a><br>><br>><br>><br>><br>><br>> --<br>> Bruce<br>> Nortex Networks<br>><br>> _______________________________________________<br>> --Bandwidth and Colocation provided by
<a href="http://Easynews.com">Easynews.com</a><br>> <<a href="http://Easynews.com">http://Easynews.com</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">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>><br>><br>><br>> ------------------------------------------------------------------------
<br>><br>> _______________________________________________<br>> --Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com</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">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>><br><br>_______________________________________________<br>--Bandwidth and Colocation provided by
<a href="http://Easynews.com">Easynews.com</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">http://lists.digium.com/mailman/listinfo/asterisk-users
</a><br></blockquote></div><br>