Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-09-13
2
Medium Priority
?
801 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

704 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