tag:blogger.com,1999:blog-284600789737488130.post4063553665855177187..comments2024-02-07T02:22:20.642-05:00Comments on Ruby on Windows: JRuby 1.6: Now With Win32OLE GoodnessDavid Mullethttp://www.blogger.com/profile/05597492688893461137noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-284600789737488130.post-44283770593317650582013-07-29T18:15:12.630-05:002013-07-29T18:15:12.630-05:00I get the same error as 'Eric G' any thoug...I get the same error as 'Eric G' any thoughts? <br /><br />JRuby 1.7.3, Windows 7 works fine under MRI 2.0.0<br /><br />using "Provider='Microsoft.ACE.OLEDB.12.0';Data Source='db/development.accdb'"<br /><br />as the connection string<br /><br />thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-38269278902980394752012-03-08T21:59:39.071-05:002012-03-08T21:59:39.071-05:00@Eric:
This works for me, running JRuby 1.6.7 on ...@Eric:<br /><br />This works for me, running JRuby 1.6.7 on a Windows 7 machine...<br /><br />conn = WIN32OLE.new('ADODB.Connection')<br />conn.Open('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MY_DATABASE.mdb')<br /><br />rs = WIN32OLE.new('ADODB.Recordset')<br />rs.Open("SELECT * FROM MY_TABLE;", conn)<br />...<br />rs.Close()<br />conn.Close()<br /><br />Feel free to send me your sample code via email.<br /><br />DavidDavid Mullethttps://www.blogger.com/profile/05597492688893461137noreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-45131356698639972982012-03-06T21:17:28.602-05:002012-03-06T21:17:28.602-05:00Have you tried using jruby's win32ole library ...Have you tried using jruby's win32ole library to make ADODB connections to Access databases?<br /><br />When I try, I get <br /><br />Java::OrgRacobCom::ComFailException: Invoke of: Open<br />Source: ADODB.Connection<br />Description: Provider cannot be found. It may not be properly installed.<br /><br />(Initially I was trying from within Sequel's ADO adapter, but I get the same error making a naked win32ole call.)<br /><br />On MRI ruby, I don't get any error connecting to the same Access database.<br /><br />Thanks for any suggestions - and thanks for you blog!<br /><br />EricEric Ghttps://www.blogger.com/profile/10916195342286633500noreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-13850915239249257752011-11-11T01:22:57.474-05:002011-11-11T01:22:57.474-05:00Thanks for the post. Do you have any info on the p...Thanks for the post. Do you have any info on the possibility to use monkeybars (to take advantage of the matisse gui builder) but without having to refactor your code to the MVC pattern that monkeybars wants the user to stick to?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-5777696946374414982011-08-17T13:26:12.502-05:002011-08-17T13:26:12.502-05:00I recently came across your blog and have been rea...I recently came across your blog and have been reading along. I thought I would leave my first comment.<br />I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.<br />Thank You<br /><a href="http://roneebin.livejournal.com/522.html" rel="nofollow">Ruby on Rails</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-1730366338889216482011-05-13T19:13:15.206-05:002011-05-13T19:13:15.206-05:00@Anonymous:
It seems that you are correct: The 1....@Anonymous:<br /><br />It seems that you are correct: The 1.6.1 installer does not include the win32ole library. Not sure why---I didn't see it mentioned in the release notes.<br /><br />I had to run the command 'gem install jruby-win32ole'. I believe this installs the enebo version.David Mullethttps://www.blogger.com/profile/05597492688893461137noreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-7943169118830593062011-05-11T04:23:53.841-05:002011-05-11T04:23:53.841-05:00I tried JRuby 1.6.1, but it seems that the jruby-w...I tried JRuby 1.6.1, but it seems that the jruby-win32ole does not come with the Windows installer -- I still need to install the gem manually. Did I take it wrongly?<br /><br />I also found there are more than one implementation of jruby-win32ole. So when I run 'gem install jruby-win32ole', which implementation does it install?<br /><br />Below are 2 implementations I have found:<br />https://github.com/enebo/jruby-win32ole<br />https://github.com/bpmcd/win32oleAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-8286152283714131832011-03-19T14:37:19.248-05:002011-03-19T14:37:19.248-05:00Any Progress on the book Dave? Haven't heard a...Any Progress on the book Dave? Haven't heard anything for a while.Paulnoreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-51734803885153741592011-03-17T07:07:57.678-05:002011-03-17T07:07:57.678-05:00Thanks, James!
I have updated the links for both ...Thanks, James!<br /><br />I have updated the links for both Monkeybars and Rawr.<br /><br />FYI, The page at rawr.rubyforge.org links to monkeybars.rubyforge.org.<br /><br />DavidDavid Mullethttps://www.blogger.com/profile/05597492688893461137noreply@blogger.comtag:blogger.com,1999:blog-284600789737488130.post-52866638595826609142011-03-17T03:49:00.982-05:002011-03-17T03:49:00.982-05:00This is very cool news, and being able to write Mo...This is very cool news, and being able to write Monkeybars apps that hook into Windows apps and opens a lot of interesting doors.<br /><br />There's a small error in your post, though. The correct URL for the Monkeybars home page is http://www.monkeybars.org. <br /><br />I don't know why there's anything on rubyforge.org; I thought that was supposed to be shut down a while ago.James Britthttps://www.blogger.com/profile/14121816809671217162noreply@blogger.com