.NET 2 Winforms app with ODBC connection to Sybase ASA 9 doesn't work with Win 7
Posted on 2011-09-13
I have an old Winforms app (VB.NET 2003, .NET Framework 2.0) that talks to Sybase Adaptive Server Anywhere 9 via ODBC. Has been working just fine for years with Win XP. Client tried to install it on a new Win 7 machine and it won't connect. We've tried both 32 and 64 bit Win 7. We've tested the ODBC DSN using ACCESS linked tables and it's just fine, so the problem is my app.
It fails trying to connected to Sybase. Unfortunately I cannot easily recomplie the app or test it in a development environment since it used some 3rd party stuff that I no longer have - and I don't have Visual Studio 2003 running anywhere. So I'm wondering if there is something version dependent about the .NET 2.0 ODBC provider? All the workstations (XP) on which the app still works do show .NET Framework 2 installed alongside newer versions.
I tried installing .NET 2 on the Win 7 32 bit machine and it refuses to install - saying that it is already there as part of the OS.
I'm stumped. Can anyone help?