VoiceGuide IVR Software Main Page
Jump to content

"insert Into" Sql Statement Not Working In Msacess Db

Recommended Posts

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.

Share this post


Link to post

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.

Share this post


Link to post
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

Share this post


Link to post

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.

Share this post


Link to post

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?

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
×