SQLExpress
2Hearts - June 4, 2009 - 23:12
Can anyone tell me if SQLExpress will work? Neither the 5.18 or 6.12 installer recognize it as a database. I get the message "web server does not appear to support any common database types".
User login
Contributor links
- Community initiatives
- Queues
- Play patch bingo!
- Play bug bingo!
- Mailing list archives
- Drupal.org webmasters
- Drupal.org server administrato
rs - Drupal.org CVS applications
- Web links
Drupal does not support SQL
Drupal does not support SQL Express at this time, and although there are some pushes for MSSQL, none have made it to core.
Is there any particular reason that you want SQL Express over MySQL?
-Corey
- Corey
SQLExpress
I was recently forced to retire due to a traffic accident so I'm trying to learn Drupal as a new "semi-retired" career on a limited budget. I have a VC partner willing to sponser an E-business, but he wants to see aprototype site up before committing funds. SQLExpress is free for 180 days giving me time to learn and build a prototype before committing funds.
MySQL is free, too, and easy
MySQL is free, too, and easy to set up on a home test server, but if it does not fit your needs then I understand. Drupal just doesn't support SQLExpress yet (probably because of the price tag!)
Good luck on your new venture, and hopefully we can help to answer any questions that you might have.
-Corey
- Corey
different SQL's
OK Folks - here's one for everyone else too! I've been reading about MySQL all over the Drupal site and didn't know it wasn't a Microsoft product! It's open-sourced from a different site and has some trial offers that do not require a purchase.
Any other "dummies" out there - here's a gotcha for you cause' everyone assumes you already know this so they don't say it!
Don't be too hard on
Don't be too hard on yourself. Setting up my first drupal database was one of the hardest things that I ever did.
For my test environment now, I use WampServer, which is a Windows installation of Apache, MySQL, and PHP, which is already configured to work together from that single installation. You don't have to download separate packages from different sites. And, of course, it's free, too.
Good luck, and have fun with Drupal!
-Corey
- Corey
SQLExpress
The big reason I was interested in Drupal was because I read on the internet its was SQL Server compatible, whereby Joomla wasn't. Guess that’s cleared up.
The reason any website I setup has to be compatible with SQLExpress is because the small businesses I work with have their data on SQL Server, as many, many others do. And considering they also have custom windows software already based on SQL Server, I think building a website that doesn't access SQLServer is simply out of the question for many users.
Oh yea, Microsoft has announced that SQLExpress will remain free from here on in. (guess MySQL was just too big a challenge to ignor eh!)
john
Just because Drupal itself
Just because Drupal itself uses MySql for its own data doesn't rule out a Drupal website incorporating data obtained from other sources - including MS SQL Server.