Hello Friends,

I have been successful in installing Drupal on windows IIS by using sqlsrv module given by the community, I am happy that it worked and my folks tested that Drupal website is working fine with the modules they were using.

I am trying something similar when Drupal is on Linux along with Apache. I installed FreeTDS, created an ODBC, also downloded Drupal module for ODBC: https://www.drupal.org/sandbox/pstewart/2010758 but not sure how to make this work so that while installation of a new site in Drupal from web console, I am able to connect to a SQL Database. I have this, DSN, FreeTDS integrated with ODBC manager.

I also heard about DBLib module which seem to have been written as a Linux brother of sqlsrv but can't download this and there are hardly any instructions for this.

Please help.

Regards
Chandan Jha
DBA

Comments

chandan_jha18’s picture

chandan_jha18 commented

After posting this question, I looked at the dblib page again, there were some instructions to using git to download it which I overlooked earlier as I am not a Linux guy. I was using some other DBLib module which was too old. I downloaded the DBLib module from this page and kept it in /includes/database directory. I was successful in seeing SQL Server as an option on Drupal installation page.

I got an error- 'Transactions not supported', may be because I am using PHP 5.3. I googled it and found that with a higher version of PHP, this error will go away but I will be careful and avoid any upgrades as I might loose all the work on building the current system. I will work on this Monday next week and update my progress. It may help someone.

Cheers!!

chandan_jha18’s picture

chandan_jha18 commented

I used PHP 5.5, the error went away. I am able to connect to SQL Server but as soon as the installation begins it displays a message on my firefox browser: the page was reset.

I looked into my database and sql server trace files, found that it actually created 11 tables and when it tried to create a unique index on a table date_formats it got an error : ' Cannot create index. Object 'date_formats' was created with the following SET options off: 'ANSI_NULLS'.

I am posting a bug under DBLib module: https://www.drupal.org/node/2392771