Roundcube Community Forum

Release Support => Pending Issues => Topic started by: birria on May 11, 2011, 09:59:43 PM

Title: DSN (write): NOT OK(MDB2 Error: not found) with mssql
Post by: birria on May 11, 2011, 09:59:43 PM

Roundcube 0.5.2
Windows Server 2008 R2 Web
MS SQL Server 2008 R2 Web
PHP 5.3.6

DSN (write): NOT OK(MDB2 Error: not found)
Make sure that the configured database exists and that the user has write privileges
DSN: mssql://usr:pass@(Local)/SQLServer/RoundCube

I have tested the SQL credential and they work ok.
All other check enviroment and test config are ok
the sqlsrv and pdo extensions are loaded
Have tryied simple php sql loggin tests (not pear mdb2) and they work ok

What else am I missing to check?...
I'm a n00b on php, can anyone help me with a small simple script to test the connection the way RoundCube does so that an error jumps?

Title: Solved
Post by: birria on May 11, 2011, 10:43:00 PM

After some T&R, this was the correct dsn:

sqlsrv://usr:pass@(Local)/RoundCube

Title: DSN (write): NOT OK(MDB2 Error: not found) with mssql
Post by: MKNDK on November 06, 2011, 01:02:51 AM

DSN (write):  NOT OK(MDB2 Error: not found)

Please help

Title: DSN (write): NOT OK(MDB2 Error: not found) with mssql
Post by: MikeAspinall on November 16, 2011, 01:43:21 PM

Might be reading your post wrongly so sorry if I am, I fixed mysql connection issues by adding the mysql port number as follows

'msql1://mysqluser:mysqlpassword@localhost:3306/roundcubedb';