# Dbi connection

**URL:** <https://www.ruby-forum.com/t/dbi-connection/141335>\
**Category:** Ruby\
**Created:** [June 24, 2008, 7:50pm UTC](https://www.ruby-forum.com/t/dbi-connection/141335 "2008-06-24T19:50:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aidy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@aidy](https://www.ruby-forum.com/u/aidy)\
**Post date:** [June 24, 2008, 7:50pm UTC](https://www.ruby-forum.com/t/dbi-connection/141335/1 "2008-06-24T19:50:33Z")

</div>

Hi,

Could anyone please tell me where I place the database name in this  
connection string

require ‘dbi’  
server\_name=‘test7’  
dbh=DBI.connect(“DBI:ADO:Provider=SQLOLEDB;Data  
Source=#{server\_name};Integrated Security=SSPI”) ?

I have tried

server\_name=‘test7:Order’

But I get an ‘invalid connection’ exception.

Thanks

Aidy

---

<div class="post-metadata">

**Author:** ![aidy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@aidy](https://www.ruby-forum.com/u/aidy)\
**Post date:** [June 24, 2008, 8:40pm UTC](https://www.ruby-forum.com/t/dbi-connection/141335/2 "2008-06-24T20:40:55Z")

</div>

Hi,

I seem to be getting a connection

`
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’)
`

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

Aidy

---

<div class="post-metadata">

**Author:** ![aidy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@aidy](https://www.ruby-forum.com/u/aidy)\
**Post date:** [June 25, 2008, 2:12pm UTC](https://www.ruby-forum.com/t/dbi-connection/141335/3 "2008-06-25T14:12:37Z")

</div>

On Jun 24, 11:50 am, Phlip [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> At a guess, if you are using Windows - and if Windows still has a Control Panel
> 
> - go to it and configure a database provider. The real name goes in there, IIRC.  
> Then link to the provider under server\_name.

Thanks Phlip … I need shooting

Aidy