Bill, I have used a similar strategy. I was kinda curious, would you mind explaining what, why and how you use 1) Type 2) DBMS 3) HostName 4) DBName All I have used are ODBC connections, so maybe I am missing something.
Thanks, Steve Fogelson Internet Commerce Solutions _____ From: William M Conlon [mailto:[EMAIL PROTECTED] Sent: Sat 2/17/2007 12:32 AM To: [email protected] Subject: Re: Witango-Talk: Dynamic Datasources? Yes, although like I said, I edit the file in a text editor, changing the deployment datasource stanza to something like: <DataSource ID="instance$DSNAME.1"> <DSType>@@instance$TYPE</DSType> <DSN>@@instance$DSNAME</DSN> <DBMS>@@domain$DBMS</DBMS> <Host>@@instance$HOSTNAME</Host> <Database>@@instance$DBNAME</Database> <UserInfo Encrypted="False"> <UserName>@@instance$USERNAME</UserName> <Password>@@instance$PASSWORD</Password> </UserInfo> </DataSource> Bill William M. Conlon, P.E., Ph.D. To the Point 2330 Bryant Street Palo Alto, CA 94301 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> web: http://www.tothept.com <http://www.tothept.com/> On Feb 16, 2007, at 8:05 PM, Tom Ferguson wrote: > Thanks for your reply, Bill. > > Forgive me for being ignorant regarding this. I've always just > accepted the > default for datasource deployment. > > So I fill in the type, name, username and password on the right > side of the > Data Source Selection window, using a variable for the name? > > TIA > >> -----Original Message----- >> From: William M Conlon [mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] >> Sent: Friday, February 16, 2007 10:45 >> To: [email protected] >> Subject: Re: Witango-Talk: Dynamic Datasources? >> >> Yes. Use variable names for the Deployment data source. I >> usually add them in the xml using a text editor, because my >> OSX studio crashes always crashes if I touch the datasources. >> >> Bill >> >> William M. Conlon, P.E., Ph.D. >> To the Point >> 2330 Bryant Street >> Palo Alto, CA 94301 >> vox: 650.327.2175 (direct) >> fax: 650.329.8335 >> mobile: 650.906.9929 >> e-mail: mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> web: http://www.tothept.com <http://www.tothept.com/> >> >> >> On Feb 16, 2007, at 7:35 PM, Tom Ferguson wrote: >> >>> If I have several tables with the same layout, is it >> possible to make >>> a .taf that will use dynamic datasources? >>> >>> TIA >>> >>> Thomas Ferguson >>> Vice President >>> Enroll DR, LLC >>> 7115 3rd Street North >>> St. Petersburg, Florida 33702 >>> 727-577-7474 >>> 866-761-6134 FAX >>> >>> www.enrolldr.com >>> >> _____________________________________________________________________ >> _ >>> __ >>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> >>> >> ______________________________________________________________ >> __________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> >> > ______________________________________________________________________ > __ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
<<application/ms-tnef>>
