ADODB connection from inside EXCEL -- sql server odbc

Ken Jones
1/9/2004 9:03:31 AM

I posted before, but it did not appear. Anyhow, I found
the answer -- sort of.

The problem is that I have two "identical" machines
running identical EXCEL spread sheet. One can do an
ADODB connection and the other can not. I could not
figure out what was different until I installed SQL Server
Client Services on the machine whose EXCEL did not work.

Now it works. Conclusion: Something has been added to
the register which is needed to support ADODB inside
EXCEL.

The question now is: How do I implement the change
without installing SQL Server? What is the minimum
installation that will enable EXCEL to do ADODB
connections?

Ken Jones

Is the missing package the ActiveX set? What is

Michael Otey
1/13/2004 10:44:15 AM

The machines probably have a different MDAC level. I would check them using
the Component Checker which you can download at:

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

If you find they're different install the latest MDAC version on the older
system.

Mike O.

[quoted text, click to view]

sql server odbc : ADODB connection from inside EXCEL