similar to: ADODB and SQLServer

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

Hello, Using Edge_Rails and SQL Server I get an error in my schema.rb file after issuing "rake migrate". database.yml --------------------------------- development: adapter: sqlserver database: triage_development username: user password: pass host: server schema.rb --------------------------------- # Could not dump table "categories" because of following

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:

I'm trying to write VB6 code to get data from a PostgreSQL server running on Fedora 7 Linux. Running the code in Win XP there is no problem, but when I try running under Wine on the linux server itself I get no rows returned from my database even though the logs show I'm connected and PostgreSQL has located the data I requested. I'm using an ADODB connection with a DSN. However the

I am trying to upload word docs to an image column. I followed the cookbook for how to upload files and it works on a MySQL db (upload and download) on SQLServer however I get the following error DBI::DatabaseError: Execute OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server Operand type clash: text is incompatible with image HRESULT error code:0x80020009 Also I when

"bitsweat" has given AR/SQLServer some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/6912 ------------------------------------------------------------------------ r6912 | bitsweat | 2007-05-31 10:15:56 -0700 (Thu, 31 May 2007) | 1 line Fix an edge case with find with a list of ids, limit, and offset. Closes #8437.

Hey Folks, My app compares the last known set of files located on a series of servers against a current snapshot for auditing purposes. Its working really well, and I''ll open source it when its complete! Here''s my current issue (and forgive me, I started life as a DBA and I constantly want to revert to connection.execute.) The tables to store my objects are

Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

hi, i want to install a program under wine that's written in vb and uses ado which itself needs dcom. dcom cannot be installed because rundll32.exe is missing (i try to do this without installing windows). as far as i understood until now i must write the dlls to a config file, but i do not know how and which. has someone already installed ado, dcom and vb runtime and if how it is done?

Hey Folks, I''ve written a script to generate a list of all files on a machine, then zip the results. ?I''m going to stick a web front end on it, and use it to audit some file servers. The problem is that the ZIP compression/decompression isn''t working, but its not what you might think. ?The script completes, but seems to not actually write anything. Here is a short

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

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

How do you clean up your app folder to place onto the server? I want to get rid of all the .svn stuff. Seth Buntin -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060317/cc81d9f7/attachment.html

Ok, So I followed the directions.. I did a ''gem install markaby'' (which sounds like its enough to get me going for rails), but I wasn''t sure, so I tried to install the plugin as well. Plugin installation fails looking for a file: Script/plugin install http://code.whytheluckystiff.net/svn/markaby/trunk Outputs this error: + ./trunk/svnindex.xsl

i installed cacti following the INSTALL file but if i try to view cacti url it shows this error: Warning: mb_ereg_replace(): mbregex compile err: premature end of regular expression in /var/www/html/cacti/include/config.php on line 43 Warning: mb_ereg_replace(): mbregex compile err: premature end of regular expression in /var/www/html/cacti/include/config.php on line 44 Warning: Cannot modify

I trying to install .net 3.0 over winetricks. 2.0 installs just fine, then when 3.0 starts everything is fine until after i hit the install button. The terminal gives me this: fixme:advapi:LookupAccountNameW (null) L"corey" (nil) 0x33c924 (nil) 0x33c928 0x33c91c - stub fixme:advapi:LookupAccountNameW (null) L"corey" 0xd05bf8 0x33c924 0xd06428 0x33c928 0x33c91c - stub

Hello folks, I''m trying to do something like: 1. db = ActiveRecord::Base.establish_connection(:adapter => "mysql", :database => "app_development", :username => "root") 2. Cmd = File.read(''commands.sql'') <--- Command.sql contains multiple valid SQL statement. I''ve tested this directly by piping it into MySQL from the

Hi there, I''m running ROR 2.x on Win32 tried to run gem install activerecord-sqlserver-adapter --source http://gems.rubyonrails.org and get this: D:\>gem install activerecord-sqlserver-adapter -source http://gems.rubyonrails.org Bulk updating Gem source index for: http://gems.rubyonrails.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find

im getting: Fatal error: Unknown function: mssql_get_last_message() in /var/www/html/tikiwiki-1.8.2/lib/adodb/drivers/adodb-mssql.inc.php on line 415 to the wiki.. Jason

Buenas, Alguno usa alguno de los paquetes de Microsoft R para la conexion a SQL Server? De ser asi, que paquete y que comandos usais? Yo hasta ahora he usado odbc, de Rstudio, pero me da siempre problemas con el tipo de datos que tiene SQLServer ... Un saludo Jes?s [[alternative HTML version deleted]]