"insert Into" Sql Statement Not Working In Msacess Db

[RNagy]

I have been testing this simple SQL to add a single record to a Microsoft Access database table. It is not creating the record.

The Field is called "Pword_entered"

 

 

"INSERT INTO IncomingCalls (Pword_entered) VALUES ('Testpass');"

 

This is an Access 2007 database

 

I am having no problem reading from my access tables with the SQL calls from Voiceguide.

[SupportTeam]

Could you please post a copy of VoiceGuide's Trace Logs which captures the call, this will allow us to see what happened.

 

Enable logging by setting the log levels to 10 in VG.INI as per below:

[Log]

 

VoiceGuide=10

CallLoader=0

VoicemailManager=0

EmailSender=0

ktTel=10

ktTts=0

Then restart VG and make a test call.

 

Trace files will be created in VG's \log\ subdirectory.

 

Please post the traces and the VoiceGuide script used.

 

When posting traces/scripts please .ZIP them up and post them as attachments.

[RNagy]

The latest test was run 06/04/08

[SupportTeam]

No traces were attached to the post.

[RNagy]

Could you please post a copy of VoiceGuide's Trace Logs which captures the call, this will allow us to see what happened.

 

Enable logging by setting the log levels to 10 in VG.INI as per below:

[Log]

 

VoiceGuide=10

CallLoader=0

VoicemailManager=0

EmailSender=0

ktTel=10

ktTts=0

Then restart VG and make a test call.

 

Trace files will be created in VG's \log\ subdirectory.

 

Please post the traces and the VoiceGuide script used.

 

When posting traces/scripts please .ZIP them up and post them as attachments.

0604log.zip

[SupportTeam]

Trace shows:

 

214310.421 12 1 db oledb ConnectAndRun_OleDb begin. Create connection: [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\VoiceGuide\Scripts\Local 50 Answering Machine\CallLog.mdb]

214310.421 12 1 db oledb connection open call [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\VoiceGuide\Scripts\Local 50 Answering Machine\CallLog.mdb]

214310.578 12 1 ERROR v7.0.3068.31216 (Mon 26/05/2008 16:20:32.16) ConnectAndRun_OleDb init : Could not find file 'C:\Program Files\VoiceGuide\Scripts\Local 50 Answering Machine\CallLog.mdb'.

 

Does the file 'C:\Program Files\VoiceGuide\Scripts\Local 50 Answering Machine\CallLog.mdb' exist?

 

Maybe try moving for now to C:\ and use 'C: \CallLog.mdb' as the filename and see if the ADO.NET layer can find the database file.

[RNagy]

I am more familiar with Access 2003. I changed the format of the database to Access 2003 and the SQL call worked. Do you know if Access 2007 DB requires a connect string? Or is their some setting in Access 2007 I need to update?

[SupportTeam]

You should try specifying the connection string. I thought for Access it should look something like this:

 

Microsoft Access Driver (*.mdb)};Dbq=c:\somepath\mydb.mdb;

 

Also see:

 

http://www.webcheatsheet.com/asp/access_co...ion_strings.php

http://www.carlprothman.net/Default.aspx?t...ManagedProvider

http://www.connectionstrings.com/