From: Shashank Date <shanko_date@...>
Date: 2004-05-20T09:06:33+09:00
Subject: Re: ODBC connection string for MS-Access

Hi Joao,

--- Joao Pedrosa <joaopedrosa@yahoo.com> wrote:
> Check this out:
>
http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/67352
> 
> I've tested it successfully.

I tried method 2 (DSN less) described in that post as
follows:
#-------------------
require 'dbi'
# using the DSN-less connection

db=DBI.connect('DBI:ODBC:driver=Microsoft Access
Driver (*.mdb);dbq=C:/mrmat4.mdb')
#-------------------

And I got the following error:
C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:78:in
`connect': S1090 (0) [Microsoft][ODBC Driver Manager]
Invalid string or buffer length (DBI::DatabaseError)
	from C:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:550:in
`connect'
	from C:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:367:in
`connect'
	from C:/atest/tst_odbc2.rb:4

The code for Method 1 had few typos and after
correcting those I still could not get it to work.
Would it possible for you to share your working
script?

Thanks for your time and attention.
-- shanko






	
		
__________________________________
Do you Yahoo!?
Yahoo! Domains � Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer