lrlebron@gmail.com
4/6/2009 10:54:00 PM
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.