Supplied provider is different from the one already in use
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 |
Supplied provider is different from the one already in use
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 -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
All times are GMT +1. The time now is 06:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com