Unable to connect Mysql2 or Sqlite3 on windows

alcina · August 9, 2013, 12:35pm

Hi every body.
I would like to know if this problem is occurs only with me?
I was unable to get Mysql2 ou Sqlite3 working with Ruby and rails.
-ruby 2.0.0p247 (2013-06-27) [i386-mingw32]
-Rails 4.0.0.
I tried several tutorials but no one work for me.

See same examples, for sqlite3:

github.com/sparklemotion/sqlite3-ruby

Unable to install sqlite3 for Ruby2.0.0 on Windows 7

opened 10:03AM - 26 Feb 13 UTC

closed 11:52AM - 26 Feb 13 UTC

yuumi3

``` C:\Ruby200\DevKit>gem install sqlite3 Fetching: sqlite3-1.3.7.gem (100%) Tem…porarily enhancing PATH to include DevKit... Building native extensions. This could take a while... ERROR: Error installing sqlite3: ERROR: Failed to build gem native extension. C:/Ruby200/bin/ruby.exe extconf.rb checking for sqlite3.h... no sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first. *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --without-opt-dir --with-opt-include …. --without-sqlite3-lib=${sqlite3-dir}/ --enable-local --disable-local Gem files will remain installed in C:/Ruby200/lib/ruby/gems/2.0.0/gems/sqlite3-1 .3.7 for inspection. Results logged to C:/Ruby200/lib/ruby/gems/2.0.0/gems/sqlite3-1.3.7/ext/sqlite3/ gem_make.out ``` and ``` C:\Ruby200\DevKit>gem environment RubyGems Environment: - RUBYGEMS VERSION: 2.0.0 - RUBY VERSION: 2.0.0 (2013-02-24 patchlevel 0) [i386-mingw32] - INSTALLATION DIRECTORY: C:/Ruby200/lib/ruby/gems/2.0.0 - RUBY EXECUTABLE: C:/Ruby200/bin/ruby.exe - EXECUTABLE DIRECTORY: C:/Ruby200/bin - RUBYGEMS PLATFORMS: - ruby - x86-mingw32 - GEM PATHS: - C:/Ruby200/lib/ruby/gems/2.0.0 - C:/Users/yy/.gem/ruby/2.0.0 - GEM CONFIGURATION: - :update_sources => true - :verbose => true - :backtrace => false - :bulk_threshold => 1000 - REMOTE SOURCES: - http://rubygems.org/ ```

And many others.
I can install de gems but When a run the app its simple crash.

For mysql
http://blog.mmediasys.com/2011/07/07/installing-mysql-on-windows-7-x64-and-using-ruby-with-it/

Anyone has a simple way to install the database?

Tks.

alexandre · August 9, 2013, 12:40pm

Getting good support for rails in windows is difficult. Why don’t you
switch to Ubuntu or OSX?

–
Dheeraj K.

alexandre · August 9, 2013, 4:41pm

On 7 August 2013 21:09, Alexandre A. [email protected] wrote:

And many others.
I can install de gems but When a run the app its simple crash.

What do you mean by simple crash? Is there not an error message of some
sort?

I agree with Dheeraj though, much better to use a Linux distribution
such as Ubuntu. Run it in a virtual machine in Windoze or set your PC
up to dual boot Win and Ubuntu.

Colin