Re: DBI and MSAccess

< ^ > P N |<>|^_>< --- | ~ ...Help
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.

------_extPart_001_01C2E8F1.EF7B082B
Content-Type: text/plain;
	charsetso-8859-1"
Content-Transfer-Encoding: quoted-printable

> -----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] Ungtige 

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.

------_extPart_001_01C2E8F1.EF7B082B
Content-Type: text/html;
	charsetso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>RE: DBI and MSAccess</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=2>&gt; From: Rasmus Debitsch [mailto:Debitsch / T-Online.de]</FONT>
<BR><FONT SIZE=2>&gt; Sent: Wednesday, March 12, 2003 15:16</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; When I try to connect to the database with DBI a error </FONT>
<BR><FONT SIZE=2>&gt; message shows up.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Code:</FONT>
<BR><FONT SIZE=2>&gt; require 'dbi'</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; dbq = &quot;dbq=C:/Benutzer/Test.mdb&quot;</FONT>
<BR><FONT SIZE=2>&gt; dsn = &quot;driver=Microsoft Access Driver(*.mdb);#{dbq}&quot;</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; DBI.connect(&quot;DBI:ODBC:#{dsn}&quot;,&quot;&quot;,&quot;&quot;)</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Error:</FONT>
<BR><FONT SIZE=2>&gt; C:/PROGRAMME/RUBY/lib/ruby/site_ruby/1.7/DBD/ODBC/ODBC.rb:71:i</FONT>
<BR><FONT SIZE=2>&gt; n `connect':</FONT>
<BR><FONT SIZE=2>&gt; S1090 (0) [Microsoft][ODBC Driver Manager] Ungtige </FONT>
</P>

<P><FONT SIZE=2>It looks like you can not use File DSN.&nbsp; You can set-up System DSN</FONT>
<BR><FONT SIZE=2>instead and use:</FONT>
</P>

<P><FONT SIZE=2>&nbsp;&nbsp;&nbsp; DBI.connect(&quot;DBI:ODBC:Your_System_DSN&quot;,&quot;&quot;,&quot;&quot;)</FONT>
</P>

<P><FONT SIZE=2>I've just tested and it works this way.</FONT>
</P>

<P><FONT SIZE=2>Iouri.</FONT>
</P>

</BODY>
</HTML>
------_extPart_001_01C2E8F1.EF7B082B--