SOLUTION for odbc error running as Windows Service

bkandger — Mon, 18 Oct 2010 07:54:35 +0000

================ SOLUTION ===================

Error:
I(<0.275.0>:ejabberd_odbc:205) : odbc connection failed:
** Reason: "No SQL-driver information available. Connection to database failed."
** Retry after: 30 seconds

happens on Windows because EjabberD windows installer installs server as windows service but it lacks permissions for running (as I think).

You can solve it that way:

- go to 'Administrative Tools' -> 'Services'
- find installed ejabberd service and open its Properties window
- go to 'Log on' tab
- see option 'Log on as' and change from 'Local System account' to 'This account'
- select correct login name and password in your system for running EJabberD with explicitly selected admin's account

Error about ODBC error should go away. That works fine for me.

Try to configure the option odbc_server

mfoss — Mon, 24 May 2010 15:11:32 +0000

The ejabberd Guide doesn't explain this important MSSQL configuration:

Quote:

The actual database access is defined in the option odbc_server. Its value is used to defined if we want to use ODBC (or MSSQL), or one of the two native interface available, PostgreSQL or MySQL.

To use a relational database through ODBC (or MSSQL), you can pass the ODBC connection string as odbc_server parameter. For example:

{odbc_server, "DSN=database;UID=ejabberd;PWD=password"}.

ejabberd - Comments for "service does not work windows 2003 x64 mssql odbc installation"

SOLUTION for odbc error running as Windows Service

================ SOLUTION ===================

Try to configure the option odbc_server