Hi All, How can i use Microsoft SQL server with asterisk, Can the unix ODBC diriver interface MSQL?? and what module would i be using to access ODBC from asterisk?? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060516/18bbc5b1/attachment.htm
Yes you can use MSSQL with the ODBC driver, I have it working for CDR logs, I had to install unixODBC and configure it then use the cdr_odbc.conf file to specify. Check in your source files or svn checkout for a docs folder and the cdt.txt file. On 5/16/06, Dumpolid Exeplish <dumpexec@gmail.com> wrote:> > Hi All, > How can i use Microsoft SQL server with asterisk, Can the unix ODBC > diriver interface MSQL?? and what module would i be using to access ODBC > from asterisk?? > > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > >-- Bruce Nortex Networks -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060516/f830e7e0/attachment.htm
Hi, I have duetifully followed the instructions in the cdr.txt but asterisk still cannot connect to the MS SQL server. I can connect using the ODBC native connector bu asterisk still cannot On 5/16/06, Bruce Reeves <asterisk@nortex-networks.com> wrote:> > Yes you can use MSSQL with the ODBC driver, I have it working for CDR > logs, I had to install unixODBC and configure it then use the cdr_odbc.conf > file to specify. Check in your source files or svn checkout for a docs > folder and the cdt.txt file. > > > On 5/16/06, Dumpolid Exeplish <dumpexec@gmail.com> wrote: > > > Hi All, > How can i use Microsoft SQL server with asterisk, Can the unix ODBC > diriver interface MSQL?? and what module would i be using to access ODBC > from asterisk?? > > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > -- > Bruce > Nortex Networks > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060519/ba4aafd9/attachment.htm
have you tested to make sure that you can connect to the odbc resource outside of asterisk via perl/php/(insert random language here)? Make sure odbc is setup correctly and working before proceeding with the asterisk part. Sean Dumpolid Exeplish wrote:> Hi, > I have duetifully followed the instructions in the cdr.txt but > asterisk still cannot connect to the MS SQL server. I can connect > using the ODBC native connector bu asterisk still cannot > > On 5/16/06, *Bruce Reeves* <asterisk@nortex-networks.com > <mailto:asterisk@nortex-networks.com>> wrote: > > Yes you can use MSSQL with the ODBC driver, I have it working for > CDR logs, I had to install unixODBC and configure it then use the > cdr_odbc.conf file to specify. Check in your source files or svn > checkout for a docs folder and the cdt.txt file. > > > On 5/16/06, *Dumpolid Exeplish* < dumpexec@gmail.com > <mailto:dumpexec@gmail.com>> wrote: > Hi All, > How can i use Microsoft SQL server with asterisk, Can the unix > ODBC diriver interface MSQL?? and what module would i be using to > access ODBC from asterisk?? > > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com > <http://Easynews.com> -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > -- > Bruce > Nortex Networks > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com > <http://Easynews.com> -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > ------------------------------------------------------------------------ > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
I used the following command to connect to the MS SQL (Server 2000) isql -v <ODBC-DSN> sa ******* and it worked. But if u can recomend another tool that i can use toi test this, pls do. thanks On 5/19/06, Sean Cook <scook@kinex.net> wrote:> > have you tested to make sure that you can connect to the odbc resource > outside of asterisk via perl/php/(insert random language here)? Make > sure odbc is setup correctly and working before proceeding with the > asterisk part. > > > Sean > > Dumpolid Exeplish wrote: > > Hi, > > I have duetifully followed the instructions in the cdr.txt but > > asterisk still cannot connect to the MS SQL server. I can connect > > using the ODBC native connector bu asterisk still cannot > > > > On 5/16/06, *Bruce Reeves* <asterisk@nortex-networks.com > > <mailto:asterisk@nortex-networks.com>> wrote: > > > > Yes you can use MSSQL with the ODBC driver, I have it working for > > CDR logs, I had to install unixODBC and configure it then use the > > cdr_odbc.conf file to specify. Check in your source files or svn > > checkout for a docs folder and the cdt.txt file. > > > > > > On 5/16/06, *Dumpolid Exeplish* < dumpexec@gmail.com > > <mailto:dumpexec@gmail.com>> wrote: > > Hi All, > > How can i use Microsoft SQL server with asterisk, Can the unix > > ODBC diriver interface MSQL?? and what module would i be using to > > access ODBC from asterisk?? > > > > > > _______________________________________________ > > --Bandwidth and Colocation provided by Easynews.com > > <http://Easynews.com> -- > > > > Asterisk-Users mailing list > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > > > > > > > -- > > Bruce > > Nortex Networks > > > > _______________________________________________ > > --Bandwidth and Colocation provided by Easynews.com > > <http://Easynews.com> -- > > > > Asterisk-Users mailing list > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > --Bandwidth and Colocation provided by Easynews.com -- > > > > Asterisk-Users mailing list > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060522/49f6de7a/attachment.htm