For any action that requires database connectivity, simply set the DataSource to the db you wish. A taf/website doesn't point to any db, it is the actions within the taf that determine which db will be used.
You may use all your datasources in one taf or mix and match. For example, when doing a Direct DBMS, you will be asked for the datasource, pick one and away you go. Changing datasources is easy, just highlight and pick a new source. Additionally, you can do dynamic datasource operations as well. ie, you don't have to specify a database, you could point to a variable that you dynamically set whichever db you wish to use. Brent -----Original Message----- From: Fogelson, Steve <[EMAIL PROTECTED]> To: R:Base User Group (E-mail) <[EMAIL PROTECTED]> Date: Monday, May 06, 2002 9:42 AM Subject: R:Tango Data Base Connection >Hi, Thanks for the recommendations on dropdown list in R:Tango. > >I have a 6 databases on one server placed under folders DBases\Database1, >DBases\Database2, DBases\Database3, etc and 6 different web sites under >folders wwwroot\site1, wwwroot\site2, wwwroot\site3, etc. > >I have each database setup with the ODBC Data Source Administrator under >"System DSN". > >How does each web site know which database to access? I don't see anything >in the .taf files. > >Thanks > >Steve Fogelson >Internet Commerce Solutions > >Example below. > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> ><HTML> ><HEAD> > <TITLE>User Login</TITLE> ></HEAD> ><H2>Please Login</H2> >Enter your User Name and Password to gain access to administer your >Listings!<br><br> ><BODY> ><FORM METHOD="POST" >ACTION="/userlogin.taf?_function=list&_UserReference=330BC5DCFF500E103CD6A9 C >6&_start=1"> ><TABLE BORDER=0> ><TR VALIGN=TOP ALIGN=LEFT> <TD> > User Name: > </TD> > > <TD> > <INPUT NAME="U_User_Name" TYPE=TEXT SIZE=10 MAXLENGTH=10 >VALUE=""> > </TD> ></TR> ><TR VALIGN=TOP ALIGN=LEFT> <TD> > Password: > </TD> > > <TD> > <INPUT NAME="U_Password" TYPE=PASSWORD SIZE=10 MAXLENGTH=10 >VALUE=""> > </TD> ></TR> ></TABLE> ><INPUT TYPE=SUBMIT VALUE="Login"> <INPUT TYPE=RESET VALUE="Reset"> ></FORM> ></BODY> ></HTML> >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
