I have encountered a problem using MDAC2.1 (sp2) to connect clients to
SQL Server 6.5 SP5a (running NT4 SP5) via ODBC.
Both client and server have MDAC 2.1 installed. The SQL Server only has
the Multi-Protocol net library installed and the clients are using the
multi-protocol library dbmsrpcn.dll that comes with MDAC 2.1.
Both server and client have the encrytion option set which is only
available with the multi-protocol library.
When trying to establish connection get [Microsoft][ODBC SQL Server
Driver][Multi Protocol][ConnectionOpen (RPCopen()) Connection failed.
SQL Server Error 11
What is more confusing is that this set up worked fine with MDAC2.0. The
problem has only arisen with upgrading clients to MDAC 2.1.
Any help would be greatly appreciated !!