Arthur Fuller
artful at rogers.com
Sat Feb 5 11:13:48 CST 2005
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-server.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