My company distributes an application that requires Sql Server 2008 R2 Express Edition. We use the Microsoft Offline installer for Sql and make exstensive use of the command line switches to get the installation configuration that we want.
All of that works fine.
The problem is that we have noticed that when we install our application on our own machines, our application works fine but it BREAKS ODBC connections to other applications. So we will install our app and great plains will stop working or another application we use that requires a pre-defined ODBC connection stops working.
We are concerned that this is happening to our customers but we are not getting calls because our customers don't know that our installer is what broke the other application.
The fix for this is very easy. First, when you go into ODBC Administration applet from Control Panel all of the pre-configured ODBC configurations that these other programs need are gone.
To get them back all you have to do is run the Sql 2005 Native Client installer. After running that 2005 native client installer all of the ODBC configurations Auto-Magically re-appear and the other apps start working just fine.
According to Microsoft all of the Native-Clients are supposed to play together nicely. (It is supposed to allow side-by-side installs) but that is clearly not happening.
This seems likely to be a Microsoft bug but I am wondering if others have seen this and have come up with a fix for it. Thanks for your help. I have found almost nothing about this problem on the internet.