can not retrieve from Oracle database

[mzaki]

Hi all,
I have a customer who wants the caller to be directed to a group based on his preferred service path automatically based on his CLID.
the customer has an Oracle dbase with the customers CLID & preferred service path for each of them.
I created a VMPro module to connect to the dbase & retrieve the preferred path from it but I could not retrieve the required field from the dbase although I could open the dbase successfully.
here is the setup information:

1- IP Office 500 V2 with release 9.1.2.0.91
2- Voicemail pro release 9.1.2.0.61
3- Oracle database 11.2.0.1G R2 64bit Enterprise Edition
4- All applications are installed on Windows server 2008R2 64bit
5- attached are the snapshots of the VMPro module & Oracle dbase.
BR,
Moataz Zaki

[claud4]

How you are transferring CLID to Oracle SQL in the first place . Do you have CTI Pro license .Can you give me the steps done on VM -Pro

Claudion .

[havel3]

CTI Pro? For database access? That is new for me.... and I working on IP Office from R1.0 beta...
The question has been posted in another forum and there he received some hints what to do.

[kirchenlo]

The only thing I can assume is that your ODBC driver is not properly working. I had a similar issue with MS SQL Express and it was related to the ODBC Driver I was using.

Here a link to the Oracle Drivers.

http://www.oracle.com/technetwork/database/windows/downloads/index-096177.html

For creating the ODBC Data Source you should use odbcad32.exe and not the standard ODBC tool under control panel.