Hi,
We are not sure what we are doing wrong with a Test application we have just made. It does not have any error handling, etc yet. We just wanted to get the DB connection working with a query. It works fine with the simulator, but not when we use the Dialogic telephony card:
Simulator
Code:
2008/05/15 10:26:47.203: ==>test2
2008/05/15 10:26:47.203: [1] START
2008/05/15 10:26:47.203: [3] Wait for Call
2008/05/15 10:26:47.203: TIMEOUT is '0'
2008/05/15 10:26:47.203: WARNING: TIMEOUT '0' evaluates to 0 and is interpreted as no timeout
2008/05/15 10:26:47.203: Rings is '1'
2008/05/15 10:26:47.203: Connection Delay is '500'
2008/05/15 10:26:48.703: Wait for 1 rings and then pickup
2008/05/15 10:26:51.218: Setting global variable '@CALLERID' to ''
2008/05/15 10:26:51.218: Setting global variable '@CALLEDID' to ''
2008/05/15 10:26:51.218: Connection delay: 500 ms
2008/05/15 10:26:51.718: [5] DB Connect
2008/05/15 10:26:51.718: Parameters is 'DSN=telephone;UID=Administrator;Trusted_Connection=Yes;WSID=MARANDYSERVER1;DATABASE=telephone;'
2008/05/15 10:26:51.718: ConnectString: DSN=telephone;UID=Administrator;Trusted_Connection=Yes;WSID=MARANDYSERVER1;DATABASE=telephone;
2008/05/15 10:26:52.515: SQL Error State: 01000
Native Error Code: 1645
ODBC Error: [Microsoft][SQL Native Client][SQL Server]Changed database context to 'telephone'.
2008/05/15 10:26:52.515: SQL Error State: 01000
Native Error Code: 1647
ODBC Error: [Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.
2008/05/15 10:26:52.546: SQL Error State: HY092
Native Error Code: 0
ODBC Error: [Microsoft][SQL Native Client]Invalid attribute/option identifier
2008/05/15 10:26:52.546: [9] SQL Statement
2008/05/15 10:26:52.546: Handle is '1'
2008/05/15 10:26:52.562: Warning time threshold is ''
2008/05/15 10:26:52.562: Empty Warning time threshold defaults to '2000'
2008/05/15 10:26:52.562: <----- BEGIN ----->
SELECT
house, street1, town, pc
FROM
dbo.customer
WHERE
tel = ''
<----- END ----->
2008/05/15 10:26:52.640: Elapsed Time: 0.094
2008/05/15 10:26:52.640: [11] SQL Fetch
2008/05/15 10:26:52.640: Handle is '1'
2008/05/15 10:26:52.640: FAILURE
2008/05/15 10:26:52.640: [43] Beep
2008/05/15 10:26:52.828: [44] Hang Up
2008/05/15 10:26:52.828: Hanging up
2008/05/15 10:26:52.828: [2] FINISH
2008/05/15 10:26:52.843: End of application.
2008/05/15 10:26:55.843:
2008/05/15 10:26:55.843: All memory released. Exiting...
Dialogic
Code:
2008/05/15 09:58:12.421: ==>test2
2008/05/15 09:58:12.421: [1] START
2008/05/15 09:58:12.421: [3] Wait for Call
2008/05/15 09:58:12.421: TIMEOUT is '0'
2008/05/15 09:58:12.421: WARNING: TIMEOUT '0' evaluates to 0 and is interpreted as no timeout
2008/05/15 09:58:12.421: Rings is '1'
2008/05/15 09:58:12.421: Connection Delay is '500'
2008/05/15 09:58:13.921: Wait for 1 rings and then pickup
2008/05/15 09:58:13.968: ERROR: Port not available on SCbus
2008/05/15 09:58:13.968: (106): Invalid Switching Handler Bus Mode
2008/05/15 09:58:13.968: Warning: port's switch status unchanged.
2008/05/15 10:24:11.093: Incoming call...
2008/05/15 10:24:11.093: dx_sethook, lines[curLine].chdev = 4, OFFHOOK
2008/05/15 10:24:11.640: Setting global variable '@CALLERID' to '907738196049'
2008/05/15 10:24:11.640: Setting global variable '@CALLEDID' to ''
2008/05/15 10:24:11.640: Connection delay: 500 ms
2008/05/15 10:24:12.140: [5] DB Connect
2008/05/15 10:24:12.140: Parameters is 'DSN=telephone;UID=Administrator;Trusted_Connection=Yes;WSID=MARANDYSERVER1;DATABASE=telephone;'
2008/05/15 10:24:12.140: ConnectString: DSN=telephone;UID=Administrator;Trusted_Connection=Yes;WSID=MARANDYSERVER1;DATABASE=telephone;
2008/05/15 10:24:12.156: ERROR: Connect: SQLConnect failed.
2008/05/15 10:24:12.187: SQL Error State: IM002
Native Error Code: 0
ODBC Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2008/05/15 10:24:12.187: FAILURE
2008/05/15 10:24:12.187: [43] Beep
2008/05/15 10:24:12.187: Call Status (lps0)
2008/05/15 10:24:12.203: ATDX_HOOKST (4)
2008/05/15 10:24:12.218: Playing audio buffer...
2008/05/15 10:24:12.421: [44] Hang Up
2008/05/15 10:24:13.671: Attempting ag_unlisten, lines[curLine].chdev = 0x4
2008/05/15 10:24:13.671: ag_unlisten - failure
2008/05/15 10:24:13.671: dx_close
2008/05/15 10:24:13.671: ReleaseLine done.
2008/05/15 10:24:13.671: [2] FINISH
2008/05/15 10:24:13.671: End of application.
2008/05/15 10:24:16.671:
2008/05/15 10:24:16.671: All memory released. Exiting...
Any ideas? I am guessing we have done something wrong with the connection string. Thanks
