mySQL/SQL Server intergration

I have ejabber 1.1.3 working on Windows 2000. I was able to integrate it with mySQL but not with SQL Server. I would rather have it working with SQL Server to avoid having to install mySQL on a production box.

This did not work with mySQL or SQL Server:
{auth_method, odbc}.
{odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"}.

This did work with mySQL:
{auth_method, odbc}.
{odbc_server, {mysql, "localhost", "ejabberd", "ejabberd", "ejabberd"}}.

This did not work with SQL Server:
{auth_method, odbc}.
{odbc_server, {sqlserver, "localhost", "ejabberd", "ejabberd", "ejabberd"}}.

I am just guessing what that token is for SQL Server. I'm probably wrong. Can anyone help me out?

Syndicate content