# Can not connect MS Access Database

**URL:** <https://www.ruby-forum.com/t/can-not-connect-ms-access-database/62024>\
**Category:** Ruby\
**Created:** [May 30, 2006, 9:07pm UTC](https://www.ruby-forum.com/t/can-not-connect-ms-access-database/62024 "2006-05-30T21:07:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JacobS\_Raymond\_A\_Jr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/898d66/32.png) [@JacobS\_Raymond\_A\_Jr](https://www.ruby-forum.com/u/JacobS_Raymond_A_Jr)\
**Post date:** [May 30, 2006, 9:07pm UTC](https://www.ruby-forum.com/t/can-not-connect-ms-access-database/62024/1 "2006-05-30T21:07:08Z")

</div>

What URI should I use?  
DBI.available\_drivers reports  
=\> [“dbi:ODBC:”, “dbi:Oracle:”,“dbi:Proxy:”]

DBI.data\_sources(“dbi:ODBC:”) reports  
=\> [“dbi:ODBC:Visio Database Samples”, “dbi:ODBC:MS Access  
Database”,…]

I can not figure how to connect to c:\temp\test.mdb?

Thank you  
raymond

---

<div class="post-metadata">

**Author:** ![JacobS\_Raymond\_A\_Jr](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/898d66/32.png) [@JacobS\_Raymond\_A\_Jr](https://www.ruby-forum.com/u/JacobS_Raymond_A_Jr)\
**Post date:** [May 30, 2006, 9:14pm UTC](https://www.ruby-forum.com/t/can-not-connect-ms-access-database/62024/2 "2006-05-30T21:14:42Z")

</div>

I have never used DBI, but I suspect that you first need to create an  
ODBC datasource using the ODBC Administrator in the Control Panel (Under  
Administrative Tools).

Jacob, Raymond A Jr wrote:

> What URI should I use?  
> DBI.available\_drivers reports  
> =\> [“dbi:ODBC:”, “dbi:Oracle:”,“dbi:Proxy:”]
> 
> DBI.data\_sources(“dbi:ODBC:”) reports  
> =\> [“dbi:ODBC:Visio Database Samples”, “dbi:ODBC:MS Access  
> Database”,…]
> 
> I can not figure how to connect to c:\temp\test.mdb?
> 
> Thank you  
> raymond