This post by Larry Garfield provides an excellent run-down of the different ways of using remote data in Drupal: http://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009 Kyle Research Assistant Entrepreneurship and Technology Center @ BYU kyle.mathews2000.com/blog On Tue, Jul 7, 2009 at 11:23 AM, John Fiala <jcfiala@gmail.com> wrote:
On Tue, Jul 7, 2009 at 11:18 AM, David Metzler<metzlerd@metzlerd.com> wrote:
When pulling data from external sources, I simply don't use the drupal database abstraction layer at all. It doesn't have an ick factor for me at all. I use the approach your talking about with great success at my university. We connect to Oracle and MSSql to get external data, and as a result have built quite a nice portal using drupal as the application development framework.
Good luck.
Dave
Agreed - if it's not the primary database, and you're careful about intentional or unintentional sql injection, there's no problem with using other methods to connect to the MS SQL db. Have fun!
-- John Fiala