TeleFlow Forums http://teleflow.org/phpbb/ |
|
SQL Connection works only with simulator http://teleflow.org/phpbb/viewtopic.php?f=11&t=525 |
Page 1 of 1 |
Author: | j.moghisi [ Thu May 15, 2008 2:45 am ] |
Post subject: | SQL Connection works only with simulator |
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 |
Author: | Chris [ Thu May 15, 2008 9:21 am ] |
Post subject: | Re: SQL Connection works only with simulator |
The most likely cause is that you are using a User DSN, and need to use a System DSN. TeleFlow Simulator is an interface application, and as such is associated with the currently logged in windows user when you run it, which means it can use a User data source. TeleFlow Server is running as a service, and is not associated with a user (or is using a SYSTEM account), so it will only be able to use a System data source. |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |