![]() ![]() |
#1
|
|||
|
|||
![]()
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? |
#2
|
|||
|
|||
![]()
Please verify that the Oracle ODBC is under system DSN and not the user DSN.
|
#3
|
|||
|
|||
![]()
great it works with system DNS! Thank you very much!
|
![]() |
Tags |
odbc, onex attendant, windows 7 |
Thread Tools | Search this Thread |
Display Modes | |
|
|