Setting the DefaultIsolationLevel on the OE ODBC Driver - Forum - DataDirect Connect - Progress Community

Setting the DefaultIsolationLevel on the OE ODBC Driver

 Forum

Setting the DefaultIsolationLevel on the OE ODBC Driver

This question is answered

Is there a way to default the DefaultIsolationLevel on the ODBC driver to "READ UNCOMMITTED"? 

At present when you create a User DSN, it defaults to "READ COMMITTED".

Windows, OE 11.7 64 & 32 bit ODBC drivers

Verified Answer
  • Chris, if I am not missing something, Tableau should also use thd ODBC DSN while setting up the connection. This is the Tableau Article which shows how to connect to ODBC Datasources using DSNs.

    onlinehelp.tableau.com/.../examples_otherdatabases.html

    So, if you update the ODBC DSN like Kiley said above and then use that DSN in Tableau, this should be resolved.

    Thanks and Regards,

    Avadhoot Kulkarni
    Lead Principal Software Engineer
    Progress Software Development Private Ltd.
All Replies
  • You can set the Default Isolation Level on the ODBC data source Advanced tab:

    media.datadirect.com/.../

  • Thanks LIbby.  My user is actually using the driver via Tableau (direct connection) and is not using a DSN.  Tableau appears not to have the option to override the connection string (it just asks for the basic info - host, port, user)  so I was hoping to be able to change the default isolation level on the driver itself.

  • Hi - have you tried to set the value via the "Initial SQL" link on Tableau's logon dialog?  I believe you could populate that dialog with something like "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"

    Phil

  • A colleague of mine pointed out that this would cause a conflict between the isolation level as the server sees it, and what the driver would believe it to be; so this "Initial SQL" fix isn't a good idea.

    Apologies,

    Phil

  • Chris, if I am not missing something, Tableau should also use thd ODBC DSN while setting up the connection. This is the Tableau Article which shows how to connect to ODBC Datasources using DSNs.

    onlinehelp.tableau.com/.../examples_otherdatabases.html

    So, if you update the ODBC DSN like Kiley said above and then use that DSN in Tableau, this should be resolved.

    Thanks and Regards,

    Avadhoot Kulkarni
    Lead Principal Software Engineer
    Progress Software Development Private Ltd.
  • Yep tested the DSN option and that works OK, thanks.