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?
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?
.
Comment