VoiceGuide IVR Software Main Page
Jump to content

Problem Connecting To Database

Recommended Posts

I am trying to get voice guide access a remote MySQL database, but so far I have got little success.

 

When I test the connection with the myodbc driver I get a successfull connection (see attached screen shot).

 

But when I try it with voice guide, the myodbc screen pops up again (I read that many have the same problem, I will deal with it later). Then when I click 'OK' Voice guide simply shuts down !

 

First, on clicking 'OK' voiceguide did not shut down, but still, it did not perform a successfull connection because it took the 'on FAIL' path. Now I am running voice guide on another brand new system. This time voiceguide simply shuts down.

 

I have attached all the screen shots and log files.

 

Please see if you can figure out where I may be going wrong.

 

thanking you,

frequency.

 

PS: In my first computer in which voiceguide took the failed path, i used to get the something like "odbc - Open Failed" error in my log file

imgs_and_logs.zip

Share this post


Link to post

The best workaround path to start working on is to connect to the database using VBScript ran within a Run VBScript module.

 

You will then have full control over the connection method, ODBC connection object creation and will be able to tweak the many other settings associated with database connections.

 

You can also test your VBScript outside VG before placing it in Run VBScript module.

 

There are usually VBScript examples available for connecting to different databases, especially one as popular as MySQL.

 

Saving retrieved data top VG's Result Variables is pretty straightforward using RvSet etc COM commands.

Share this post


Link to post

Allright, I could solve the problem by uninstalling myodbc driver and downloading this --> ftp://ftp.mysql.com/pub/mysql/hidden/conn...51.13-win32.msi

 

But now I have problems with the Run Program Module.

 

I am trying to run a java program using the Run Program Module.

 

The java program runs fine when I execute it from the command prompt.

This is how I do it: C:\j2sdk1.4.2_12\bin\java ivrtest

The java program runs fine when I execute it from START->RUN->C:\j2sdk1.4.2_12\bin\java ivrtest

 

But when I try to execute "java ivrtest" from VG the following happens..

 

I use this in program details: C:\j2sdk1.4.2_12\bin\java ivrtest (see screen shot)

 

* If I select the option "Do not wait until program completes" it takes the SUCCESS path. But the program does not execute. the DOS console windows flashes and closes.

 

* On the other hand if I select the option "Wait until program ends", again the DOS console window flashes, but it takes the "fail" path.

 

Please have a look at the attachtments, logs and screen shots and let me know if you can figure out what the problem is.

 

Thanks again !!

Share this post


Link to post
Allright, I could solve the problem by uninstalling myodbc driver and downloading this --> ftp://ftp.mysql.com/pub/mysql/hidden/conn...51.13-win32.msi

Good to hear it's all sorted. I assume that this was just the latest version of MySQL's ODBC connector, and using this latest version instead of the older version worked...

But now I have problems with the Run Program Module.

Try specifying this in the Run Program module's command line:

 

command.com /c "C:\j2sdk1.4.2_12\bin\java ivrtest"

 

or maybe without the quotes, like this:

 

command.com /c C:\j2sdk1.4.2_12\bin\java ivrtest

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×