# Ruby ODBC error

**URL:** <https://www.ruby-forum.com/t/ruby-odbc-error/164883>\
**Category:** Ruby\
**Created:** [April 7, 2009, 12:57am UTC](https://www.ruby-forum.com/t/ruby-odbc-error/164883 "2009-04-07T00:57:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [April 7, 2009, 12:57am UTC](https://www.ruby-forum.com/t/ruby-odbc-error/164883/1 "2009-04-07T00:57:08Z")

</div>

I am getting the following error when trying to connect to sql server  
via odbc from a customer’s computer

OLE error code:800A0E7A in ADODB.Connection  
Provider cannot be found. It may not be properly installed.  
HRESULT error code:0x80020009  
Exception occurred.

Here’s a piece of the script

require ‘odbc’  
require ‘win32ole’

db = WIN32OLE.new(“ADODB.Connection”)  
db.open(“Provider=SQLNCLI;Data Source=#{@server\_name};Database=#  
{@database};UID=#{@username};Pwd=#{@password};”)

The script works from my computer. I have installed MDAC on the  
customer’s computer,

Any help would be greatly appreciated.