We have recently developed an application that uses MTS 2.0 (4
external custom DLL's) on the server with MDAC 2.6 SP2 (accessing SQL
Server 2000) which is accessed by client workstations that are running
MDAC 2.1 SP2. Our application which is written in VB 6.0 SP5 and will
not function correctly (it just doesn't create connections or return
Recordsets or do anything requiring the MDAC, it just sits there).
My Question is, does this type of environment actually work? and if so
any suggestions and how to get it working.
We don't want to upgrade to MDAC 2.6 on the client as this has the
potential to break other applications that work with MDAC 2.1 and we
require MDAC 2.6 on the server as we access SQL Server 2000 and return
xml streams to the MTS components
Any suggestions are welcome.