search for: odbc

Hello, I am trying to set up cdr logging into MariaDB through ODBC. I have installed unixodbc unixodbc-dev and now I am struggling with configuring /etc/odbcinst.ini All the examples online use non-existent libraries, ie: [MySQL] Description = MySQL ODBC MyODBC Driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/li...

Hi. I can't figure this one out. Hope someone can help me. root@pbx:# cat /etc/odbc.ini [Asterisk] Description=PostgreSQL asterisk Driver=PostgreSQL Trace=No TraceFile=/tmp/odbc.log Database=asterisk ServerName=localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSett...

hi, i have the same problems as in https://issues.asterisk.org/jira/browse/ASTERISK-25833 my current combination is centos 6 32-bit, unixODBC 2.3.2 (recompiled from fedora20), mysql 5.1.73, mysql-connector-odbc 5.1.5, asterisk 13.9.1 i tried update to mysql-connector-odbc 5.3.6 from oracle but it segfaults every time can you share your working mysql+odbc combination? thanks odbcinst.ini [ODBC] Trace=No Pooling=Yes Threading=0 [...

Hi there.... I'd like to know how to use WINE with applications developed in Windows that use net components (such as ODBC clients)......For example: I developed an application in VB6, and it uses an Oracle ODBC conexion (previously I installed the Oracle client). Hot do I use it in Wine? - Do I need to emulate the Oracle ODBC Client for Windows? - If I got a Native Linux ODBC conexion, is there no need to emulate...

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter...

I know this is very off topic, but getting MySQL and unix ODBC to play nice via SSL on Centos has been a battle. I finally have it working via isql but when I connect via Oracle I get an error. If I use the mysql odbc connector directly: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][MySQL][...

Hi, I got a big project where i need to read an visual fox pro database, got this working on a windows server running php. But i would like to run this app on a linux machine(ubuntu 11.10). My idea was to use wine to setup the odbc driver and connect to it using php running on my linux machine. Now my question is if this is posible? Many thanks, Ricardo

Hi, I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf configured and modules.conf have preload => res_odbc.so preload => res_config_odbc.so extconfig.conf has queue_log => odbc,asterisk. When I start asterisk I get the following messages. The important one being: Realtime mapping for 'queue_log' found...

The wine odbc stub (odbc32.dll) has a environment variable to point to unix odbc driver: LIB_ODBC_DRIVER_MANAGER=/usr/lib/libodbc.so.1 Is there a stub to use MySQL ODBC driver: /usr/lib/libmyodbc3.so.1 ? I have an application that uses the MySQL ODBC driver and I coul not install the native driver : mys...

Hi Greetings to all Is my first post in this forum sorry for my english Many compliment to all developers for great work in Wine Profili2 is the most famous Windows software for designe airfoil profile for RC airplane models. Some times ago I have installed it in ubuntu 10.10 by Wine(1.3.5) with success This software use an mdb file First I have installed Profili download in this web site

Hello all, I try to setup weight watchers Points Plan. It runs fine exept it needs ODBC. I installed unixODBC on my Gentoo Box which got me one step further. Atm I have the Problem that the App Complains that it does not know what to do with the ODBC access it demands. Here the exact Error message of ODBC: [unixODBC][Driver Manager] Data Source Name not found, and no default drive...

Hi I was trying to have realtime voicemail working with ODBC Driver. Everything works fine with MySQL Realtime access, BUT as I want to implement ODBC Storage as well, it seems that everything should go through ODBC ( what I read on voip-info wiki page ) But I do not manage to make it work with ODBC. Outside Asterisk, ODBC works fine, I can access my databas...

Hey :) We''re doing this large project, based on a legacy MSSQL database. We''ve had some issues, particularly with datetimes, when communicating with the server. These issues dissapeared after updating our ruby-odbc package to a new version (we''re developing on Linux and MacOS X, and connecting to the remote MSSQL server via FreeTDS and UnixODBC/iODBC, and then ruby-odbc in Ruby). Problem is, when we run the application on the production server which runs Windows, the problems remain. AFAICT, the rub...

Hello, I'm stuck with getting cdr records stored in MySql database. I have a working realtime environment and have verified that the db connection works fine when used via res_config_mysql.conf. I'd appreciate Your help on how to get the odbc connector working as I think there's something wrong with its configuration. The problem presented itself as an error when making a call that was supposed to be stored in mysql cdr: Unable to retrieve database handle. CDR failed. This kept popping up every time I was trying to have a call be s...

I use realtime on my asterisk installation. I have always used mysql for my realtime connection but as mysql seems to be on the "soon to be deprecated" list of asterisk features I am trying to move to ODBC (still using MariaDB/Mysql on backend). I find ODBC support in Asterisk very unstable. Just today my asterisk server (a test server and a production server) has crashed often or simply hangs because it says ODBC is disconnected. I can use the isql tool to query my database without any inter...

Dear R Beginners, Experts and Users, I already asked this question on the R-sig-DB mailing list, but sadly didn't got a reply :-( . Keeping fingers crossed that I have more luck on the main R mailinglist :) . I'm trying to connect to a MySQl database via Gnu R using the RODBC interface. The conenction workes but I get an empty result string. Gnu R and the MySql DB are running on a 64 bit server. I installed version 5.1 of the mysql ODBC interface files [1]. My unixODBC setup file is given in [2], the setup was tested with "isql" and works [3]. If I connect fro...

Hi, I am trying now for over 4 hours setting up cdr-logging via odbc into a mysql database. But with no success. Do you have any hint for me? cat /etc/odbc.ini ------------------ [MySQL-asterisk] Description = MySQL ODBC Driver Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = localhost User = xxx Password = xxx Database = asterisk Option = 3 Port = an...

...lems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver ''ODBC'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:286:in `load_driver'' from /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:236:in `load_driver'' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb...

I current have a working Asterisk 1.2.12 server with ODBC voicemail storage, realtime static maps for voicemail, sip and iax configuration files. Realtime extensions, etc. All works great. I have verified that this configuration works on my test server as well. Now I am trying to test the 1.4B3 version on the same test server, and all works well except...

...Static configuration files: > ; > ; file.conf => driver,database[,table[,priority]] > ; > ; maps a particular configuration file to the given ; database driver, database and table (or uses the ; name of the file as the table if not specified) ; ;uncomment to load queues.conf via the odbc engine. > ; > ;queues.conf => odbc,asterisk,ast_config ;extensions.conf => sqlite,asterisk,ast_config ; ; The following files CANNOT be loaded from Realtime storage: > ; asterisk.conf > ; extconfig.conf (this file) > ; logger.conf > ; > ; Additionally, the following files...