asked
Windows 7 client, SQL Server 2008 server compatibility issues?
any known compatibility issues with having a windows 7 client connecting to sql server 2000 database running on windows 2000 server? Our client uses a VB6 developed application that utilizes sql server 2000 as its backend database. Up until now each new PC that they get has Windows XP Pro on it, but now they are coming with Windows 7 and we are worried about compatibilty issues.
the windows PC (version whatever) will connect to the database through the software that in turn uses drivers that are created to access that data source, the OS wont matter at all. I would not anticipate any issues so long as the VB6 application works on the OS. This would be where I would see the bigger concern, VB6 is pretty old, not sure what libraries have changed that Win7 may throw up issues. The installer for the app should include the drivers it needs to get to the data.
@Fatherjack Yep, getting VB 6 app to run in Windows 7 is a **much bigger concern** indeed. While the executive summary [in this article][1] begins with the statement that VB team is committed to "It just works" compatibility, the same article lists quite a number of unsupported runtime files. Practically, I know for sure that if the app uses any popular in the past third party controls then the app is not doing very well in Windows 7. As a matter of fact, I sometimes have to work with a good ol' VB 6 app, and the latter IS a showstopper for upgrading the user desktops to Windows 7 :( [1]:
http://msdn.microsoft.com/en-us/vbasic/ms788708.aspx
