By sashidar on

Hi,

i installed latest 4.6.5 version in my localhost ,i'm using MySQL it is working good,but my client's requirement is MS SQL .But i did not find database.mssql in my installtion.What might be the problem?

⋅ Categories: Drupal 4.6.x

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented

We dropped mssql support quite a while ago.
--
Drupal services
My Drupal services

--
Drupal services
My Drupal services

heine’s picture

heine commented

MySQL or PostgreSQL are supported (see install.txt). Here's a link about MS SQL: http://drupal.org/node/1357.

You need to adapt the SQL file. You can also try a search on google (site:drupal.org "ms sql") for more threads on this.

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

sashidar’s picture

sashidar commented

I read the thread about MS SQL , finally i got the database.mssql file . I haven't tested whether it works properly OR not. If i want to implement this Database Do i need to write database abstaction layer functions myself? If i implement those 14 functions will it work good? can i get tested version of Dtabase.mssql and Database abstraction layer functions anywhere?
Finally In forums the statement was like as shown below, i'm not able to understand what he really meant by and there is no database.mssql in CVS version also.
The statement is like this:
The CVS version of Drupal has recently been enhanced such that Microsoft SQL Server (MSSQL) database joins MySQL and Postgres as a compatible database server.

killes@www.drop.org’s picture

killes@www.drop.org commented

We are trying to use ANSI SQL inside Drupal so if you write the proper db abstraction layer and proper mssql scheme, then this should work. We of course do not give any warranty.
The statement you found is old. We added mssql at some time and then remove it again as nobody wanted to support it anymore.

Here is an old copy of the db scheme:
http://cvs.drupal.org/viewcvs/drupal/drupal/database/database.mssql?only...

Mssql used to use the PEAR db abstraction layer which we used to use for pgsql too. Nowadays we use pgsql's PHP functions directly, though.
--
Drupal services
My Drupal services

--
Drupal services
My Drupal services

sashidar’s picture

sashidar commented

Thnak you for your reply .So i will suggest my clients to use MySQL only .If they wont i will take the risk of writing db abstraction layer and MS SQL scheme.