From: aidy <aidy.lewis@...>
Date: 2008-06-25T03:38:25+09:00
Subject: Re: dbi connection

Hi,

I seem to be getting a connection

<code>
require 'dbi'

server_name='test7'
db = 'Order'
dbh=DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data
Source=#{server_name};Intitial Catalog=#{db};Integrated
Security=SSPI")

if dbh
  puts "connected"
else
  puts "not connected"
end

dbh.execute('SELECT * FROM sys.Tables')

</code>

However, when I try to list all tables, I am receiving  "Invalid
object name 'sys.Tables'.

Aidy