RE: witango-talk: Making a database dynamic

[Simon Boddy]

Hi Gerard,   AFAIK, creating an odbc datasource for each database is unavoidable. What you can do is make your datasource connection parameters variables. Right click on any of the database actions, choose 'set data source'. The right hand side of the dialogue lets you set the deployment data source. Uncheck 'Same as development', choose your data source type from the dropdown and specify the variables you want to use for data source name, username and password. To change all the database actions in a taf file at one time, ctrl-A to select all, then right click 'Set data source'.   So what variables are you going to use? The most common solution would be to have dsName, dsUsername dsPassword as application scoped variables, but scoping them as domain or user may also make sense depending on your situation.   This road does have a downside. You have to take your own measures to secure the ds parameters. Depending on your situation, it might not be great to have the ds password sitting in a plain text file on your web server. You may also need to add code to the start of every taf to verify the ds variables are present.   Good luck. Simon -----Original Message----- From: Gerard Bohbot [mailto:[EMAIL PROTECTED] Sent: 23 September 2003 20:06 To: [EMAIL PROTECTED] Subject: witango-talk: Making a database dynamic Hi,   I was wondering what the process is for making a database dynamic.   Situation:   Using Tango 2000 and Pervasive SQL.   Many identical web sites, residing on the same server, have an identical DB, with the same reference name in Tango, with different personal information & options stored in the DB.   How do I set it up so that depending on who's site it is, it will reference the correct DB for information without having to set up an ODBC for each.  I believe that what I want is for the taf information to be identical, but the reference to the DB to be set to a relative path.  Unfortunately, I don't know how to do this.   Thanks, Gerard ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ******************************************************************** This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board). Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems. ******************************************************************** ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf