Can't Connect To Access Database - 3151:ODBC error

[Guest bcool]

Hi!

 

I finally found a voice modem that would allow me to test VoiceGuide...the AOpen FM-56 PX. So far, it's working great using a Skutch AS-4A line simulator.

 

I'm working on a script that will query an Access database, but I'm having trouble connecting to it (see the attached trace log for the message).

 

This is what I have in the script module that is doing the database query:

 

Database or ODBC Data Source: D:\Data\Potential Businesses\Video Rental\IVR rental\VideoVision files\data\Store1.mdb

 

Connect string: PWD=052884 [note: the database has a password on it]

 

SELECT Title FROM Videos limit 1 [to only pull in a sample record for testing]

 

The query fails because it can't connect to the database.

 

Any ideas what I might be doing wrong? Thanks!

0921vgm.txt

[Guest bcool]

A correction to the above...my SELECT statement reads:

 

SELECT Title FROM Videos WHERE Ref='1'

 

...since Access doesn't seem to have a LIMIT command like MySQL.

 

I get the same problem (unable to connect)...

[SupportTeam]

Can the module connect when the database is not password protected?

 

The Help file indicates that the connect string which just supplies the password should begin with a ";", like this:

 

;PWD=mypassword

[Guest bcool]

You are g-o-o-d!!!! Adding the semicolon did the trick!!

 

Thanks!!!