Oracle 11.2 For Cdr

[Guest u4910]

I'm trying to use Oracle 11.2 for the CDR. I'm getting an error

000058.922 5 Db_Open GetFactory call [msdaora]

000058.922 5 ERROR v7.1.3747.27754 (2010-04-05 14:25:09.47) Db_Open GetFactory : Unable to find the requested .Net Framework Data Provider. It may not be installed

 

I have the ODBC and .net provider for oracle installed. I can insert records fine using ODBC from the query database module. I've tried to specify "ODBC", "MDSAORA" as well as "System.Data.OracleClient.OracleConnection".

 

Can you please advise as to what I should use to connect for CDR? See attached.

Thanks,

1211_0000_vgEngine.zip

Config.zip

[SupportTeam]

The provider name is:

 

System.Data.OracleClient

 

Note that you would need to the set the right connect string and setup the actual CDR tables in the database yourself.

[SupportTeam]

From traces it looks like you want to have the dialer's 'outdial' tables in the the new Oracle DB as well, not just the CDR logs.

 

Oracle is harder to configure then other DBs (like MSSQL, MySQL, etc)

 

You would need to set up the tables in Oracle database yourself manually. Look at the SQL table setup scripts in C:\Program Files\VoiceGuide\System\Setup\ for information on what the database tables' structure should be like.