View Single Post
  #1  
Old 03-14-2012, 06:44 AM
fabio1vitro fabio1vitro is offline
Aspiring Member
 
Join Date: Mar 2012
Posts: 2
fabio1vitro has 10 reputation points
Default Avaya OneX attendant ODBC

I'm facing to ODBC problem with avaya OneX attendant in Windows 7 OS 64 bit.
I'm trying to connect the PhoneBox data source with an Oracle ODBC, and this works fine, the problem is on the Update Service.
The updateservice.log shows the follow error:

INFO | jvm 1 | 2012/03/14 14:30:34 | 2012-03-14 14:30:34,584 ERROR UPDS -
INFO | jvm 1 | 2012/03/14 14:30:34 | java.sql.SQLException: [Microsoft][Driver Manager ODBC] Data source name not found and no default driver specified.
INFO | jvm 1 | 2012/03/14 14:30:34 | at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6958)
INFO | jvm 1 | 2012/03/14 14:30:34 | at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7115)
INFO | jvm 1 | 2012/03/14 14:30:34 | at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.j ava:3074)
INFO | jvm 1 | 2012/03/14 14:30:34 | at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOd bcConnection.java:323)
INFO | jvm 1 | 2012/03/14 14:30:34 | at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDrive r.java:174)
INFO | jvm 1 | 2012/03/14 14:30:34 | at java.sql.DriverManager.getConnection(DriverManager .java:512)
INFO | jvm 1 | 2012/03/14 14:30:34 | at java.sql.DriverManager.getConnection(DriverManager .java:171)
INFO | jvm 1 | 2012/03/14 14:30:34 | at com.tenovis.apps.ospc.updateservice.UpdateTask.cre ateResultSet(UpdateTask.java:200)
INFO | jvm 1 | 2012/03/14 14:30:34 | at com.tenovis.apps.ospc.updateservice.UpdateTask.run (UpdateTask.java:152)
INFO | jvm 1 | 2012/03/14 14:30:34 | at java.util.TimerThread.mainLoop(Timer.java:432)
INFO | jvm 1 | 2012/03/14 14:30:34 | at java.util.TimerThread.run(Timer.java:382)

The Oracle Driver is a 32 bit version because the Configuration tool doesn't see the 64 one, I checked the 10g and 11g version with the same result. I check also with an Microsoft Access ODBC, and surprise the error still remains so the problem is not the Oracle Database.

I think there is a problem with ODBC or with the OS version.
The One X version is the 3.0 service pack 5.
Can any one help me?
Reply With Quote