similar to: SQL server DB acces

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

All, I have a set of users who are currently using RODBC on Solaris (2.6 and up) to connect to SQL Server databases. We use unixODBC for a driver manager and Easysoft's ODBC-ODBC bridge underneath. R 1.6.2 is our standard R version. While moving to Linux (RedHat 9) I have become eager to phase out our use of Easysoft, but am tied to SQL Server for the time being. I am curious as to

Hi, i want to load the cdr into oracle using unixODBC. I'm using RH 9 2.4.20-30.9smp, unixODBC 2.2.6, easysoft odbc driver for oracle 1.3.1. My unixODBC is working well. With isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any

Hi I have problems trying to load asterisk call data into the cdr table using cdr_odbc config. My unixODBC is properly configured and it's working fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow:

Hi I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error > library(RODBC) > setwd (paste("/home/oracle/scripts/R")) > channel

Hi, Version info: R: 1.5.1 RODBC: 0.8.3 Oracle: 8.1.7 unixODBC: 2.2.2 Easysoft ODBC driver: 1.0.0.6 SunOS/Solaris: 5.7 I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection

Just in case anyone with FC4 and maybe other distros were trying to use unixODBC-2.2.11 and wine's built in odbc32. If your app errors out when you issue a query with an undefined symbol of __post_internal_error you will need to use an early snapshot of the 2.2.12 unixODBC that resolves this issue... Nick Gorham wrote: > Adam Gibson wrote: > >> Using freetds-0.63-1.2.fc4.rf

I have a Zope + DCOracle2 setup, and I was thinking of moving to Zope + eGenix ODBC (which will use unixODBC) however that still leaves me lacking a driver to connect this to the Oracle server. There are a number of variously priced commercial drivers out there like EasySoft, Merant, OpenLink, etc. Someone built upon a previous open source EasySoft driver:

Howdy, I'm trying to use R to access Oracle 8i using the RODBC package On Linux Red Hat 7.3. Specs R version 1.51 Driver: Easysoft ODBC - Oracle driver Driver Manager: unixODBC I get the following error when trying to executing RODBC commands. Can anybody give me pointers as to what I'm missing or doing wrong > library(RODBC) > channel <- ("DSNName") >

[sorry, but this is a re-post - I forgot to set the subject line the first time around] Hello, I would like to access an Oracle database running on Solaris from R on my linux desktop. I have had a look at the R Data Import/Export manual, and downloaded RODBC and unixODBC, but I am still quite confused about how to proceed. It appears to me that I still need to get an Oracle ODBC driver, and

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail

Hi, I have another problem, can you help? When i type: > library(RODBC) > a<-odbcConnect("oracle") > sqlQuery(a,"select DISTINCT(DOENT_ID) from EPISGDHS where (VALFACT BETWEEN 100 AND 50)") Comes the error: [1] "S1000 904 [unixODBC][Easysoft][Oracle]ORA-00904: \"DOENT_ID\": invalid identifier at offset 16" [2] "[RODBC] ERROR: Could

Hi, I have a problem, can you help? When i type: > library(RODBC) > a<-odbcConnect("oracle") > sqlQuery(a,"(select VALFACT>500 from EPISGDHS) UNION (select VALFACT<1000 from EPISGDHS)") Comes the error: [1] "S1000 923 [unixODBC][Easysoft][Oracle]ORA-00923: FROM keyword not found where expected at offset 15" [2] "[RODBC] ERROR: Could not

Hello All i need to transfer CDR data from linux to MS SQL Serever (on Windows). writing by Perl. I have download and install UnixODBC, DBI, DBD from CPAN, when i tested isql -DSN -UID - PWD, that's successful, but when run by perl, message alert could not loaded driver database, .... anybody used ODBC for linux, connect to MS SQL Sevre, please help me? easysoft and openlink have

[copying the rails list for more feedback] On 3/17/06, Jakob Skjerning <jakob@mentalized.net> wrote: > I believe you''re currently the man putting a lot of effort into the > Rails SQL Server adapter - is this correct? Somewhat. I am maintaining the SQLServer adapter but I''m not doing quite as much as I''d like with it and you certainly can''t call

Hey Ryan, I asked this question awhile back, but any support planned for table returning functions, or stored procedures? I''m envisioning basically a mutable model class where you have 1 or more instance variables defined (with default values) that are used in the SQL queries as input parameters. When you instantiate the class you can specifically define these parameters or use the

Hello, I get last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed randomly in the logs: --- ???????1 mailserver dovecot: imap(test-email-bb at exemple.com) <NtiT9H2SFIVcuGID> [xxx.xxx.xxx.xxx]: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: INSERT, UPDATE command denied to user

Request: Full description of mechanims required to intergrate current Ruby / Ruby on Rails with MS SQL Server 2005 Environment: * Ruby 1.8.6-25 (ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32]) * Rails 1.2.3 * ruby-dbi 0.1.1 (installed dbi,dbd_ADO) * OS: Windows XP Professional sp4 * MS SQL Server Express 2005 installed on local machine Background: I have used various settings for the

Greetings, I was wondering if anyone on this list has any experience using Ruby/Rails with either DB2 or SQLServer. We''re currently in the later planning stages of two RoR applications and I''m not 100% sure about the state of these two drivers. Googling for this information locates multiple sites that discuss various driver implementations (DBI, etc) for both databases.

Anyone out there using Linux RODBC and unixODBC to connect to a Microsoft SQL server? If possible can someone post a sample .odbc.ini file? I saw a few discussions on the archives a few years ago, but no config file details were available. Thanks, Whit This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended