VoiceGuide IVR Software Main Page
Jump to content

Odbc

Recommended Posts

Hi,

I am a bit confused. I am trying to use an odbc connect to sql 2005. I created a DSN but do not see where to use it in your tool (it is looking for access or excel). So I have tried two different connect strings

 

Driver={SQL Native Client};Server=ME_IVR2;Database=NobelConnect;UID=web4ivr;PWD=xxxx;

 

and Provider=SQLOLEDB;Server=ME_IVR2;UID=web4ivr;PWD=xxxx;Database=NobelConnect

 

Neither on works.

 

I have seen other posting on this board, what is the proper method for using your system with SQL Server.

 

My script is attached.

NS_1.vgs

Share this post


Link to post

In the VoiceGuide help file there is an example showing MS SQL Server configuration:

ODBC Data Source (MSSQL) :

 

Database : Northwind

Connect String : ODBC;UID=sa;PWD=;

Query : UPDATE Products SET UnitPrice=$RV[NewPrice] WHERE ProductID=$RV[GetProductId];

See: http://www.voiceguide.com/vghelp/html/modDbQuery.htm

 

And for more advanced database work you can always use a VBScript. Some exmaples are again in the help file. See: http://www.voiceguide.com/vghelp/html/modVbs.htm

 

Looking at your script I see that you are already trying a VBScript to run the query...

(PS. also rearranged your script a bit to make it easier to read)

NS_1.vgs

Share this post


Link to post

I did try the Northwide setting but it did not work. Maybe I missed something and I will try it again.

Edited by SupportTeam

Share this post


Link to post

Thanks for the tip. It is really odd. I can query the database using VBS but when I put the very same string in your querydata base function it fails. I just need to be able to extract the query results so I can play them back.

 

 

cn.Open "Provider=SQLOLEDB;Server=ME_IVR2;UID=web4ivr;PWD=xxxx;Database=NobelConnect" 'MSSQL authentication

 

works...

 

Provider=SQLOLEDB;Server=ME_IVR2;UID=web4ivr;PWD=4theVoIP;

 

Does not...

 

Thanks for your help. If we could only get our system to dial the phone i would be thrilled.

Share this post


Link to post

You should be using the ODBC interface when running from "DB Query" module.

 

Still, if you can use it via VBSCript I guess all is fine (?)

Share this post


Link to post

Thank you for your help. We studied your sample for the stock market and it kept saying No records were found. Checking for records this way does not work for us. When we took out the test, everything was pleased.

 

Thank you for telling us that your query module does not support stored proc's. This was most likely our other error.

Share this post


Link to post
We studied your sample for the stock market and it kept saying No records were found. Checking for records this way does not work for us.

Are you referring to the "Internet Portal.vgs" demo script which reads back the Dow, Nasdaq and SP500 indices from finance.yahoo.com and speaks their values?

 

That example script is not using any databases - it retrieves the market info directly from http://finance.yahoo.com...

 

It sounds like you got VG working with your SQL Server, so I guess all is fine now..

 

And yes, if calling stored procedures within a database can only be done from within the Run VBScript module.

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
×