Author Topic: DSN (write): NOT OK(MDB2 Error: not found) with mssql  (Read 4576 times)

Offline birria

  • Newbie
  • *
  • Posts: 3
DSN (write): NOT OK(MDB2 Error: not found) with mssql
« 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?

Offline birria

  • Newbie
  • *
  • Posts: 3
Solved
« Reply #1 on: May 11, 2011, 10:43:00 PM »
After some T&R, this was the correct dsn:

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

Offline MKNDK

  • Newbie
  • *
  • Posts: 3
DSN (write): NOT OK(MDB2 Error: not found) with mssql
« Reply #2 on: November 06, 2011, 01:02:51 AM »
DSN (write):  NOT OK(MDB2 Error: not found)

Please help

Offline MikeAspinall

  • Newbie
  • *
  • Posts: 3
DSN (write): NOT OK(MDB2 Error: not found) with mssql
« Reply #3 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';