Posted by ribo on August 17, 2012 at 5:33am
Hello,
Here is my question
in our intranet we have implement drupal7 web applications using apache-mysql-php. We have an sql server 2008 database which holds some data.
Can i connect from drupal7 to the sql server 2008 database and fetch data to the already developed application?
i don not want to install drupal7 in to sql server 2008.
i want to query sql server 2008 db from apache.
Should i install PDO library and http://drupal.org/project/sqlsrv module and start custom sql queries or is there another way?
Thanks in advance
Comments
Connecting to SQL Server 2008
You basically have to install a PHP library that would allow you to use PHP functions to connect to the server and then you could create a custom module for Drupal which would give you more flexibility too.
There are ways around installing a PHP library but I typically get the best performance and results from install a library right into PHP and then using a custom module to do what I want.
Spiro Floropoulos
(Floropoulos Services)
www.spirofloropoulos.com
You can install PDO or
You can install PDO or Microsoft drivers, from there you can query the external ms sql database
code example here: http://blog.newtarget.com/codecorner/335
Pedja
Drupal Geek at New Target Inc.
http://www.newtarget.com