Problem <OutDialQue_ADODB_Provider>Oracle.DataAccess.Client</OutDialQue_ADODB_Provider>

[dminof]

hello i have problem with oracle 11.2 external database and query external database query too, your help please,

Cheers

Diego

 

Dialer config

 

<Dialer>
<OutDialQue_ADODB_Provider>Oracle.DataAccess.Client</OutDialQue_ADODB_Provider>
<OutDialQue_Database>dbhvq.quito.hcjb.org</OutDialQue_Database>
<OutDialQue_ConnectString>Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.129.180.8)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=$DATABASE)));User Id=callcenter;Password=call;</OutDialQue_ConnectString>
<OutDialQue_PortToUse_LinkField>Disable</OutDialQue_PortToUse_LinkField>
<OutDialQue_SqlPrefix>SELECT</OutDialQue_SqlPrefix>
<OutDialQue_SqlSuffix></OutDialQue_SqlSuffix>
</Dialer>

 

Problem DIALER ACCES DATABASE EXTERNAL

215708.838   9                     Db_Open using user set data Provider [Oracle.DataAccess.Client]
215708.838   9                     Db_Open GetFactory call [Oracle.DataAccess.Client]
215708.842   9               ERROR v7.6.30 - 7.6.7492.34829 (2020-07-06 19:20:57.36) Db_Open GetFactory : System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
   at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
   at ktlib.vgDb.vgDb_ProviderInvariant.Db_Open()
   
   
   Problem DBQUERY
   
   
     
   
   215748.215  18   3   1     1 state [Database Query 1_1] DB Query | 
215748.215  18   3   1     1       db    did not find ado.net data provider : [Oracle.DataAccess.Client]
215748.216  18   3   1     1       moh not set
215748.216  18   3   1     1       db    using ado.net OleDb : OleDbConnection/OleDbCommand/etc
215748.216  18   3   1     1       strDirOfDb=, altering strDatabaseName to: C:\Program Files (x86)\VoiceGuide\Scripts\Credit Card Payment\Oracle.DataAccess.Client
215748.219  18   3   1     1       dboledb RunQuery_OleDb [Database Query 1_1] C:\Program Files (x86)\VoiceGuide\Scripts\Credit Card Payment\Oracle.DataAccess.Client, Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.129.180.8)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbhvq.quito.hcjb.org)));User Id=callcenter;Password=call;, select * from calltrack

215748.219  18   3   1     1       dboledb  thread init (threadpool)
215748.220  18   3   1     1       dboledb  thread started (threadpool)
215748.220  18   3   1     1       db    iRunWait=1
215748.221  18   3   1     1 t     timer set   30 sec : EV_TIMEOUT_HANGUP
215748.223   8   3   1     1       dboledb ConnectAndRun_OleDb begin. Create connection: [Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.129.180.8)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbhvq.quito.hcjb.org)));User Id=callcenter;Password=call;]
215748.224   8   3   1     1 ERROR v7.6.30 - 7.6.7492.34829 (2020-07-06 19:20:57.36) ConnectAndRun_OleDb init1 : System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;'.
   at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
   at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
   at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.OleDb.OleDbConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
   at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
   at vgEngine.classVgmDbQuery_AdoNetOleDb.ConnectAndRun_OleDb()
215748.227   8   3   1     1       dbcompleted. [Database Query 1_1]  SqlQueryType=, RowsCount=0, sRv=
215748.227   8   3   1     1       rv    add   Database Query 1_1_error|An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;'.
215748.227   8   3   1     1       dbcompleted. iRunWait=1, WavPlayWasStarted=0, WavPlayHasNowFinished=0
215748.227   8   3   1     1       dbcompleted. strError=An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;'.
215748.227   8   3   1     1       path {An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;'.} not found
 

 

 

 

 

 

1229_2157_vgEngine.txt

[SupportTeam]

The error note in traces quoted says:
 

215708.838   9                     Db_Open GetFactory call [Oracle.DataAccess.Client]
215708.842   9               ERROR v7.6.30 - 7.6.7492.34829 (2020-07-06 19:20:57.36) Db_Open GetFactory : System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed. 

 

Looks like the provider "Oracle.DataAccess.Client" is not installed. trace shows that the only data access providers are:

215708.837   9                     sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.OracleClient|System.Data.SqlClient|System.Data.SQLite|Npgsql|]

Please download the Oracle.DataAccess.Client provider from Oracle and install it on the VoiceGuide system. The version you should install is the one for ".NET 4". Best to install it in the VoiceGuide directory.