From: Rasmus Debitsch <Debitsch@...>
Date: 2003-03-13T05:16:04+09:00
Subject: DBI and MSAccess

I want to access a MSAccess database with Ruby. I'm new to databases and
Ruby, so my question is quite basic.

When I try to connect to the database with DBI a error message shows up. I
have no idea if there is something wrong with my code or my system
configuration. Perhaps someone can provide a working code fragment?

Environment:
Windows ME, MSAccess not installed
Ruby 173-7
A mbd file

Code:
require 'dbi'

dbq = "dbq=C:/Benutzer/Test.mdb"
dsn = "driver=Microsoft Access Driver(*.mdb);#{dbq}"

DBI.connect("DBI:ODBC:#{dsn}","","")

Error:
C:/PROGRAMME/RUBY/lib/ruby/site_ruby/1.7/DBD/ODBC/ODBC.rb:71:in `connect':
S1090 (0) [Microsoft][ODBC Driver Manager] Ung�ltige Zeichenfolgen- oder
Pufferl�nge. (DBI::DatabaseError)
 from C:/PROGRAMME/RUBY/lib/ruby/site_ruby/1.7/dbi/dbi.rb:496:in `connect'
 from C:/PROGRAMME/RUBY/lib/ruby/site_ruby/1.7/dbi/dbi.rb:322:in `connect'

-
Rasmus