SQL Server Code for Drupal 5 Released
I've uploaded my code for a MSSQL-compatible Drupal 5 installation. The only folder that didn't commit properly was modules/color, so I'll try to get that working soon - hopefullly that doesn't prevent you from installing and using a non-color module theme. You can find the files on cvs.drupal.org at /contributions/sandbox/pcorbett/drupal-mssql. You'll need to checkout all the folders and then move the contents of the root_folder_files into your root folder (CVS doesn't let me commit files that aren't contained in a folder).
If you need help getting started, let me know. This may or may not be helpful to anyone - I'm using this in a production environment, but with some 3rd party apps such as FreeTDS to talk between PHP and SQL Server using phpdblib.dll instead of the typical php_mssql.dll (which poses some restrictions on DB calls made from PHP and making it difficult to use Drupal).
There are some php.ini settings that may not be obvious, so if you have issues, feel free to contact me.
Hopefully we'll have D6 ready for SQL Server shortly. I've heard rumors that others are already working on this and there are some new developments that should make using FreeTDS unnecessary.
So, if there are still D5 users out there dying to run it on SQL Server, here you go, enjoy!
good timing
I am interested in this option.
I saw how you can swap databases in settings.php files and a new db connection layer would be great, especially to pull away from (or compliment) .NET content management systems.
link?
Where's the link to download or view code?
Checkout from CVS
It's all on my sandbox: http://cvs.drupal.org/viewvc.py/drupal/contributions/sandbox/pcorbett/dr...
Best way is to checkout from CVS, here's how: http://drupal.org/node/321
Feel free to contact me directly if you need specific help.
Drupal 7!
Get this into Drupal 7! SQLite support was added last week, so I don't see why MSSQL support couldn't be added. Do it! The MS SQL Server PDO support is experimental, but it does work.
Will do
I know, I've been so caught up in getting D5 going, practically two versions of Drupal have passed me by. I'll try to get this committed ASAP.
Hello boys :) Can U upload
Hello boys :)
Can U upload php source to other place... then http://cvs.drupal.org/viewvc.py/drupal/contributions/sandbox/pcorbett/dr...
no so easy to download :( //maybe like rapidshare
Big thenx.
Install fails on existing MSSQL Database
You pointed me to your work in the Feature Request Category. I've installed your 5.x sandbox version but it doesn't complete the process. Can I get some advice about it please?
After supplying the correct credentials though (I have confirmed that I can access the database using OBDC and SQLExpress Client) the script returns to the initial entry point without response or error. I have the MSSQL driver installed for PHP and that it is loaded is confirmed by phpinfo(). Getting this to work will provide helpful information for me. I would appreciate any thoughts or troubleshooting tips to help figure out what might be going wrong.
Thanks much for any advice!
Details please
Could you be more specific about how it doesn't complete the installation process? Does it end on a white-screen? Any error messages?
Also make sure you have the FreeTDS php_dblib.dll driver installed in your PHP extensions directory and have the config file set up properly. Please contact me directly if you think that will be more productive... I'm happy to help.
Drupal 6 and SQL Server
"Hopefully we'll have D6 ready for SQL Server shortly"
Any further news / development on SQL Server for D6?
Thanks.