Access (Mdb) File

[mja2112]

HI All:

I'm trying out voiceguide on behalf of a customer who will purchase it if I can get it to work. I have an access db (mdb) file I need to query. I set up a data source and can connect and run queries from a utility I use for db testing so I know the db is good and the data I expect to see is there and the data source is working. When I try to connect using voiceguide all queries fail (on data I know is there).

I'm using the following connect string: ODBC;DSN=members;DBQ=C:\web_benefits.mdb

I've tried stripping the query to a very basic one: select * from main_table where area_code='505';

 

I've attached the log files; I'm hoping someone can point me in the right direction I just don't see why it is failing.

 

Thanks!

 

 

0206_CallEvents.txt

0206_ktTel.txt

0206_ktTts.txt

[SupportTeam]

To read local Microsoft Access databases the simplest approach is to use Microsoft's OLEDB Data Provider.

 

It will look something like this:

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\web_benefits.mdb;

 

or

 

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\web_benefits.mdb;

 

 

no need to setup ODBC for local MS Access files.

 

If you still have problems then could you please post the vgEngine trace. The database interactions woudl be logged in the vgEngine trace.

 

Please .ZIP up traces before posting.