Is it possible to use Roundcube with MS SQL

[mishoddt]

Hello!

Is it possible to use Roundcube with MS SQL? I have did running configuration using MySQL with no problems, but trying to move to MS SQL 2005 connection fails with the next in the error log:

[12-May-2008 14:36:04 -0700] DB Error: DB Error: null value violates not-null constraint Query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (getdate(), getdate(), '[email protected]', 'mail.domain.com', '', 'en_US') [nativecode=515 - The statement has been terminated.] in C:\Inetpub\wwwroot\roundcube\program\include\rcube_db.inc on line 530
[12-May-2008 14:36:04 -0700] PHP Error: Failed to create new user in C:\Inetpub\wwwroot\roundcube\program\include\rcube_user.inc on line 417


Can anyone help me with configuration for MS SQL?

Thanks!

[oldschool]

Who use M$? Wake up! This is a sinking ship...
You are welcome to the "Unix"-community like Linux, OSX, etc. pp.!
Btw. why not mysql?

Rgds.

[adminedit]This isn't the place for company bashing, or choice ridiculing.[/adminedit]

[bpat1434]

@oldschool:  Sometimes it's not a personal choice, but a choice made by the administration to use MSSQL since they're also using IIS and other MS software.  So please don't bash people for decisions they may or may not have made.

@mishoddt:  I've seen this in MySQL as well.  Typically it's because a strict setting is enabled in the SQL server.  See if you can remove that for your particular database (might not be possible).  If it's not possible, then you'll have to edit the SQL tables.  If you need to edit the SQL tables, just look at each table and not where it has "NOT NULL" in the column value, change it to "NULL" and that should fix it.  You would need to start with the users table.

Hope that helps.  I think I'll file a ticket with them as this is not the first time I've heard of this issue.

[Rilla]

This post helped me get mine working
http://www.roundcubeforum.net/general-discussion/3802-here-answer-setting-up-roundcube-mail-mssql-server.html#post15108

-Rilla