Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: read from .ini file

    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.

  2. #2
    Join Date
    Dec 2002
    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)?


    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts