Pat,
What i'm trying to figure out is how to keep the sql statement
globally prepaired then just call SQLExecute but the docs for all this are
hard to come by. I really can't tell much diffrence in odbc over mysql in
speed but I don't have a bazillion calls going thru at once. It does add
a layer of abstraction that should allow it to work with just bout any DB
server that has a driver for unixODBC
These include:
MySQL
Postgres
Oracle
DB2
and more... http://www.unixodbc.org/drivers.html
bkw
On Tue, 25 Nov 2003, pat munis wrote:
> Brian
> Good job!!! Is there any perfomance hit by using unixodbc as oppossed to for
> example using cdr_mysql for mysql?
>
>
>
> ----- Original Message -----
> From: Brian West <[EMAIL PROTECTED]>
> Date: Tue, 25 Nov 2003 07:19:27 -0600 (CST)
> To: [EMAIL PROTECTED]
> Subject: Re: [Asterisk-Users] cdr_unixodbc
>
> > Ok the basic requirement is unixODBC and the MyODBC driver(for MySQL) or
> > you can pick what ever you want(http://www.unixodbc.org/drivers.html).
> > The table structure is the same as pgsql or mysql ... just duplicate that.
> >
> > I would like to verify that I have done this in such a way that the
> > database you choose to use won't matter(unixODBC is all about that)
> >
> > odbc.ini info:
> >
> > [ODBC Data Sources]
> > MySQL-asterisk = MySQL ODBC Driver Asterisk DSN
> >
> > [MySQL-asterisk]
> > Description = MySQL ODBC Driver Asterisk DSN
> > Driver = MySQL
> > Socket = /var/run/mysqld/mysqld.sock
> > Server = localhost
> > User = root
> > Database = asterisk
> > Option = 3
> > #Port =
> > Password = password
> >
> > odbcinst.ini
> >
> > [MySQL]
> > Description = MySQL ODBC MyODBC Driver
> > Driver = /usr/lib/libmyodbc3.so
> >
> > ... I will give you guys time to do that ... and i'm still cleaning up
> > the code a bit more. unixODBC is a bit more forgiving than the MySQL C
> > API is.
> >
> >
> > bkw
> >
> >
> > On Tue, 25 Nov 2003, WipeOut wrote:
> >
> > > Pavel Litvinenko wrote:
> > >
> > > > Brian West wrote:
> > > >
> > > >> asterisk*CLI> load cdr_unixodbc.so
> > > >> Loaded /usr/lib/asterisk/modules/cdr_unixodbc.so => (unixODBC CDR
> > > >> Backend)
> > > >> == Parsing '/etc/asterisk/cdr_unixodbc.conf': == Parsing
> > > >> '/etc/asterisk/cdr_unixodbc.conf': Found
> > > >> -- cdr_unixodbc: dsn is MySQL-asterisk
> > > >> -- cdr_unixodbc: username is root
> > > >> -- cdr_unixodbc: password is [secret]
> > > >> -- Connected to MySQL-asterisk
> > > >>
> > > >> it works.. it logs calls. Anyone else intrested? For now I have to do
> > > >> more clean up... ya know make it pretty. :)
> > > >>
> > > >>
> > > > Yes, I do :) where can I get it ?
> > > >
> > > What are the software requirements?
> > >
> > > I have never used unixodbc before.. :)
> > >
> > > Later..
> > >
> > > _______________________________________________
> > > Asterisk-Users mailing list
> > > [EMAIL PROTECTED]
> > > http://lists.digium.com/mailman/listinfo/asterisk-users
> > >
> > _______________________________________________
> > Asterisk-Users mailing list
> > [EMAIL PROTECTED]
> > http://lists.digium.com/mailman/listinfo/asterisk-users
>
> --
> ___________________________________________________________
> Sign-up for Ads Free at Mail.com
> http://promo.mail.com/adsfreejump.htm
>
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
