similar to: Performance problem w/ Rake on MS SQL 2000 1-GB database

Sorry for the resend but I am not sure if the first one ever made the list. As mentioned in my previous posts I''m trying to create a dynamic directory for file_folumn. After finding out that I didn''t have the most recent version I installed the latest trunk and am able to get file_column to act as it should. However I have been racking my brain on how to implement

Hello, after putting ADO.rb into Directory \ruby\lib\ruby\site_ruby\1.8\DBD\ADO\ I created a Rails-Application with MS SQL Server 2000 as Database. Everything works fine, but into the nvarchar-Field "notice" i can''t store more than about 50 or 60 characters MS SQL Server Query analyzer says, this field has a length of 510 characters. What can i do to save up to the 510

Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter

I am trying to connect to a remote sql server and I am getting the following error: c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'': Open (DBI::Databa seError) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. HRESULT error code:0x80020009 Exception

Hi, I?m working on a rails application that uses data from an existing ms sqlserver 2000 database. Unfortunately I can?t get the connection to work properly. I used http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to make the connection. - Inserted the ado.rb - Changed my database.yml to development: adapter: sqlserver database: database_name host:

So, does anyone know much about getting rails (on Linux) to talk to mssql? There is a mssql driver, but it only works in Windows. A site said that using ODBC might be an option, but I didn''t see a specific ODBC driver for rails mentioned. The nix machine runs php and it can connect to the mssql db just fine, I don''t recall if it was using ODBC or free TDS though. I hoped

I want to update a column of a database table (in MS SQL) using sqlUpdate( ) or sqlSave( ) function in "RODBC" package. E.g. SQLchannel is the database connection; SQLtable is the destination table in the database, including at least two columns, ID and Value; Xdata is a data frame in R environment, including two columns: ID and Value. What I wanna do is to update the Value in SQLtable

Hi, I am creating some graphs which I want to update into a database table. The procedure I am following is: 1. create the graphs as a png/jpeg file. 2. Read that file as a binary vector 3. sqlUpdate My code: pngfile <- file(<filename>, "rb") N <- 1e6 repeat{ pngfilecontents <- readBin(pngfile, what="raw", n=N) if(length(pngfilecontents) ==

Hi, I have a linux box set up with Samba 3.0 and have configured my shared drives. What I am trying to do is store a MS SQL data base on my Samba share. I can see the drive from my SQL machine but when I try create the database there I get errors like inconsistent file names etc. Fist can this be done and if so how? Thanx Warren

I have a project that is requiring the use of MS SQL from asterisk. I get an error when the pjsip contact tries to update the contact table. [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018: [FreeTDS][SQL Server]Conversion failed when converting the varchar value '3.000000' to data type int. (101) The datatype

I've got an Asterisk switch that is going to run an IVR menu with a database interface that will be doing lookups based on the user entered data and then reading back strings with the appropriate data integrated into the text. I have found quite a bit of data on using MySQL as a database with Asterisk, but I haven't found much about using MS SQL Server with Asterisk... We have a SQL

Because we''re now using views, I had to upgrade to mysql 5 on a project using Rails 1.0. Updated my mysql gem accordingly (which required upgrading xcode). Ruby 1.8.2, MacOS X (10.4.6) Worked fine several times (even before updating the mysql gem, then suddenly it just balked and stopped working, giving the spew below. Have also dropped (and recreated) both the test and

Hello All, I am top-posting this in hopes of increasing the visibility. This ticket has not been touched : Default Logger instance has no formatting <http://dev.rubyonrails.org/ticket/3144> For my installation, this is a BIG problem in my production logging !! For now the workaround below is working, and the double-declaration warnings of loading ''logger.rb'' twice are

Hello all, Rails 1.0.0 created_on is being set to 2000/01/01 00:00:00 Any ideas on this ? Thanks! Schema is create table user_login_history ( id int identity(1,1) not null, user_id int not null, created_on datetime default(getdate()) not null, created_at datetime default(getdate()) not null, updated_on datetime default(getdate()) not null, constraint pk_user_login_history primary key clustered

I would appreciate any tips/clues/advice very much. I have started using ruby on rails and when the MS SQL Server database is on a different box than my dev box (where the RoR app is located) I can connect fine. However when I try to connect to a MS SQL Server database on the same box as my RoR app I get an error. I have tried to use the IP address of the dev box as the value of

Hello All, My google-fu did not find this answer : How do I configure a Rails-3 Engine so that the engine''s Gemfile is integrated with the parent-Rails-app''s bundle? Thanks Peter Fitzgibbons (847) 859-9550 Email: peter.fitzgibbons-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org IM GTalk: peter.fitzgibbons IM AOL: peter.fitzgibbons-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org -- You

Hi, I'm new on this list, first of all I wanted to say "Hi" to all of you from Madrid, Spain. And now, my question is... How can I install MS SQL Server 2000 on Wine? Yes, I know, MS sucks and there are better, free, alternatives like MySQL, etc., but I really need to have a MS SQL Server client running on my computer, as several of the projects I work in are based on that specific

Hi everyone, i a new on the list: like the subject say, i want to install ms sql 200 under wine ( debian etch or kubuntu edgy), but give an error: File Not Found Source: E:\x86\setup\setup.ins Target: C:\windows\temp\SqlSetup\Bin\setup.ins so i ask you for your help, i search in google but there is not much information about this, does anybody has done this before??, thanks for your help,

Hi to all! I am running Ubuntu 8.04 with Wine 1.1.0 installed. I am trying to install MS SQL Server 2000 Client on the machine in order to connect to a Windows Server Machine running an MS SQL Server 2000. But the installation process won't proceed, it only reaches the "Setup is searching for installed components..." (w/ the green background), after that it just terminates the

I am migrating to sql server 2000 from postgres and I have tried char(1), int, tinyint and bit datatypes to replace booleans, but without luck. the 1''s and 0''s are stored properly in the db, but checkboxes and dropdowns are not being auto-populated in rails. Anyone experience this before? thanx -- View this message in context: