We have had code in a number of our apps for a few years that presents end-users with list of Servers to assist them in establishing a connection. I have included this code at the end of this initial post - as you can see, its very simple...
However, users who have upgraded from SQL 2005 to SQL 2008 found that this formerly trusty code now produces an error. I contacted Microsoft and was told "Oh, you need your users to load the SQL 2005 Compatibility Pack" - so I downloaded that and alerted
those users to the link I was given.
We loaded that pack on our test machines - IT DOESNT WORK. 6 of our customers loaded it too - IT DOESNT WORK. All machines who downloaded and installed this "Compatibility Pack" have found its useless - it doesnt do what Microsoft's own support
tech told us it would, and now, trying to support a mix of both SQL 2005 and SQL 2008 users, we are kind of dead in the water.
Can anyone give me an answer that actually works? Why does the following code work fine in SQL 2005, and not at all in SQL 2008 - and what do I do to fix this problem? Here is the VB.NET code...
View Complete Post