I am querying a 9.1D progress database via the merant odbc driver. I have the transaction isolation level set to read uncommitted in the data source via the odbc administrator. But if the record is locked via a native progress 4-GL interface, then my odbc query will not return, and seems to wait. I'm not sure what the syntax for setting the transaction level in the sql would be, SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED returns a syntax error even though it says it is supported in the Progress SQL-92 Reference. I'm not sure that would even help. What am I missing?
Any help would be greatly appreciated.
Thanks,
Paul
Any help would be greatly appreciated.
Thanks,
Paul