I am looking for a group or just others interested in using MSSQL Svr with Drupal (especially Drupal 7).
I am NOT necessarily wanting to run Drupal on Windows. I want to leave Drupal on its own server under Linux but store the data in SQL Svr on its own Windows server.
Is this group the appropriate group for such discussion? If not, where might I find people interested in such discussion.
I would be interested in finding/developing modules that make the interaction between Drupal on MySQL (with node mgmt there) and the data content tables on SQLSvr transparent (i.e. when you submit the content-type form in Drupal it would update the Node info in local MySQL and the content table in SQL Svr on a remote server.
Thanks for any advice or suggestions.
Comments
I don't think this is much of
I don't think this is much of an issue. All you need is to provide the correct machine name in the $databases array in the settings.php file and you're good to go.
In the Drupal 7 sites/default/default.settings.php file, line 46 is where the Database Settings section begins.
array('driver' => 'mysql',
'database' => 'databasename',
'username' => 'username',
'password' => 'password',
'host' => 'localhost',
'port' => 3306,
'prefix' => 'myprefix_',
'collation' => 'utf8_general_ci',
);
driver probably needs to be 'mssql' and host is going to be your other machine name, such as 'mssql.my.domain.com' - and port will likely be 1433 or 1434 instead of 3306.
Once you set those items, you can load the website's install page and get up and running quickly.
This project might be of some assistance as well: http://drupal.org/project/sqlsrv
sqlsrv
I am trying to connect to a microsoft SQL server, i have (i think!) all the information i need to connect, password, username, host etc.'
I keep getting the message 'Driver not specified for this database connection: mydatabase.
I've tried installing the module sqlsrv to see if that helps but the module won't enable and there is no hint at what other module might be required!
Any ideas where i might be going wrong? I'm completely stumped!
Cheers in advance.
Have you copied sqlsrv
Have you copied sqlsrv directory from sqlsrv module to "includes/database" folder? It is a place where SQL drivers live. Also check if you have pdo_*.dll modules enabled for your PHP version.
check if you have pdo_*.dll modules
Thanks for getting back so prompt.
I have checked the includes folder and it seems correct. I'm not so sure about the pdo stuff! I'm testing it on my local mac computer, using Aquia drupal. I installed Mamp hoping the php would be installed with it! But I'm pretty new to this and still heading down the rabbit hole!
Thanks, but ...
Thanks for your suggestion, but my primary interest was less about knowing how to connect to a MSSQL database to Drupal but rather to find others who are interested in general in finding/advancing tools for having Drupal interact effectively and efficiently with MSSQL (primarily where Drupal is using MySQL on Linux and MSSQL is running on Windows.
Having said that we are stuck on getting MSSQL drivers working on PHP under Ubuntu. It would be good for us to be able to communicate with someone who actually has gotten that configuration to work.
Thanks.
P.S. I went to http://drupal.org/project/sqlsrv but that seems to be for people wanting to run Drupal on SQL Server. I want to leave Drupal in Linux/Apache/PHP/MySQL environment, but be able to interact with data from other dedicated online transaction processing applications that run with MSSQL under Windows.
Thanks.
There is a new Microsoft
There is a new Microsoft Servers group. You might want to ping the Commerce Guys re: the MSSQL driver. I am under the impression that PDO is working well for that - if not you might want to go to a Microsoft forum for help.
Joe Murray
You would setup additional
You would setup additional databases and drivers and your code would need to be specifically using the MSSQL database connection when that is where the data is.
I know for a fact that drupal can run on mysql and have data in mongo or couch. This same system that makes the mysql/mongo configuration work will work for the mssql setup.
I'm pretty sure that D7 Entity API has a per entity database connection ability so that each entity can be stored in a different database. For instance, you can use mysql, mssql, oracle all in the same installation.
My biggest concern for you is making a linux box connect to MSSQL server in general. If you can get PHP and PDO to connect to MSSQL from a linux box I know Drupal will work for this.