I was trying to setup an odbc connection to an oracle database. I have played around w/ the ODBC connection string for awhile but don't think I have it formated right. If anyone has done this can you please let me know the format. This is how I have it setup right now:
{odbc_server, "DSN=dta-001;DATABASE=ejabberd;PORT=1527;SSL=1;UID=ejabberdMgr;PWD=xxxxxx"}.
I'm using ejabberd 2.0.0 and get the following error message when I start ejabberd:
=INFO REPORT==== 26-Feb-2008::14:36:45 ===
The odbc application was not started. Has now been started as a temporary application.
=ERROR REPORT==== 26-Feb-2008::14:36:45 ===
E(<0.265.0>:ejabberd_odbc:254) : ODBC connection (DSN=dta-001;DATABASE=ejabberd;PORT=1527;SSL=1;UID=ejabberdMgr;PWD=xxxxxx) failed: "No SQL-driver information available. Connection to database failed."
Any other suggestions from people who have setup an oracle db in the background would be greatly appreciated.
Thanks
Andy
Not much help, just links
I can't help much. The error is reported by the Erlang library 'odbc'. The error is printed by ejabberd in the log file.
I found several threads, maybe they give you some idea (incompatible Oracle version, misconfiguration in Oracle DB...):
I'm actually a bit curious
I'm actually a bit curious where you found the create table scripts for Oracle. Did you write them from mysql/pg.sql scripts?
Thanks