[dba-SQLServer] XML setting files

Andy Lacey andy at minstersystems.co.uk
Sun Feb 6 16:51:02 CST 2005


>I've got 4 alligators left to kill.

???????????????????????????

-- Andy Lacey
http://www.minstersystems.co.uk 



> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Arthur Fuller
> Sent: 05 February 2005 17:14
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] XML setting files
> 
> 
> Thanks for the plug, Francisco. But there's NO chance I'll get to the 
> thread before about Tuesday. I've got 4 alligators left to kill.
> 
> Francisco Tapia wrote:
> 
> >Nancy this topic is right "on-topic" what your boss is 
> describing is a 
> >specific attribute to your .exe application.  (re: the settings 
> >filename).
> >
> >This is a good article on reading xml data right out of a sql server 
> >... the author (Arthur) also will muse over the threads on 
> this list...
> >
> >http://artfulramblings.blogspot.com/2004/10/reading-xml-data-
> from-sql-s
> >erver.html
> >
> >
> >On Fri, 4 Feb 2005 12:57:47 -0800, Charlotte Foust 
> ><cfoust at infostatsystems.com> wrote:
> >  
> >
> >>An XML file is a text file and you can read it with any 
> text editor.  
> >>It has nothing whatsoever to do with any XML "software" 
> unless you've 
> >>written software to look for that file name.  If the application 
> >>software is in .Net, it may be using typed datasets based on a file 
> >>named Settings.xml and/or it may contain a class to manipulate that 
> >>xml file.
> >>
> >>We import and export xml files with different names and we store 
> >>settings in xml files with specific names.  We also use xml 
> files to 
> >>store lookup values that are not part of the back end data. 
>  None of 
> >>them is named Settings.xml but we do have to program for 
> specific xml 
> >>file names.
> >>
> >>Charlotte Foust
> >>
> >>
> >>-----Original Message-----
> >>From: worddiva [mailto:nancy.lytle at gmail.com]
> >>Sent: Friday, February 04, 2005 12:49 PM
> >>To: dba-sqlserver at databaseadvisors.com
> >>Subject: [dba-SQLServer] XML setting files
> >>
> >>I know this is a little off topic but we do use SQL Server with XML 
> >>and I know next to nothing about XML, but I have been tasked with 
> >>going into some settings files and adding the application 
> name to the 
> >>connection string, and replacing the in line SQL with a stored 
> >>procedure. All of the files are named 'settings.xml'  no 
> matter what 
> >>they are used for or in, it is always settings.  I 
> suggested we might 
> >>want to change the file name to something more descriptive than 
> >>settings, but my boss says that the file must be named 
> 'settings.xml'.  
> >>Is that true?  Or is it that if we rename the file, we must also 
> >>rename in the application .exe? My supervisor stated "The settings 
> >>file is use as input into the XML process, it works kind 
> like the .ini 
> >>file.  However the XML software looks for a file name settings.xml" 
> >>Already I have run across a situation in SourceSafe where a 
> settings 
> >>file was listed under the wrong process, which is what I think we 
> >>should be trying to prevent.
> >>
> >>Thanks in advance,
> >>Nancy
> >>_______________________________________________
> >>dba-SQLServer mailing list
> >>dba-SQLServer at databaseadvisors.com
> >>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >>http://www.databaseadvisors.com
> >>
> >>_______________________________________________
> >>dba-SQLServer mailing list
> >>dba-SQLServer at databaseadvisors.com
> >>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >>http://www.databaseadvisors.com
> >>
> >>
> >>    
> >>
> >
> >
> >  
> >
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 




More information about the dba-SQLServer mailing list