Forum: Ruby Ruby ODBC error

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
C5b0a0cf40eb23497068889c8fb20a18?d=identicon&s=25 lrlebron@gmail.com (Guest)
on 2009-04-07 00:57
(Received via mailing list)
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 topic is locked and can not be replied to.