I have a 32-bit DA service running on an older Windows server. I was asked to move it to a newer server which I did this morning. it started up OK, but when I tried to use the service via a client app, I get a very strange exception:
What is the exact OS version was used on the old server and is used on the new one? (You can answer via support@ if you don’t want to disclose this info here).
This MDAC 2.12 version matches a SQL Server 7 . (1999). Is this machine running on NT4?
Not really sure if the ODBC driver is found. The version returned is a ‘close to’. Sounds like close to not found.
MDAC does no longer work on 2008 and later machines. It’s called WDAC there and I can just be repaired but not via Program/Feature - System Components iirc. Or simpler the ODBC driver is simply not installed.
It think the error message says that the ODBC driver cannot be found. I somehow remember having read about this message years ago. I just mentioned this because people maybe try to install MDAC 2.8 and later. This lead them deeper into troubles.
The problem is not Data Abstract. The problem is that we’re using an outdated version of our database server and that needs to be upgraded to the current version. I’m accessing the data via the ADO.NET -> ODBC.NET -> database approach and since this old database version has an equally old ODBC driver, it is not compatible with the current version of ADO.NET. This is the company’s fault and something we need to address very soon.