By mobilemeanbunny on

So I am trying to build a new drupal site to replace their old Silverlight site. The customer has a pre-existing SQL Server database that is being used to store all of their data. The website we are building needs to incorporate some of this data. Right now I have the drupal 7 site running a MySQL db.

My question is, Do we have the ability to connect up to a SQL Server database and then build a View off of that database? I have tried searching the forums and haven't really had much success finding what I am looking for.

Currently I have installed the SQL Commerce Guys module. However, it doesn't seem to let me enable it in the modules section of the site.

Any help on this is greatly appreciated!

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

See http://drupal.org/node/18429#comment-5404892 for how to connect to multiple databases (note even though it for the same type, it works for different types also). For views, install advanced help and read the developer documentation on describing tables to views. (I have not used the module but you might look in it's issue queue)

mobilemeanbunny’s picture

mobilemeanbunny commented

Ok I have installed the Advanced help module and have been reading the documentation. I guess my biggest question is where do I start lol. The advanced help is more than helpful but it doesn't really show me where I would get started in implementing this so that I can manipulate the data.

I have added my database to the settings.php file but also how do I test to even make sure its connecting to the MSSQL server?

fishfree’s picture

fishfree commented

Maybe this link can help you.