similar to: Ruby on Rails connection using ODBC

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

hi to all, it is posible to use activerecord-jdbc with the jdbc-odbc bridge? i have problems to use ajax_scaffold. i get an error message, that the driver is unable to choose type for date from(list of datatypes) my database.yml look like development: adapter: jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver url: jdbc:odbc:ac43demo username: ac_odbc password: ac_odbc i have modified the

I am having a strange issue. I have upgraded to ruby 1.9.1 to do some testing on one of my machines. My app accesses a MSSQL database to pull in some information. Everything worked fine with ruby 1.8.6, but now if I try to navigate to a page that accesses that database I get this error: DBI::InterfaceError in PagesController#company Unable to load driver ''ODBC'' (underlying

I''m currently trying to connect rails to a legacy SqlServer database. System is windows XP and my attempts to connect with activerecord sql adapter and ADO.rb file failed miserably (I wrote a mail about it before) So it seems like odbc adapter is more recent compared to sql adapter and probably more used. I''m using active_record_store as session store, and probably the first

Greetings, I have an application that connects to a remote SQL Server database using DBI/ODBC. If I run the application via the Rails console, I am able to retrieve data and work with the database just fine. If, however I try to access it via the Web application itself, I get the following error: DBI::DatabaseError (S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source):

Hi All, I am running into a little issue the ODBC adapter: rails: 1.2 ruby: 1.8.4 ODBC ruby binding: .0997 Rails ODBC adapter: 1.4 I have added the ruby bindings to the /ruby/1.8/i386-msvcrt and used gem to install the ODBC adapter I updated the enviroment.rb when I run ruby -e ''require "odbc"'' it appears to correct (no error response) 1. Is my understanding

I hope this is the place to post errors, and solicit help....if not, my apologies... I inherited a RoR app, and it was working great for the longest time....however, i have recently started receiving the following error: ***************************************************************** A DBI::DatabaseError occurred in repairs#edit: IM002 (0) [unixODBC][Driver Manager]Data source name not

R-sig-Debian help, I have installed an ODBC Driver for Linux. I want to connect to our database through R via: >library(RODBC) >con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") Warning message: In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") : ODBC connection failed I don't really know whether this

Hi all. I''m in a project right now where I''m using the ODBC adapter to connect to a MS Sqlserver DB (believe me, it''s not my choice). Is there any way to get the SQL queries being generated a la the log when using MySql? Thanks, Andrew --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

Hi, im trying to get an odbc connection to work. Its no problem if asterisk an mysl running on one machine. When i try to set up an external DB it won't connect. External connections to the db are possible (bind-address = 0.0.0.0 and the user asterisk is allowed to connect from each ip). The password in the config is the right one i already double checked it. Jul 23 12:31:54

Hi. I have an Asterisk 13.14.1 setup which uses ODBC to write CEL and CDR records. The connection to my database server depends on a VPN tunnel being up, and if Asterisk starts before that tunnel is functional, I get messages such as the following in the Asterisk log file: [2020-06-23 10:40:22.384335] delta WARNING[1697]: res_odbc.c:958 in odbc_obj_connect: res_odbc: Error SQLConnect=-1

Hi, I made a UserDSN using "wine control". Driver Mysql ODBC 5.1 Driver is installed under wine. I can connect to the Database. I want to connect to a table in that DB using Lotus Approach. After connecting I see only Datafields with INT values. All Fields with VARCHAR values are not displayed. In the UserDSN configuration window I changed the charset option of the Mysql ODBC Connector

i''m running ruby 1.8.5 and rails 1.2.3 on windows with a bunch of mongrels that are proxybalanced via apache 2.2.4 the db adapter i''m using is the sqlserver one in ADO mode. so it''s using win32ole. when a mongrel service is freshly started it consumes about 40 megs of ram. but about each and every request is leaking memory. about 20 megs per hour(!!!). so after half a

Hi, I am on a windows 2000 machine and want to use an ms access 97 database (*.mdb) as db backend. I did a clean install: ruby, gems, rails, odbc-rails. A test rails application connecting to a local mysql server is doing fine. I can also locally connect to the odbc connection "local_odbc_name" with the aqua data studio client. But now with rails. As soon as I change the adapter to

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

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][ODBC 3.51 Driver]SSL connection error

I am on a mac. Have been developing using a manually installed (according to the hivelogic instructions) ruby, rails, gems, mongrel setup. Life was good. When I noticed that my ruby version was out of date, I decided to switch to using macports to maintain the software on my mac. I used it to install a new ruby and gems, and then used gems to get the latest rails. Life seemed to be good. Next I

Hi, I wish to integrate a Microsoft SQL server with Asterisk for CDRs and for dialplan routing based on database values, and have this application scale to a large number of simultaneous calls: The Asterisk: The Future of Telephony 2nd edition book states that: ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple

Hi all Does anyone know of a variable that i could check to see if the reason func odbc didnt return results was because of a timeout error so i could play a audio file about that thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20141111/a3578df5/attachment.html>

Workstations in our network fail to make ODBC SQL server connections using NT authentication mode. This is our situation: We are running Samba 2.2.7a as PDC. We also have one Windows 2000 server running MSSQL server and being a member of this domain. The MSSQL server is used by an accounting program (Exact Globe 2000) running on several client computers in our network (members of the domain).