Solved

.NET 2 Winforms app with ODBC connection to Sybase ASA 9 doesn't work with Win 7

Posted on 2011-09-13
2
783 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:BobSacks
2 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 36533680
According to the online documentation, the 2.0 version of the ODBCConnection object is not supported on Windows 7.

Give a look at the list of supported platforms at the bottom of the page. Windows 7 appears as a supported platform only from framework 3.5.

Sorry to be the bringer of bad news.
0
 

Author Comment

by:BobSacks
ID: 36535492
James -

Thanks for the info.   Not such bad news.  At least I understand the problem now.   I got it to work on Win 7 32 (that turned out to be just a misnamed DSN), so I have an alternative for the client.   If they want to engage me to update the old app to 64 bit, then that's their call.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

One of the features I've come to appreciate about Windows 7 and Windows Server 2008 R2 is the ability to pin applications to the task bar. As useful a feature as I've found this, it does have some quirks.  For example, have you ever tried pinning an…
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now