SQL Native Client OLE DB Provider

[MarkElder]

Hello,

I need to start using the new SQL Native Client OLE DB provider for my application. Since I don't see that listed as a possible runtime I'm assuming I will need to merge the msi module myself.

Just double checking to see if this is the right approach or if anyone knows of anything I need to watch out for.

In case anyone else needs this I found the Redistributable Package here:
http://msdn2.microsoft.com/en-us/data/aa937733.aspx

Thanks in advance,

Mark Elder

[MichaelNesmith]

Sure, you can do the following things generally when installing any runtime:

1) If its an EXE, use Run Program to install it.
2) If its an MSI, use (Un)Install MSI Setup to install it.
3) If its an MSM, simply add it to your project.

You can do wilder things, too, depending on how much free time you have:

4) Write a custom Application Runtime for it, which is natively displayed inside the IDE:
http://www.installaware.com/installawar ... s_view.pdf
5) Use the Setup Decompressor to optimize the size of your runtime.
6) Use PackageAware or the Database Import Wizard to reverse-engineer the runtime installation completely.

[MarkElder]

Well I don't have enough free time to try items 4-6.

The only available download I can find for this is a msi package. I have added msm packages to my install before but never tried to call a msi.

Is there anything I need to be concerned about when using a msi for installing a runtime. I was really kind of surprised when this was not available as a msm.

I did some checking but did not find a lot of information on the difference between calling a msi vs. using a msm.

Thanks,

Mark