[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Problem with ruby + mysql on windows

Bruno Moura

5/23/2008 4:52:00 PM

Hello

I'm having a problem to conect and use ruby to performe some operations
with a mysql database. I downloaded the gem mysql 2.7.3 (win32) and
added the windows path with mysql bin and mysql lib entries.When a try
to execute the script below an error occurs, with a message:

Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?

in the code:

require 'rubygems'
require 'mysql'

m = Mysql.new("localhost","user","pass","database")
r = m.query("SELECT * FROM table")
r.each_hash do |f|
print "#{f['camp1']} - #{f['camp2']}"
end


Could you help me, please?

Thank's

Berable
--
Posted via http://www.ruby-....
6 Answers

Roger Pack

5/23/2008 8:37:00 PM

0


> Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?
googling for that error message yielded
http://brianbruijn.wordpress.com/2008/05/12/mysql_stmt_row_tell-and-libmysqldll-error-for-inst...
does that help?
--
Posted via http://www.ruby-....

Bruno Moura

5/26/2008 1:16:00 PM

0

another error happened:

>ruby mysql2.rb
C:/InstantRails-1.6/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-mswin32/ext/mysql.so:
998: Acesso inválido ao local de memória. (Invalid Access of memory
location) -
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 mysql2.rb:2
>Exit code: 1

The code are the same.

Thank's for your interest Roger!

Roger Pack wrote:
>
>> Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?
> googling for that error message yielded
> http://brianbruijn.wordpress.com/2008/05/12/mysql_stmt_row_tell-and-libmysqldll-error-for-inst...
> does that help?

--
Posted via http://www.ruby-....

Roger Pack

5/26/2008 1:20:00 PM

0

maybe try a different version of the mysql dll?

>>> Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?

--
Posted via http://www.ruby-....

Bruno Moura

5/26/2008 1:24:00 PM

0

Humm,complicated...

how can I know the right version of library I shoud use?

Roger Pack wrote:
> maybe try a different version of the mysql dll?
>
>>>> Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?

Thank's again!

--
Posted via http://www.ruby-....

Roger Pack

5/26/2008 1:39:00 PM

0

Bruno Moura wrote:
> Humm,complicated...
>
> how can I know the right version of library I shoud use?
>
> Roger Pack wrote:
>> maybe try a different version of the mysql dll?
>>
>>>>> Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?
>
> Thank's again!

For me with your gem, I have
"c:\program files\mysql...\bin" in my path, and
version 14.12 Distrib 5.0.45 [from running mysql --version]
installed and the code that you posted works. That's with XP so maybe
that's a factor.
-R
--
Posted via http://www.ruby-....

Bruno Moura

5/26/2008 2:00:00 PM

0

My code runs in your machine... puts!

mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)

humm my number version is bit different...

I'll try to install another version of instant rails or install the
complet
stack at begining (ruby, mysql, rails, not istant rails).

Thank's so much Roger!

Roger Pack wrote:
> Bruno Moura wrote:
>> Humm,complicated...
>>
>> how can I know the right version of library I shoud use?
>>
>> Roger Pack wrote:
>>> maybe try a different version of the mysql dll?
>>>
>>>>>> Error in the entry of procedure mysql_stmt_row_tell in lib LIBMYSQL.dll?
>>
>> Thank's again!
>
> For me with your gem, I have
> "c:\program files\mysql...\bin" in my path, and
> version 14.12 Distrib 5.0.45 [from running mysql --version]
> installed and the code that you posted works. That's with XP so maybe
> that's a factor.
> -R

--
Posted via http://www.ruby-....