Ruby ODBC error

L

lrlebron

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,900
Latest member
Nell636132

Latest Threads

Top