Provider cannot be found

[#1]

When testing a 32bit VB6 app against SQLA 12.1 on a Win7 64 bit PC, it works fine. Both client and database are on the Win7 64 bit.

Now testing on a clean install of MS Server 2008 R2 SP1 64bit. The database works fine but the 32bit app gives "Provider cannot be found".

Search on this forum gives "SA11 + EF4 + VS2010 RC = Error" which seems similar but I've never come across machine.config before and there are loads of them on the server. Some reference ASA 12 though.

We cannot install the dev. s/w to debug so I'm lost :[

[jack_schueler]

Watch your VB6 application for memory leaks on Windows 7/Vista/Server 2008 and newer systems. VB6 is not supported by Microsoft and we have had two customers reporting memory leaks. A process heap dump revealed that VB6 ADO was leaking connection strings on Windows 7 (and related OS).

Recommendation: Move to .NET as soon as possible.