similar to: ODBC to Web Service -- any advice?

The SQL Server adapter can currently operate in two modes, ADO and ODBC, each of which uses a different interface to access the db. The ADO interface is currently the default, while ODBC can be specified as an option. I propose this situation is reversed, and that use of the ADO interface is deprecated, if not removed altogether. Here are some reasons, I'm sure there are more: a) ADO uses

Hello- I have a Rails web app that is database-centric (go figure). What I would like to do is expose certain parts of this database to an application running on a Windows box (or whatever). For the moment, let''s consider the read-only case, but authentication will be required. Is SOAP what would be used for something like this? Are there better alternatives? The existing

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

I have an app that needs to retreive data through an ODBC connection on a windows platform. Has anyone done this? Would someone be able to walk me through it? or point me to the relavant docs. My searches haven''t turned up any usefull information so far. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson

Hello-- I''m investigating the API facet of my site and wanted to ask a couple questions: 1. The Agile book describes adding an API using the web_services generator which adds stuff to app/api. In Rails 1.1, Jamis added some wants.xml stuff to the controller code which also allows API generation. Which is better to use now? Do they mutually exclude one another? 2. In some cases, I

Ok. I was sucessful in installing ODBC storage I'm using MySQL in the backend as it is. but all my drivers are now ODBC. I am running asterisk-cvs head as of last night 9/19/05 My question is this... the old voicemail.cgi script that allowed checking voicemail no longer works etc, and never did work for me without a static voicemail.conf file. Anyways.. that aside... how does one retrieve

Hi there, I'm having a PowerBuilder aplication that connects to a Sybase data base through an ODBC. The application works fine on Windows, but I want to make it run on a Mandriva 2010.2 distribution. The fact is, I could run it on a machine with Mandriva 2010.2, but now I want to do an installation from scratch to another computer, but it does't work. The kernel version that I'm

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 All. After some input, I created a V1.1 version of my ODBC VM retrieval from the ODBC_Storage It now uses either Mysql or unixODBC drivers to connect to the database I didn't have php compiled with unixODBC so i had to recompile it in "./configure --with-unixODBC --with-mysql --with-apxs2=./blah/blah/blah" make make install after all that it worked. see the Readme and

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Struggled a whole day, but still could not get DCOM working on my machine. What I did is: 1. Installed R 2.8.1 under folder "../R/R-2.8.1" 2. Installed R_Scilab_DCOM3.0-1B5 under folder ".. \R\(D)COM Server" 3. Installed packages: rscproxy_1.0-12, RExcelInstaller_3.0-10, rcom_2.0-4... 4. run the following commands: library(rscproxy) library(rcom)

Hi, I''m getting some trouble in connecting to a sql server 2000 database with ActiveRecord-2.0.1 and ruby 186-26, from win XP. Using the next conenction config: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :database => "nombre_bd", :username => "usu", :password => "contra" ) I have the next error:

Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions

Hello, first , I would like to thank you for your great work with wine. When will be possible I fine implementation of ODBC support in wine? the actual with MDAC25 /27/28 are not very fine and a lot of people have a lot of problem .... where are a very high application number that need this feature for run proporty. Thanks a lot

Hey folks- After more research and implementing a simple API, I have a couple questions. The REST approach has the advantage of including the API directly in the controller action code to minimize code redundancy. I override the "to_xml" method in my models so that they produce the correct versions of XML for the API (i.e. they don''t include extra fields that have no

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

Hai Fabian , Can you kindly describe me how you achieved this. In which way did you connect to the database. Did you use the ADO method or ODBC DSN method to connect to the database. Please kindly guide me. Saravanan ----- Original Message ----- From: Fabian Cenedese <Cenedese@indel.ch> To: saravanan

Hi, Trying to compile ODBC support in asterisk for DB integration. I had this working with MySQL on the same machine, but have never used ODBC driver. Have used yum to install the following: compat-gda-odbc.i386 1.2.4-1.fc6 installed libgda-odbc.i386 1:1.9.100-10.fc6 installed mysql-connector-odbc.i386 3.51.12-2.2

Hello- I would like to know what the suggested practice is for having multiple submit buttons on a relatively complicated input page. Let''s use the example of a Contact. There is lots of info there, including name, address, phone number. There is also a list of "contact associations" which can be modified on the same page. Ideally, the user could have one

Hi I'm using asterisk 1.0.3_1 from the freebsd ports. Everything works ok, except I can's get res_config to populate sip.conf (or any other conf file for that matter). my unixodbc works and I can access the database with the isql tool. There are no warnings or anything else in the asterisk log file indicating a problem. I have used the guide from