SQL Server Config No SQL-driver information available. Connection to database failed. (SOLVED)

Spend days trying to get ejabberd talking to SQL Server and been faced with the following error in the logs:

No SQL-driver information available. Connection to database failed.

x64 has two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:\Windows\SysWOW64\odbcad32.exe is the 32 bit version.

I did the following for the 64 and 32 bit utility:

run sql script to make a new database
Make a system DSN, named ejabberd, pointing to the new database using sql authentication
Test Connection
uncomment ODBC in the config file to read {odbc_server, "DSN=ejabberd;UID=sa;PWD=yourpassword"}.

you can also test odbc connection in powershell to get more detailed errors

Just use this:
$conn = new-object system.data.odbc.odbcconnection
$conn.connectionstring = "DSN=ejabberd;UID=sa;PWD=yourpassword"
$conn.open() // if it returns with no error it was successful - otherwise it prints a detailed error

Hope all this info helps someone!