VBA Error - Driver does not support this function

[myalo]

I have an Excel macro that connects to a Foxpro table. It was working for long time. Recently when running the same Excel file on Windows 7 machine it fails with Excel VBA error Driver does not support this function (-2147467259) It is still working fine from XP computer using Excel 2003 or 2007
Setup on windows 7 64 bit OS
Outlook 2007 VBA macro: VBA Project References Microsoft ActiveX Data objects 2.7 Library (I tried 2.8 and 2.6 and the same results) The connection string: "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\serverpath\;Exclusive=No;"
It fails on connection object.open Any idea?
Thanks in advance Moshe

 

[Andrew Poulsom]

Welcome to MrExcel.

That's not really an Excel question, but I found this by Googling:

In Visual FoxPro, Using 32-bit ODBC Drivers on 64-bit Windows | SaltyBlog

Hope it helps.

 

[Andrew Poulsom]

Oh and I just found your cross-post:

odbc - Excel VBA error Driver does not support this function (-2147467259) - Stack Overflow

If you cross-post please say so and provide a link.

 

[myalo]

Oh and I just found your cross-post:

odbc - Excel VBA error Driver does not support this function (-2147467259) - Stack Overflow

If you cross-post please say so and provide a link.

I sure will. At least here I got a very quick and good answer
Thanks