I try to test the SQL plugin. I use a Access database. When I use the simulator its work fine BUT when I call via SIP the SQL plugin return a wrong result. Please take a look at the logfile. Would you please help me geting out of this problem.
18:42:35 Ringing on Line Simulator detected. Waiting until ring number 2.
18:42:35 Simulator 5555555555 [Answered]
18:42:35 Answered line [1000 "Simulator Line"] call number [216] cid [5555555555] did[simulator] drn[0 (0ms)]
18:42:35 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\ny start.wav
18:42:42 Caller pressed key [1]
18:42:43 Caller pressed key [1]
18:42:44 Caller pressed key [1]
18:42:45 Caller pressed key [1]
18:42:46 Caller pressed key [1]
18:42:47 Caller pressed key [1]
18:42:48 Caller pressed key [1]
18:42:49 Caller pressed key [1]
18:42:50 Caller pressed key [#]
18:42:50 Variable number = 11111111
18:42:50 Command - Go
18:42:50 Open OGM: start
18:42:50 Run plugin: "C:\ProgramData\NCH Swift Sound\IVM\SQLLink.exe" "telefon" "SELECT * FROM tlf WHERE kode='11111111'"
18:42:50 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\start.wav
18:42:51 Plugin returned: Rowcount=-1&Result=Okay&id=1&kode=11111111©right=NCH Swift Sound
18:42:53 Command - Go
18:42:53 Open OGM: valg1Okay
18:42:53 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\valg1Okay.wav
18:42:53 followed by read number: number
18:42:56 Call disconnected
18:42:58 Call disconnected
-------------------------------------------------------------------------------------------------------------------------
18:43:34 Incoming SIP call
18:43:36 Ringing on Line 88917091 detected. Waiting until ring number 2.
18:43:36 viptel 46730888 [Answered]
18:43:36 Answering call...
18:43:37 Answered line [1 "viptel"] call number [217] cid [46730888] did[88917091] drn[0 (0ms)]
18:43:37 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\ny start.wav
18:43:44 Caller pressed key [1]
18:43:45 Caller pressed key [1]
18:43:47 Caller pressed key [1]
18:43:48 Caller pressed key [1]
18:43:49 Caller pressed key [1]
18:43:50 Caller pressed key [1]
18:43:51 Caller pressed key [1]
18:43:52 Caller pressed key [1]
18:43:54 Caller pressed key [#]
18:43:54 Variable number = 11111111
18:43:54 Command - Go
18:43:54 Open OGM: start
18:43:54 Run plugin: "C:\ProgramData\NCH Swift Sound\IVM\SQLLink.exe" "telefon" "SELECT * FROM tlf WHERE kode='11111111'"
18:43:54 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\start.wav
18:43:54 Plugin returned: Result=Error©right=NCH Swift Sound
18:43:55 Command - Go
18:43:55 Open OGM: valg1Error
18:43:55 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\valg1Error.wav
18:43:55 Command - Polite Hangup
18:43:55 Play system prompt: GoodBye
18:43:59 Call has disconnected
18:43:59 Call disconnected