similar to: how can i connected sql server with odbc dsn on .net

An ODBC DSN has been setup successfully on wine. "wine isql DSN" has verified the connection. Now a linux application wishes to connect this DSN. Is it possible? Proxies like ODBCSocketServer or DBTCP would be the last choice because there shouldn't be any need for yet another layer. Put it this way. It is possible to do it the other way round (i.e. wine application connects to

Hi, I'm trying to use RODBC without having to set up a DSN, using hte direct connection string in odbcDriverConnect. My connection attempt looks something like: > odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;") And this returns the message: Warning messages: 1: In odbcDriverConnect(connection =

Hi I have in an existing windows installation a large number of 'system DSN data sources' which I would like to have under wine. Is it possible to import these? I know about the file DSN and that they are files in a directory, but that doesnt help. Rainer

Hi all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

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 = and /etc/odbcinst.ini

Hello everybody, I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file

Has anyone here been able to get native ODBC MS SQL connection working in Wine while the Windows version is set to XP? I've been able to get it working as long as it's set to Win98, but that's a bit of a problem now. I'm currently running an application that no longer works or is supported in Windows 98. The aplication starts fine in WinXP mode, except for the fact that it cannot

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 => "odbc", :dsn => "<dsn

Hi, I am using ubuntu-12.04 and installed asterisk from repository (apt-get install asterisk). I have configured it to work with odbc, *CLI> odbc show ODBC DSN Settings ----------------- Name: asterisk DSN: asterisk-connector Last connection attempt: 1970-01-01 05:30:00 Pooled: No Connected: Yes But it still show me the following error [Jul 31 12:36:18]

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 ConnSettings=

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

Happy New Year to all in the list! I am trying to issue an SQL query to a database from R using RODBC (on Windows). The data source file is on my PC hard disk : C:\Program Files\ODBC\sql.dsn The "\" character does not get interpreted properly in R - it is removed from the file-spec string or if I specify "\\" it appears as such with a syntax error in odbcConnect(dsn,

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

Hi all, i am running a application which uses ODBC DSN. this is file and connecting with MS sql server. but when i run my program as $ wine c:\\crm\\PMonitor.exe i get fixme:vxd:VXD_Open Unknown/unsupported VxD L"secprov.vxd". Try setting Windows version to 'nt40' or 'win31'. But setting to this versions doesnot help as it provides dsn error like nddeapi.dll could not

Under WinXP, I have a system DSN called foo. It has stored username/password information. (I can click Configure in ODBC Administrator and then Test Data Source connects to MySQL without me re-entering data.) Using RODBC, I can connect to the same database. But when I do odbcConnect("foo"), I get a window that requires me to re-enter username/password information. It seems like

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 databases & tables ! Asterisk fails to

Hi, i?m trying to access a MSSQL server (in a windows machine in the network) from a Visual Basic Application running under wine, using an ODBC driver. Since there aren?t any MSSQL drivers for linux i decided to use de native ones, so i installed mdac_typ.exe . Then i configured the DSN using odbcad32.exe but when i tested the connection (configured using tcp/ip) an error message appeared

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems 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

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend: