@box said:

Can you get to work with an excel file, because you can always link an access to an excel.

On a Windows Vista machine that I have access to, ADODB.Connection appears to be working, but attempting to work with Excel.Application is not working:

C;\Users\john>type xls.rb                                              
require 'win32ole'
excel = WIN32OLE;;new('Excel.Application')
# access = WIN32OLE;;new('ADODB.Connection')
puts "Hello, World"

C;\Users\john>ruby xls.rb
xls.rb;2;in `initialize'; unknown OLE server; `Excel.Application' (WIN32OLERunti
meError)
    HRESULT error code;0x800401f3
      Invalid class string
        from xls.rb;2;in `new'
        from xls.rb;2;in `<main>'

Neither work on the linux box.

Hmmm ... I'm hoping that that isn't the case.
WIN32OLE has methods ... I would think that if the methods exist that they would work?

WIN32OLE.methods
["const_load", "const_missing", "new", "methods", "allocate", "protected_instance_methods", "include?", "taint", "class_eval", "instance_variable_defined?", "name", "ole_free", "class_variables", "__id__", "singleton_methods", "private_instance_methods", "respond_to?", "nil?", "ancestors", "ole_reference_count", "__send__", "protected_methods", "tainted?", "untaint", "instance_of?", "equal?", "method", "method_defined?", "ole_show_help", "class_variable_defined?", "private_methods", "hash", "constants", "send", "autoload", "kind_of?", "freeze", "eql?", "public_method_defined?", "object_id", "codepage", "id", "codepage=", "public_methods", "connect", "instance_eval", "const_get", "is_a?", "private_method_defined?", "type", "superclass", "instance_variables", "autoload?", "frozen?", "const_set", "to_a", "protected_method_defined?", "instance_method", "class", "public_class_method", "<=>", "instance_variable_get", "==", "===", "to_s", "extend", "instance_methods", ">=", "<=", "clone", "private_class_method", "const_defined?", "included_modules", "instance_variable_set", "=~", "<", ">", "inspect", "public_instance_methods", "display", "dup", "module_eval"]

I should also mention that I'm not usning Windows. I'm using Sketchup 2013 in wine-1.6 on Ubuntu 12.04.3. I installed WIN32API.so and WIN32OLE.so as directed in this thread -> http://sketchucation.com/forums/viewtopic.php?f=323%26amp;t=42732%26amp;p=500870.

Thanks for the quick reply and the homework assignment.
I switched ADOBD to ADODB like you said (silly me) ... but I still have the same error. I don't get far enough to call any WIN32OLE functions.

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

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.

I'm trying to connect to an Access database file, but I'm getting an error "unknown OLE server" error.

From SketchUp's ruby console:

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

I must be missing something. How do I open an Access database file?

Thanks,

John

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.

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 ?