2 Replies Latest reply on Apr 27, 2002 11:41 PM by 82532

    ole seem to ignore client nls settings

    37476
      Dear experts,

      my dataserver has nls_parameters for american.

      my webserver has nls_parameters set for protuguese.

      alas my queries keep returning my dates is american format (MM/DD/YYYY) and not the brazilian DD/MM/YYYY.

      my sql*plus works fine (that is it adapts its dates to my regestry settings)

      what could be the problem?

      Even when I first do a executeSQL("alter session set nls_date_format = 'DD/MM/YYYY'") and the execute my wuery, asp still shows me the american format...

      If anyone could help me out...