From: ChrisH <chris.hulan@...>
Date: 2007-06-05T21:10:17+09:00
Subject: Re: Using ADO to connect to an Access database in Ruby

On Jun 5, 4:29 am, Andy Robbo <arobb...@hotmail.com> wrote:
...
> ado_con.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" +
>   base_dir   = File.dirname("C:\Documents and Settings\Andy\Desktop") +
> "Alexa.mdb"
>
...
Inside double-quotes, the '\' is the escape character.
You can switch to single-quotes, or use the '/' as path separator

You use File.dirname, but this will strip off the last path element so
  File.dirname("C:\Documents and Settings\Andy\Desktop")
returns
  C:\Documents and Settings\Andy

and need to ensure a path separator is placed between 'Desktop' and
'Alexa.mdb'

I'd probably use:

base_dir = "C:/Documents and Settings/Andy/Desktop/"
ado_con.open("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=#{base_dir}Alexa.mdb")

Cheers
Chris