Mysql & Ruby in windows, it's possible ?!

#Program:

require ‘mysql’

m = Mysql.new(“localhost”,“root”,“your_password”,“library”)
r = m.query(“SELECT * FROM autor ORDER BY nome”)
r.each_hash do |f|
print “#{f[‘nome’]} - #{f[‘sobrenome’]}”
end

#error

C:/InstantRails-1.6/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-mswin32/ext/mysql.so:
998: Invalid access to local memory.

C:/InstantRails-1.6/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-mswin32/ext/mysql.so
(LoadError)
from
C:/InstantRails-1.6/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:32:in
`require’
from mssqltest.rb:1

Output completed (1 sec consumed) - Normal Termination

I’ve had installed both mysql gems (windown e Ruby version 2.7)

Could you help-me? Please and thanks!

Could you help-me? Please and thanks!
try the OCI + mysql gem + latest mysql binary. [?]

Roger P. wrote:

Could you help-me? Please and thanks!
try the OCI + mysql gem + latest mysql binary. [?]

What’s OCI?

I have mysql gem installed and mysql binary is new.

Bruno M. wrote:

Roger P. wrote:

Could you help-me? Please and thanks!
try the OCI + mysql gem + latest mysql binary. [?]

What’s OCI?

I have mysql gem installed and mysql binary is new.

one click installer

On Jun 6, 5:55 am, Bruno M. [email protected] wrote:

Roger P. wrote:

Could you help-me? Please and thanks!
try the OCI + mysql gem + latest mysql binary. [?]

What’s OCI?

I have mysql gem installed and mysql binary is new.

What version of MySQL? what error are you getting? can you provide
code to reproduce it?

You don’t give us enough tools to actually help you, no matter how
hard we try, I never got my diploma on telepathy.

FYi, if you’re using MySQL 5.1 windows Mysql gem will not work, there
are some changes in the underlying mysql library that break
compatibility between 5.0 and 5.1.

HTH,

Luis L. wrote:

On Jun 6, 5:55�am, Bruno M. [email protected] wrote:

Roger P. wrote:

Could you help-me? Please and thanks!
try the OCI + mysql gem + latest mysql binary. �[?]

What’s OCI?

I have mysql gem installed and mysql binary is new.

What version of MySQL? what error are you getting? can you provide
code to reproduce it?

You don’t give us enough tools to actually help you, no matter how
hard we try, I never got my diploma on telepathy.

FYi, if you’re using MySQL 5.1 windows Mysql gem will not work, there
are some changes in the underlying mysql library that break
compatibility between 5.0 and 5.1.

HTH,

The version is 5.0.27 , but with rails works fine…

It´s possible