hi,
i have a requirement in which i need to read from a .ini file in the stored procedure of sql server 2K.
is it possible? i tried searching on google but i cannot find anything that can help.At the very least you should be able to use the Scripting.FileSystemObject and instantiate it use sp_OACreate (see SQL BOL for details).
However, I'm not sure that this is such a great idea. You're mixing environments (database and operating system) and the results may not be all that you would like them to be. How often is the .ini file going to be updated? Would it be possible to store the .ini values in the db (or even replace the .ini file with a database parameters table)?
Regards,
hmscott
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment