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

That worked ... thanks a million Joao !!!

--- Joao Pedrosa <joaopedrosa@yahoo.com> wrote:
> 
> Hi,
> 
> The first time I tested it on IRB, but I recoded it
> to
> a minimum. Like this:
> 
> require 'odbc'
> include ODBC
> 
> drv = Driver.new
> drv.name = 'Driver1'
> drv.attrs['driver'] = 'Microsoft Access Driver
> (*.mdb)'
> drv.attrs['dbq'] = 'c:/dbdemos'
> dbh = Database.new.drvconnect(drv)
> p dbh.tables.fetch_all
> 
> --- output:
> C:\>ruby dsn.rb
> [["c:/dbdemos", nil, "MSysAccessObjects", "SYSTEM
> TABLE", nil], ["c:/dbdemos", n
> il, "MSysACEs", "SYSTEM TABLE", nil], ["c:/dbdemos",
> nil, "MSysObjects", "SYSTEM
>  TABLE", nil], ["c:/dbdemos", nil, "MSysQueries",
> "SYSTEM TABLE", nil], ["c:/dbd
> emos", nil, "MSysRelationships", "SYSTEM TABLE",
> nil],
> ["c:/dbdemos", nil, "coun
> try", "TABLE", nil], ["c:/dbdemos", nil, "customer",
> "TABLE", nil], ["c:/dbdemos
> ", nil, "employee", "TABLE", nil], ["c:/dbdemos",
> nil,
> "items", "TABLE", nil], [
> "c:/dbdemos", nil, "nextcust", "TABLE", nil],
> ["c:/dbdemos", nil, "nextitem", "T
> ABLE", nil], ["c:/dbdemos", nil, "nextord", "TABLE",
> nil], ["c:/dbdemos", nil, "
> orders", "TABLE", nil], ["c:/dbdemos", nil, "parts",
> "TABLE", nil], ["c:/dbdemos
> ", nil, "vendors", "TABLE", nil]]
> 
> 
> Cheers,
> Joao
> 
> 
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Domains � Claim yours for only $14.70/year
> http://smallbusiness.promotions.yahoo.com/offer 



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