TeleFlow Forums http://teleflow.org/phpbb/ |
|
Connecting to DB http://teleflow.org/phpbb/viewtopic.php?f=1&t=1031 |
Page 1 of 1 |
Author: | Greesemonkey3 [ Wed Aug 08, 2012 7:00 am ] |
Post subject: | Connecting to DB |
So I have been able to connect to our SQL server find when designing and testing our application on the simulator. Now that I am actually calling in I can't set up a connection. I have tried to set it up using TFADOConnect app but I can't figure it out. I created a new connection string and tested it and it connects. I have I have created the reg key, but I am not exactly sure how to "fill out the form". What do I need to do if I don't just have one master table, I call about 4 different tables. Is there something simple with it that I am missing? |
Author: | Chris [ Wed Aug 08, 2012 9:24 am ] |
Post subject: | Re: Connecting to DB |
All you need to connect in your TeleFlow application is a DB Connect step (TFADOConnect.exe is just a simple tool to assist with building and testing ADO connection strings, which really isn't what you're looking for) Use one of the two following connection strings (substitute the appropriate server/user/etc), depending on whether you want to supply the user/pwd to use SQL Server authentication, or if you want to use trusted connections (Windows Authentication). SQL Server ODBC Connection String: Driver={SQL Server};Server=myservername;Database=mydemodb;Uid=myusername;Pwd=mypasswd; SQL Server ODBC Connection String - Trusted Connection: Driver={SQL Server};Server=mysername;Database=mydemodb;Trusted_Connection=yes; NOTE: You may need to substitute a different driver name in place of "SQL Server". Run the "ODBC Data Source Administrator", click "Add", then check which SQL Server drivers are available. "SQL Server" may work fine, although you might find it worthwhile to download the SQL Server Native Client driver, depending on just how much database interaction your application has. If you still can't get the database connection to work, capture a log of a line that is failing on the DB Connect, find/replace all "secret" information in your log, then copy/paste just the failing DB Connect step log output into this thread. |
Author: | Greesemonkey3 [ Wed Aug 08, 2012 9:55 am ] |
Post subject: | Re: Connecting to DB |
I tried the new string and it still won't connect. The new string worked fine in the simulator but not the actual calling. Here is my connection string: Driver={SQL SERVER};Server=***DB03;Database=*****;UID=*******;PWD=*****; Here is my log from the monitor: 2012/08/08 12:46:21.460: Initialization done 2012/08/08 12:46:21.460: ==>PointUnblinding 2012/08/08 12:46:21.460: [1] START 2012/08/08 12:46:21.460: [155] Wait for Call 2012/08/08 12:46:21.460: TIMEOUT is '' 2012/08/08 12:46:21.460: Empty TIMEOUT defaults to none 2012/08/08 12:46:21.460: Rings is '2' 2012/08/08 12:46:21.460: Connection Delay is '500' 2012/08/08 12:46:22.960: Wait for 2 rings and then pickup 2012/08/08 12:46:22.974: Port not available on SCbus It plays my welcome message but when it trys to connect to the database it runs my error message.... This was my old connection string: DSN=***DB03;UID=******;PWD=****** this one also worked in the simulator but not the actual call. |
Author: | Chris [ Wed Aug 08, 2012 10:03 am ] |
Post subject: | Re: Connecting to DB |
What's the error in the log for the DB Connect step? Could you include the DB Connect section of the log, and blank out the secret bits as you did for the connect string? |
Author: | Greesemonkey3 [ Wed Aug 08, 2012 11:04 am ] |
Post subject: | Re: Connecting to DB |
Is this what your looking for? [43] Play 2012/08/08 14:02:26.420: Script code is 'welcome' 2012/08/08 14:02:26.420: Script code 'welcome' corresponds to file 'C:\Users\admin\Desktop\IVR\AudioFiles\ctmsTreatment\welcome.vox' 2012/08/08 14:02:26.420: Playing 'C:\Users\admin\Desktop\IVR\AudioFiles\ctmsTreatment\welcome.vox' 2012/08/08 14:02:26.421: Call Status (lps0) 2012/08/08 14:02:26.421: ATDX_HOOKST (1) 2012/08/08 14:02:26.421: Call Status (lps0) 2012/08/08 14:02:26.421: ATDX_HOOKST (1) 2012/08/08 14:02:26.425: Call Status (lps0) 2012/08/08 14:02:26.425: ATDX_HOOKST (1) 2012/08/08 14:02:30.740: [4] DB Connect 2012/08/08 14:02:30.740: Connect Parameters is 'DSN=***;UID=***;PWD=***' 2012/08/08 14:02:30.740: Connect String: DSN=***3;UID=***;PWD=*** 2012/08/08 14:02:30.740: Connection Handle is '' 2012/08/08 14:02:30.740: Using default ODBC handle 2012/08/08 14:02:30.740: ERROR: Connect: SQLConnect failed. 2012/08/08 14:02:30.740: SQL Error State: IM002 Native Error Code: 0 ODBC Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2012/08/08 14:02:30.741: FAILURE 2012/08/08 14:02:30.741: [45] Play 2012/08/08 14:02:30.741: Script code is 'dberror' 2012/08/08 14:02:30.741: Script code 'dberror' corresponds to file '\Users\admin\Desktop\IVR\AudioFiles\Point\dberror.vox' 2012/08/08 14:02:30.741: Playing 'C:\Users\admin\Desktop\IVR\AudioFiles\Point\dberror.vox' 2012/08/08 14:02:30.741: Call Status (lps0) 2012/08/08 14:02:30.741: ATDX_HOOKST (1) 2012/08/08 14:02:30.741: Call Status (lps0) 2012/08/08 14:02:30.741: ATDX_HOOKST (1) 2012/08/08 14:02:30.745: Call Status (lps0) 2012/08/08 14:02:30.745: ATDX_HOOKST (1) 2012/08/08 14:02:34.344: Attempting ag_unlisten, lines[curLine].chdev = 0x1 2012/08/08 14:02:34.344: ag_unlisten - failure 2012/08/08 14:02:34.347: dx_close 2012/08/08 14:02:34.348: ReleaseLine done. 2012/08/08 14:02:34.348: HANGUP |
Author: | Chris [ Wed Aug 08, 2012 11:17 am ] |
Post subject: | Re: Connecting to DB |
The log clip of the DB Connect doesn't match the connection string I suggested. (If it did, the "Connect String" in the log output would show the Driver= and Server= parts, and would not have a DSN=) Quote: [4] DB Connect 2012/08/08 14:02:30.740: Connect Parameters is 'DSN=***;UID=***;PWD=***' 2012/08/08 14:02:30.740: Connect String: DSN=***3;UID=***;PWD=*** You want to actually replace the contents of the DB Connect step with something like: Quote: Driver={SQL SERVER};Server=***3;Database=*****;UID=*******;PWD=*****;
|
Author: | Greesemonkey3 [ Wed Aug 08, 2012 11:48 am ] |
Post subject: | Re: Connecting to DB |
YEAH!!!!! it works. I entered it but it didn't work at first so I restarted the server and monitor and it worked!!!!!! Now I just have one more question. Once I get the information I insert into the database and send an email with the information. During this time all I hear is a terrible scratching noise for like 10-15 seconds. It works fine after the noise. Also it never took this long/made the noise in the simulator... |
Author: | Greesemonkey3 [ Wed Aug 08, 2012 12:27 pm ] |
Post subject: | Re: Connecting to DB |
Actually it might be one file that is acting up. I'm trying to redo it but supposedly it is going to take hours to redo..(website is messing up) Thanks for the help and if this doesn't fix it I''ll post again tomorrow! |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |