Access Db Interaction

[Guest Guest_hecuba007]

Help is needed with the following:

Why doesn't the database open?

Is there a setting missing in the configuration?

 

screen configuration shots and transcript follow:

 

131453.92 7 linedevstate 2048 0 0

131453.92 7 callstate OFFERING 66458 0 4

131453.92 7 Answer the call at 9/2/2004 1:14:53 PM

131453.92 7 lineAnswer(66458) => 66407

131453.94 7 callinfo CALLEDID

131453.94 7 callinfo ORIGIN

131453.94 7 ring 0

131454.47 7 callstate CONNECTED 66458 1 0

131454.47 7 callstate CONNECTED 66458,1,0

131454.47 7 WorkingModeTAPI@Connected=

131454.47 7 WorkingModeScript@Connected=

131454.48 7 Inband detection not enabled

131454.48 7 StartLoadedVgs at 9/2/2004 1:14:54 PM

131454.48 7 AddRVns [scriptsPath]{F:\DiaLogic IVR\VoiceGuide5.2.3\Scripts\tests\}

131454.48 7 AddRVns [scriptPath]{F:\DiaLogic IVR\VoiceGuide5.2.3\Scripts\tests}

131454.48 7 rv add [$RV_STARTTIME]{9/2/2004 1:14:54 PM}

131454.48 7 rv add [$RV_DEVICEID]{7}

131454.48 7 rv add [$RV_CIDNAME]{}

131454.48 7 AddRVns [PathApp]{F:\DiaLogic IVR\VoiceGuide5.2.3\}

131454.48 7 rv add [$RV_CIDNUMBER]{}

131454.48 7 tapi Reply (LineEvReply) ok 66407 0

131454.48 7 callinfo MONITORMODES

131454.48 7 timer clear

131454.48 7 [PinQuery] DB Query

131454.48 7 db ODBC mode used

131454.50 7 ERROR 5.2.3018 OpenDatabase [3146:ODBC--call failed.]

131454.50 7 path {0} not found

131454.50 7 path {} not found

[SupportTeam]

If you want to connect via ODBC interface then you need to specify the Datasource name - not the filename.

 

With Access databases it is easiest to just specify the filename and leave the 'Connect String' blank.

[Guest Guest]

Thank you for replying but I don't understand the nomenclature.

 

the data source name was set to "KRS IVG"

the database file is "krs.mdb" in "F:\KRS"

 

the database has 2 table one of which is called ""Subscribers"

 

What is a "data source name"?

[SupportTeam]

In the VoiceGuide module change the text box where you have specified the file to be:

 

KRS IVG

 

or alternatively leave the path/filename as is and just make the "ODBC Connect String" text box blank.

 

Look at the examples from the VG Help file: http://www.voiceguide.com/vghelp/html/modDbQuery.htm