Forget about MS SQL, odbc drivers that run on linux to talk to MS SQL stink Odbc in general stinks.
You might be able to get MS SQL DTS (data transformation services) to link to the mysql database and present the data as it were in your ms sql database. There is a pretty good odbc 3.51 mysql driver for windows, as well as a .net provider. Both at www.mysql.org. Mysql is free, * will talk to is using the native TDS You can run the windows version of mysql on a windows box if you wish, but why? Faster if it is on the same box as asterisk unless * is heavily loaded. I tried the * > realtime > odbc > mssql thing, gave up after having poor results getting the various ms sql drivers for linux to work right. our main app uses data in ms sql and mysql and there is a common key in the data to link accounting data with the * user data for views where they are both required. We also use mysql for cdr for billing purposes. I was much more comfortable with .net ms sql, but the transition and integration with mysql was easy. Just store the asterisk specific data in mysql, everthing else in ms sql if you must. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:asterisk-users- > [EMAIL PROTECTED] On Behalf Of Irakli Natsvlishvili > Sent: Tuesday, June 14, 2005 12:04 AM > To: 'Shamsul Arefin'; 'Asterisk Users Mailing List - Non-Commercial > Discussion' > Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and so > on in DB > > Could you go with some details? What was better performance, stability? > All our user info is in MS SQL and we have billing based on it, so it > won't > be easy to move to mysql. > > I.N. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shamsul > Arefin > Sent: Monday, June 13, 2005 10:36 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] Keeping users, extensions,voicemail and so > on > in DB > > Yes it is now possible to store configuration files in database, via > Mysql support or via ODBC. But we have find that Mysql is works much > better. > > regards > shams > > On 6/14/05, Irakli Natsvlishvili <[EMAIL PROTECTED]> wrote: > > Hello, > > > > I have one question regarding *. Default configuration for asterisk is > to > > keep configuration(s) in ordinary text based config files. > > > > My question is simple: is it possible to keep those config info (at > least, > > to start from - sip.conf, extensions.conf and voicemail.conf) on a > database, > > which asterisk access via ODBC. If it is possible, I'd appreciate if > someone > > points me where I can read more about it and shows me some examples. > Also > > I'd like to know, how asterisk behaves (in terms of stability and > > performance) in this environment. > > > > > > I.N. > > > > _______________________________________________ > > Asterisk-Users mailing list > > Asterisk-Users@lists.digium.com > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > -- > Best Regards > Shamsul Arefin > Saktek Technologies > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users