DBI and MSAccess

ruby-talk
1

It looks like you can not use File DSN. You can set-up System DSN
instead and use:

DBI.connect("DBI:ODBC:Your_System_DSN","","")

I’ve just tested and it works this way.

Iouri.

···

-----Original Message-----
From: Rasmus Debitsch [mailto:Debitsch@T-Online.de]
Sent: Wednesday, March 12, 2003 15:16

When I try to connect to the database with DBI a error
message shows up.

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:i
n `connect’:
S1090 (0) [Microsoft][ODBC Driver Manager] Ungültige