Ruby ODBC error

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.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs