| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| how to connect teleflow application to MSSQL Database http://teleflow.org/phpbb/viewtopic.php?f=13&t=948 |
Page 1 of 1 |
| Author: | abdul [ Wed Jan 27, 2010 12:14 pm ] |
| Post subject: | how to connect teleflow application to MSSQL Database |
i am trying to connect a teleflow application to mssql database running on my local machine and i have not been successful in doing so. can any one assist me in this regard. thanks in advance. |
|
| Author: | Chris [ Thu Jan 28, 2010 10:53 am ] |
| Post subject: | Re: how to connect teleflow application to MSSQL Database |
What specific problem/issues are you having? It might help to see the log output for your DB Connect step in order to determine what is amiss. Be sure to change the IP, database name, user/password info in your connect string when providing a clip of the log. Otherwise, here are a couple basics: * Use the DB Connect step * If you are using Windows Authentication, set your connect parameters to a connect string like this(change the IP/database name): DRIVER={SQL Native Client};SERVER=127.0.0.1;DATABASE=testdb;Trusted_Connection=Yes;MARS_Connection=yes * For SQL Server Authentication, set your connect parameters to a connect string like this(change the IP/database name/user/password): DRIVER={SQL Native Client};SERVER=127.0.0.1;DATABASE=testdb;uid=db_user;pwd=db_password;MARS_Connection=yes |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|