This post by Larry Garfield provides an excellent run-down of the different ways of using remote data in Drupal:<br><a href="http://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009">http://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009</a><br>
<br>Kyle<br><br clear="all">Research Assistant<br>Entrepreneurship and Technology Center @ BYU<br><a href="http://kyle.mathews2000.com/blog">kyle.mathews2000.com/blog</a><br>
<br><br><div class="gmail_quote">On Tue, Jul 7, 2009 at 11:23 AM, John Fiala <span dir="ltr"><<a href="mailto:jcfiala@gmail.com">jcfiala@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On Tue, Jul 7, 2009 at 11:18 AM, David Metzler<<a href="mailto:metzlerd@metzlerd.com">metzlerd@metzlerd.com</a>> wrote:<br>
> When pulling data from external sources, I simply don't use the drupal<br>
> database abstraction layer at all. It doesn't have an ick factor for me at<br>
> all. I use the approach your talking about with great success at my<br>
> university. We connect to Oracle and MSSql to get external data, and as a<br>
> result have built quite a nice portal using drupal as the application<br>
> development framework.<br>
><br>
> Good luck.<br>
><br>
> Dave<br>
<br>
</div>Agreed - if it's not the primary database, and you're careful about<br>
intentional or unintentional sql injection, there's no problem with<br>
using other methods to connect to the MS SQL db. Have fun!<br>
<br>
--<br>
<font color="#888888">John Fiala<br>
</font></blockquote></div><br>