Vg With Oracle

[Guest u4910]

I'm setting up a new install of VG 7.3 and trying to connect with the Oracle 11.2 client.

I'm getting an error:

 

110040.593 10 WARN Db_Open failed. Cannot read outbound dialer database.
110041.604 10 dial calling DB_Open as conn_Main.State=Closed
110041.604 10 Db_Open GetFactory call [system.Data.OracleClient]
110041.605 10 Db_Open sDbName=[PROD]
110041.605 10 Db_Open CreateConnection call
110041.605 10 Db_Open CreateConnection returned. conn=System.Data.OracleClient.OracleConnection, this=ktlib.vgDb.vgDb_ProviderInvariant
110041.605 10 Db_Open sConnString in.len=168, rvreplaced.len=163
110041.605 10 Db_Open conn.Open call
110041.605 10 ERROR Db_Open conn.Open, ex: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

 

What's the best resolution?

config.xml

0612_1100_vgEngine.txt

[SupportTeam]

Looks like you are trying to set up an alternative OutDial database. (DB that stores outgoing calls to be made by the dialer).

 

Your current Config.xml has:

 

<Dialer>
<OutDialQue_ADODB_Provider>System.Data.OracleClient</OutDialQue_ADODB_Provider>
<OutDialQue_Database>PROD</OutDialQue_Database>
<OutDialQue_ConnectString>Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servname)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=$DATABASE)));User Id=voiceguide;Password=voiceguide;</OutDialQue_ConnectString>
<OutDialQue_PortToUse_LinkField>Disable</OutDialQue_PortToUse_LinkField>
<OutDialQue_SqlPrefix>SELECT</OutDialQue_SqlPrefix>
<OutDialQue_SqlSuffix></OutDialQue_SqlSuffix>
</Dialer>

 

 

This matches with what is suggested in http://www.voiceguide.com/vghelp/source/html/dial_vgdb_external_config.htm :

 

 

Dialer>
<OutDialQue_ADODB_Provider>Oracle.DataAccess.Client</OutDialQue_ADODB_Provider>
<OutDialQue_Database>vgDb</OutDialQue_Database>
<OutDialQue_ConnectString>Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.26)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=$DATABASE)));User Id=HR;Password=hr;</OutDialQue_ConnectString>
<OutDialQue_PortToUse_LinkField>Disable</OutDialQue_PortToUse_LinkField>
<OutDialQue_SqlPrefix>SELECT</OutDialQue_SqlPrefix>
<OutDialQue_SqlSuffix></OutDialQue_SqlSuffix>
</Dialer>

 

 

I assume that the HOST parameter entry was edited before posting Config,xml ?

 

vgEngine trace shows:

 

 

110040.568 10 Db_Open GetFactory call [system.Data.OracleClient]
110040.572 10 Db_Open sDbName=[PROD]
110040.573 10 Db_Open CreateConnection call
110040.576 10 Db_Open CreateConnection returned. conn=System.Data.OracleClient.OracleConnection, this=ktlib.vgDb.vgDb_ProviderInvariant
110040.576 10 Db_Open sConnString in.len=168, rvreplaced.len=163
110040.577 10 Db_Open conn.Open call
110040.593 10 ERROR Db_Open conn.Open, ex: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
110040.593 10 WARN Db_Open failed. Cannot read outbound dialer database.

 

 

so looks like there is an error on Oracle client libraries level.

 

 

With external OutDial DBs its best to test connectivity to them by just using a 'Database Query' module from within a VoiceGuide script first. This would let you quickly test whether connection works and different connect strings etc.

 

Are you able to connect to this database through System.Data.OracleClient provider from with a VoiceGuide 'Database Query' module?

It looks like the Oracle client libraries issue would still be an issue however.

[Guest u4910]

Had to install 11.2 64 bit and 11.1 32 bit.

Works now.

I've had to do that on other 64 bit machines, not sure why, but seems to need components of both.