Author Topic: ms sql not showing during install  (Read 3043 times)

Offline sckramer

  • Jr. Member
  • **
  • Posts: 17
ms sql not showing during install
« on: July 22, 2009, 05:35:26 PM »
can it be made to work in ms sql ?

what is the correct connection string in db.in.php, there is no example commented-- (to try it manually)

thanks!

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,856
ms sql not showing during install
« Reply #1 on: July 23, 2009, 03:23:42 AM »
try mssql://[username]:[password]@host/database
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and moreā€¦

Offline sckramer

  • Jr. Member
  • **
  • Posts: 17
ms sql not showing during install
« Reply #2 on: July 23, 2009, 12:38:17 PM »
i did, I tried a bunch of stuff & eventually got somewhere...

1st: it can only connect to a local ms sql server... times out on remote servers, that I know work remotely

2nd: had to add this function to mssql.php :

function setCharset($charset, $connection = null)
{
return true;
}

3rd:

I had to allow some nulls in the user table in the sql create scripts, to get past an insert error at the initial login...

got past that & it inserts records, but just says login error now...

So I gave up, I don't think its been tested maintained for mssql...


hopefully from this post the devs can add some of this into subversion--

thanks!!