Heya.
I'm having an issue getting ejabberd to play with my mssql DB. I have it set up correctly (I believe, Ill post my config below). I can authenticate, and create new users.
When I try to send an offline message it won't save, and from sql profiler it looks like the xml quotes are getting in the way:
insert into spool(username, xml) values ('15547', 'from=\'1554@d1ygg1d1/polling\' to=\'15547@d1ygg1d1\'>asdfasdfasd
Fixed the offline msg issue
I had to re-compile the odbc_queries.erl file with the mssql setting and plunk the beam into the ebin directory.
C:...\bin\erlc -W -I .. -pz .. -Dmssql C:\ejabberd-2.0.0\src\odbc\odbc_queries.erl
Now it's hitting the SQL queries. Now to figure out rosters.....
Paul