Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    188

    Unanswered: ODBC Isolation level

    Hello Guys,

    Is there any way I can set up the isolation level on the ODBC settings
    I have a MFC application, it connects to the SQLServer 2000 , but I would like to set up the Isolation level to UR (uncommitted read), is this
    possible ?

    I have tried setting this up by means of the Query analyser but this only work during that session it does not affect any of the others connections to the database.

    My app is a involves heavy OLTP transactions and I am performing a pseudo stress testing..

    thank you for your help

  2. #2
    Join Date
    Sep 2002
    Posts
    5

    Re: ODBC Isolation level

    It is my understanding that this setting is per session. I asked our specialist the same question (dirty reads will do just fine here for our 'brochure' website but the default is read committed?) and was told that this setting was per session. (more later)

  3. #3
    Join Date
    Apr 2002
    Posts
    188

    Re: ODBC Isolation level

    Originally posted by Hollerith
    It is my understanding that this setting is per session. I asked our specialist the same question (dirty reads will do just fine here for our 'brochure' website but the default is read committed?) and was told that this setting was per session. (more later)
    hey thanks for your help, in the same topic
    can you do this

    selec foocolum from footable with (nolock) <-- is this correct

    thanks

    marcos oliva

Posting Permissions

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