[Plugin Library] Win32API and Win32OLE so files

swajime

Thank you Dan for this. I've tried starting with http://stackoverflow.com/questions/1120225/ruby-and-accdb-ms-access but I am getting an error:
connection = WIN32OLE.new('ADODB.Connection')
Error: #<NameError: (eval):27: uninitialized constant WIN32OLE>
Can you please help me to get started with opening a simple database myDatabase.accdb ?

swajime

I have this directly in the SketchUp ruby console:

require 'win32ole'
true
if defined?(WIN32OLE); connection = WIN32OLE.new('ADODB.Connection'); end
Error; #<WIN32OLERuntimeError; (eval);27;in `initialize'; unknown OLE server; `ADODB.Connection'
    HRESULT error code;0x800401f3
      >

The link you put up did not come through.

Dan Rathbun

@swajime said:

The link you put up did not come through.

The original links in the 2nd post still work.
(It's just that the editor has decided to encode pasted URLs, suddenly.)

Dan Rathbun

I suggest starting a new (if there is not one,) topic in the Developers Forum.

swajime

Thank you. I did as you said and started a new topic http://sketchucation.com/forums/viewtopic.php?f=180%26amp;t=55202%26amp;e=0.

Dan Rathbun

@swajime said:

Error: #<NameError: (eval):27: uninitialized constant WIN32OLE>

Did you first have the load statement:

require("win32ole")

or require("win32ole.so")

Then you can test if the class was defined, via:

if defined?(WIN32OLE)

  connection = WIN32OLE.new('ADODB.Connection')

 # more code ...

end

There is a chapter on WIN32OLE in:
[doc] Programming Ruby (The "Pick-Axe" Book)

Dan Rathbun

Did you see the link ?

@dan rathbun said:

Since someone is bound to ask, here are the online reference rdocs for these 2 libraries:

Win32API rdoc

WIN32OLE rdoc

Dan Rathbun

@dan rathbun said:

There is a chapter on WIN32OLE in:
[doc] Programming Ruby (The "Pick-Axe" Book)

Sysops have fixed the editor URL links (above.)

glro

@dan rathbun said:

@glro said:

seems not to be compatible with sketchup 2013

(1) where is the so file on your machine ?

(2) please post the error message

1: in the plugins folder of sketchup

2: win32API.so error message

glro

@dan rathbun said:

@glro said:

seems not to be compatible with sketchup 2013

(1) where is the so file on your machine ?

(2) please post the error message

sorry

problem solved

you were right: win32API.so and sketchup 2013 are compatible

thank you

Dan Rathbun

@glro said:

sorry ... problem solved

you were right: win32API.so and sketchup 2013 are compatible

Yes I have no problem loading it.

What was your issue ?

glro

@dan rathbun said:

@glro said:

sorry ... problem solved

you were right: win32API.so and sketchup 2013 are compatible

Yes I have no problem loading it.

What was your issue ?

still don't know

changed something (don't know what) and the problem disappeared

thank you for your comments

Dan Rathbun

FYI

SketchUp 2014

Ruby v 2.0.0 - patchlevel 247
win32ole.so file is included
Win32API.rb file is included, which is a wrapper into the newer DL library, but allows the older WIn32API style calls.
%(#BF4000)[Do not copy these files from older Ruby versions into SketchUp's "Plugins" folder,
(or any of SketchUp's folders,) for versions 14 or higher !]