Uncommitted Reads against SQL Server

building semantic layer
11

Hi,

I am trying to do the same at the moment using BO 4.2 against a SQLserver db.

The team we use that manages BO for us created an ODBC connection and added SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED to the connection, however when I get DBA’s to run a SQL trace we do not see the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED being run before the SQL, does the ODBC.sbo file have to be changed ? Unfortunately I cant access the server to make the change and quickly test, I have raise a ticket wait a few days …

What we have done so far is,

  1. Created ODBC source
  2. Created SQL Server connection in universe using ODBC data source.
  3. Select Connection Pool Mode as “Disconnection after each transaction”
  4. Enter “SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED” in the connectInit Parameters
  5. Assign connection to universe.

I got the DBA’s to run a trace but I don’t see the “SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED” in there.

thanks

Rich :uk: (BOB member since 2002-10-04)