SPECIAL OFFER: Only $69 for access to everything in OSTraining for 1 year! You save $75!  1
Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!

Views Database Connector

4 years 10 months ago - 4 years 10 months ago #118766 by MichaelCharbonneau
Views Database Connector was created by MichaelCharbonneau
Hi,

Is it possible to use the module Views Database Connector with a MS SQL server database ?

The example on your website here
www.ostraining.com/blog/drupal/views-database-connector/

only shows a connection to another MySQL database.


Part of the message is hidden for the guests. Please log in or register to see it.

Please Log in to join the conversation.

4 years 10 months ago #118768 by Valentin
Replied by Valentin on topic Views Database Connector
Hi and welcome to OSTraining Michael,

The module is limited to MySQL, PostgreSQL or SQLite as explains in "Requirements and Limitations": www.drupal.org/project/views_database_connector

Kind regards,
Valentín

Follow us on Twitter - twitter.com/OSTraining
Like us on Facebook - facebook.com/ostraining

Please Log in to join the conversation.

4 years 10 months ago - 4 years 10 months ago #118785 by MichaelCharbonneau
Replied by MichaelCharbonneau on topic Views Database Connector
ok .. then how would I get a table from a SQL server database to be used in a view ?
we have lots and lots of legacy data for our intranet and HR systems in MS SQL server.


thanks
Michael

Please Log in to join the conversation.

4 years 10 months ago #118787 by steve
Replied by steve on topic Views Database Connector
Hi Michael

I don't have a SQL server database available, otherwise I'd write a tutorial.

Fortunately, it looks like a couple of people have written about their experience doing this:
chrislarson.me/blog/drupal-access-extern...-sql-data-views.html
www.chapterthree.com/blog/how-connect-mi...ft-sql-server-drupal

Please Log in to join the conversation.

Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!