They are parameters used by witango in establishing DSNs, so I make
sure each is assigned a unique variable name, so I can change their
values parametrically if needed. Actually, I use two sets of these
variables, one for SELECTS and the other for CREATE, UPDATE, DELETE
operations. Often the values of each are the same, but it gives me
the opportunity to use database replication, where I read from the
slaves and write to the master.
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]
web: http://www.tothept.com
On Feb 17, 2007, at 7:31 AM, Fogelson, Steve wrote:
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
<mime-attachment>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
