Database Connection

[Guest notes]

Sir Good Day, Im just only newbie here, and i just want to know everything about voiceguide.

Can you kindly give me sample script with connected to database using MS access or Excel?

Im using ver7 of voiceguide. For only my reference with the future,script with update/save data, and get data from

database using script.Hope you dont mind ,Thank you!

[SupportTeam]

Please see the sample scripts installed on your system by VoiceGuide v7 in these directories:

 

C:\Program Files\VoiceGuide\Scripts\Customer Enquiry\

 

C:\Program Files\VoiceGuide\Scripts\Excel Test

 

Please let us know if you have any further questions.

[Guest notes]

Please see the sample scripts installed on your system by VoiceGuide v7 in these directories:

 

C:\Program Files\VoiceGuide\Scripts\Customer Enquiry\

 

C:\Program Files\VoiceGuide\Scripts\Excel Test

 

Please let us know if you have any further questions.

 

Ill try Excel Test but i cannot connect to the databse,im using Excel2007

 

heres mt trace and script:

ATTACHMENT:

x.zip

[SupportTeam]

Try this:

 

Leave the Database / Data source line blank

 

On the Connect Striong line specify this:

 

Provider=Microsoft.ACE.OLEDB.12.0; data source='C:\Customers\notes\TestData.xls';Extended Properties='Excel 12.0 Xml;HDR=YES';

 

(change the path to .xls to reflect where it is on your system)

 

For SQL query specify:

 

select * from [sheet1$]

 

 

this resulted in all the data from the spreadsheet Sheet1 being retrieved and made availabe though $RVs.

 

Pleasesee vgEngine trace excerpt below for info on what $RV held what value.

 

(the module that we used to do the Excel query was titled "My Get From Spreadcheet")

 

 

 

150316.435 3 3 1 state [My Get From Spreadcheet] DB Query

150316.435 3 3 1 db strDatabaseName=[] strDbConnectString=[Provider=Microsoft.ACE.OLEDB.12.0; data source='C:\Customers\notes\TestData.xls';Extended Properties='Excel 12.0 Xml;HDR=YES';] sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.OracleClient|System.Data.SqlClient|VistaDB.NET20|MySql.Data.MySqlClient|]

150316.435 3 3 1 db using default ado.net OleDb data provider: OleDbConnection/OleDbCommand/etc

150316.435 3 3 1 t timer set 30 sec : EV_TIMEOUT_HANGUP

150316.435 3 3 1 timer set completed lTimeLeft250msUnits=120, iTimeoutCode=9001

150316.435 3 3 1 dir operations failed on []

150316.435 3 3 1 db oledb RunQuery_OleDb My Get From Spreadcheet, , Provider=Microsoft.ACE.OLEDB.12.0; data source='C:\Customers\notes\TestData.xls';Extended Properties='Excel 12.0 Xml;HDR=YES';, select * from [sheet1$]

150316.435 3 3 1 db oledb RunQuery_OleDb blob - none

150316.435 3 3 1 db oledb thread init.

150316.435 3 3 1 db oledb thread started.

150316.435 14 3 1 db oledb ConnectAndRun_OleDb begin. Create connection: [Provider=Microsoft.ACE.OLEDB.12.0; data source='C:\Customers\notes\TestData.xls';Extended Properties='Excel 12.0 Xml;HDR=YES';]

150316.435 3 3 1 qScr run evScriptEvent sCode=[TDX_CST] iActionID=0, crn=1000000a[27778|0|0|0|0][DE_LCON|||||]

150316.435 3 3 1 scriptevent TDX_CST param1:DE_LCON, param2:, param3:

150316.435 3 3 1 LsDbQuery EV_UNKNOWN_134,TDX_CST

150316.435 14 3 1 db oledb connection open call [Provider=Microsoft.ACE.OLEDB.12.0; data source='C:\Customers\notes\TestData.xls';Extended Properties='Excel 12.0 Xml;HDR=YES';]

150316.435 14 3 1 db oledb connection open returned.

150316.435 14 3 1 db oledb m_strSQL=[select * from [sheet1$]]

150316.435 14 3 1 db oledb DataAdapter.Fill init

150316.435 14 3 1 db oledb DataAdapter.Fill call.

150316.435 14 3 1 db oledb DataAdapter.Fill returned.

150316.435 14 3 1 db xmlData=<vgmDBQuery_OleDb> <Table> <Roster_x0020_for_x0020_Monday xml:space="preserve"> </Roster_x0020_for_x0020_Monday> </Table> <Table> <Roster_x0020_for_x0020_Monday xml:space="preserve"> </Roster_x0020_for_x0020_Monday> <F2>10</F2> <_x0020_>11</_x0020_> </Table> <Table> <Roster_x0020_for_x0020_Monday xml:space="preserve"> </Roster_x0020_for_x0020_Monday> <F2>20</F2> <_x0020_>21</_x0020_> </Table> <Table> <Roster_x0020_for_x0020_Monday xml:space="preserve"> </Roster_x0020_for_x0020_Monday> <F2>30</F2> <_x0020_>31</_x0020_> </Table> <Table> <Roster_x0020_for_x0020_Monday xml:space="preserve"> </Roster_x0020_for_x0020_Monday> <F2>40</F2> <_x0020_>41</_x0020_> </Table></vgmDBQuery_OleDb>

150316.435 14 3 1 db read loop iColIdx=0, sBlob_DbColumn=[], strField_Name=[Roster for Monday]

150316.435 14 3 1 rv add [My Get From Spreadcheet_Roster for Monday]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_1]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_Roster for Monday_1]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_1_1]{ }

150316.435 14 3 1 db read loop iColIdx=1, sBlob_DbColumn=[], strField_Name=[F2]

150316.435 14 3 1 rv add [My Get From Spreadcheet_F2]{}

150316.435 14 3 1 rv add [My Get From Spreadcheet_2]{}

150316.435 14 3 1 rv add [My Get From Spreadcheet_F2_1]{}

150316.435 14 3 1 rv add [My Get From Spreadcheet_2_1]{}

150316.435 14 3 1 db read loop iColIdx=2, sBlob_DbColumn=[], strField_Name=[ ]

150316.435 14 3 1 rv add [My Get From Spreadcheet_ ]{}

150316.435 14 3 1 rv add [My Get From Spreadcheet_3]{}

150316.435 14 3 1 rv add [My Get From Spreadcheet_ _1]{}

150316.435 14 3 1 rv add [My Get From Spreadcheet_3_1]{}

150316.435 14 3 1 db read loop iColIdx=0, sBlob_DbColumn=[], strField_Name=[Roster for Monday]

150316.435 14 3 1 rv add [My Get From Spreadcheet_Roster for Monday_2]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_1_2]{ }

150316.435 14 3 1 db read loop iColIdx=1, sBlob_DbColumn=[], strField_Name=[F2]

150316.435 14 3 1 rv add [My Get From Spreadcheet_F2_2]{10}

150316.435 14 3 1 rv add [My Get From Spreadcheet_2_2]{10}

150316.435 14 3 1 db read loop iColIdx=2, sBlob_DbColumn=[], strField_Name=[ ]

150316.435 14 3 1 rv add [My Get From Spreadcheet_ _2]{11}

150316.435 14 3 1 rv add [My Get From Spreadcheet_3_2]{11}

150316.435 14 3 1 db read loop iColIdx=0, sBlob_DbColumn=[], strField_Name=[Roster for Monday]

150316.435 14 3 1 rv add [My Get From Spreadcheet_Roster for Monday_3]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_1_3]{ }

150316.435 14 3 1 db read loop iColIdx=1, sBlob_DbColumn=[], strField_Name=[F2]

150316.435 14 3 1 rv add [My Get From Spreadcheet_F2_3]{20}

150316.435 14 3 1 rv add [My Get From Spreadcheet_2_3]{20}

150316.435 14 3 1 db read loop iColIdx=2, sBlob_DbColumn=[], strField_Name=[ ]

150316.435 14 3 1 rv add [My Get From Spreadcheet_ _3]{21}

150316.435 14 3 1 rv add [My Get From Spreadcheet_3_3]{21}

150316.435 14 3 1 db read loop iColIdx=0, sBlob_DbColumn=[], strField_Name=[Roster for Monday]

150316.435 14 3 1 rv add [My Get From Spreadcheet_Roster for Monday_4]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_1_4]{ }

150316.435 14 3 1 db read loop iColIdx=1, sBlob_DbColumn=[], strField_Name=[F2]

150316.435 14 3 1 rv add [My Get From Spreadcheet_F2_4]{30}

150316.435 14 3 1 rv add [My Get From Spreadcheet_2_4]{30}

150316.435 14 3 1 db read loop iColIdx=2, sBlob_DbColumn=[], strField_Name=[ ]

150316.435 14 3 1 rv add [My Get From Spreadcheet_ _4]{31}

150316.435 14 3 1 rv add [My Get From Spreadcheet_3_4]{31}

150316.435 14 3 1 db read loop iColIdx=0, sBlob_DbColumn=[], strField_Name=[Roster for Monday]

150316.435 14 3 1 rv add [My Get From Spreadcheet_Roster for Monday_5]{ }

150316.435 14 3 1 rv add [My Get From Spreadcheet_1_5]{ }

150316.435 14 3 1 db read loop iColIdx=1, sBlob_DbColumn=[], strField_Name=[F2]

150316.435 14 3 1 rv add [My Get From Spreadcheet_F2_5]{40}

150316.435 14 3 1 rv add [My Get From Spreadcheet_2_5]{40}

150316.435 14 3 1 db read loop iColIdx=2, sBlob_DbColumn=[], strField_Name=[ ]

150316.435 14 3 1 rv add [My Get From Spreadcheet_ _5]{41}

150316.435 14 3 1 rv add [My Get From Spreadcheet_3_5]{41}

150316.435 14 3 1 rv add [My Get From Spreadcheet_RowCount]{5}

150316.435 14 3 1 oVgmDbQuery_AdoNetCommon_Completed SqlQueryType=READER, RowsCount=5, sRv=

150316.435 14 3 1 FindNextVgmTitleInPathList: next module title is=[say Numbers 1]

[Guest notes]

Yes sir its automatically connect to the excel database, but the sounds after i say the number is become echoing voice or

cannot understand sir. Its not clear the voice coming from the phone sir,by the way sir what if the database

i need to use is access,what connnection string i need to use?how about the data source and thank you.

Here is the log traces

 

Attachement:

 

x.zip

[SupportTeam]

Are you now referring to the sound files in the "Play Numbers" module are not clearly audiable?

 

This may be caused by a sound file format mismatch.

 

Please start a new thread about his as this is a different topic/issue.

[Guest notes]

Ok sir thank you, regarding in database how about connection string and data source for MS access2007?

[SupportTeam]

how about connection string and data source for MS access2007

Have you had a look at the sample scripts and at the Help file section covering the Databse Query module?

If you have problems connecting to MS Access 2007 database please create a new thread for that question.