Odbc

[Guest meiotic]

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

[SupportTeam]

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

[Guest Guest]

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

Edited 03/08/2006 08:08 PM by SupportTeam

[Guest meiotic]

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.

[SupportTeam]

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 (?)

[Guest meiotic]

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.

[SupportTeam]

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.