Page 1 of 1

SQL Native Client OLE DB Provider

Posted: Fri May 18, 2007 6:01 pm
by 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

Posted: Tue May 22, 2007 6:24 pm
by 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.

:)

Posted: Wed May 23, 2007 10:21 am
by 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