Post new topic Reply to topic  [ 8 posts ] 

Board index : TeleFlow Forums : General

Author Message
 Post subject: Connecting to DB
PostPosted: Wed Aug 08, 2012 7:00 am 
Offline

Joined: Fri May 11, 2012 8:09 am
Posts: 19
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?


Back to top
 Profile  
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 9:24 am 
Offline

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


Back to top
 Profile WWW 
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 9:55 am 
Offline

Joined: Fri May 11, 2012 8:09 am
Posts: 19
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.


Back to top
 Profile  
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 10:03 am 
Offline

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


Back to top
 Profile WWW 
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 11:04 am 
Offline

Joined: Fri May 11, 2012 8:09 am
Posts: 19
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


Back to top
 Profile  
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 11:17 am 
Offline

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


Back to top
 Profile WWW 
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 11:48 am 
Offline

Joined: Fri May 11, 2012 8:09 am
Posts: 19
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...


Back to top
 Profile  
 
 Post subject: Re: Connecting to DB
PostPosted: Wed Aug 08, 2012 12:27 pm 
Offline

Joined: Fri May 11, 2012 8:09 am
Posts: 19
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!


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

Board index : TeleFlow Forums : General


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:  
cron
Style by Midnight Phoenix & N.Design Studio
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.