From: Yura Kloubakov Date: 2003-03-13T08:49:03+09:00 Subject: Re: DBI and MSAccess This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2E8F1.EF7B082B Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable > -----Original Message----- > From: Rasmus Debitsch [mailto:Debitsch@T-Online.de] > Sent: Wednesday, March 12, 2003 15:16 >=20 > When I try to connect to the database with DBI a error=20 > message shows up. >=20 > Code: > require 'dbi' >=20 > dbq =3D "dbq=3DC:/Benutzer/Test.mdb" > dsn =3D "driver=3DMicrosoft Access Driver(*.mdb);#{dbq}" >=20 > DBI.connect("DBI:ODBC:#{dsn}","","") >=20 > 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=FCltige=20 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. ------_=_NextPart_001_01C2E8F1.EF7B082B Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: DBI and MSAccess

> -----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 =3D = "dbq=3DC:/Benutzer/Test.mdb"
> dsn =3D "driver=3DMicrosoft 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=FCltige

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","","&quo= t;)

I've just tested and it works this way.

Iouri.

------_=_NextPart_001_01C2E8F1.EF7B082B--