Supplied provider is different from the one already in use

[kevinlcarlson]

I get this cryptic message when attempting to open an ADO connection
using VBA with Excel 2010, SS2008R2, and Win7 Enterprise 64bit.
Didn't happen with Excel 2003, SS2005, WinXPPro.

Any thoughts on why this happens and how to fix it?

Thanks!
Kevin

 

[GS]

kevinlcarlson was thinking very hard :

I get this cryptic message when attempting to open an ADO connection
using VBA with Excel 2010, SS2008R2, and Win7 Enterprise 64bit.
Didn't happen with Excel 2003, SS2005, WinXPPro.

Any thoughts on why this happens and how to fix it?

Thanks!
Kevin

Have you updated your code to use the ACE provider that Excel 2007/2010
uses? Your 2003 code would have used the JET provider, and so needs to
be revised to be version aware if you want it to work in both
environments.

If Application.Version => 12 Then
'use ACE provider connection string
Else
'use JET provider connection string
End If
</aircode>