I have a Client/Server setup where the SQL Server Express 2008 R2 is installed on the server. I'm using code on my client machine that requires the SMO. My question is how to install that. I'm familiar with the link below:
But this requires me to install:
Microsoft SQL Server 2008 R2 Shared Management Objects, Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types.
The problem is my application is supported on Win XP 32bit, Win 7 32bit and 64bit. For instance the Native Client 32bit can't be installed on a 64bit machine, so my Installer needs to install this part in a 64bit version. Basically two of the four mentioned
components needs to be installed as 64bit on a 64bit OS and the other two in 32bit. My original application is a 32bit application.
Is there any msi or exe file i can use that has been tested on different OS so i dont need to worry about the above or is there an easy way to install the SMO?
View Complete Post