Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Server & Monitor

Author Message
 Post subject: SQL Connection works only with simulator
PostPosted: Thu May 15, 2008 2:45 am 
Offline

Joined: Wed May 14, 2008 6:00 pm
Posts: 10
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


Back to top
 Profile  
 
 Post subject: Re: SQL Connection works only with simulator
PostPosted: Thu May 15, 2008 9:21 am 
Offline

Joined: Wed Mar 19, 2003 4:28 pm
Posts: 510
Location: Canada
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.


Back to top
 Profile WWW 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Server & Monitor


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Style by Midnight Phoenix & N.Design Studio
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.