Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   IP Telephony and Convergence (http://support.avaya.com/forums/forumdisplay.php?f=8)
-   -   Avaya OneX attendant ODBC (http://support.avaya.com/forums/showthread.php?t=1552)

fabio1vitro 03-14-2012 06:44 AM

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?

mskinner 03-16-2012 06:56 AM

Please verify that the Oracle ODBC is under system DSN and not the user DSN.

fabio1vitro 03-16-2012 07:36 AM

problem solved
 
great it works with system DNS! Thank you very much!


All times are GMT -7. The time now is 04:10 PM.