| HS ODBC set isolation level when reading from ext non oracle db [message #244592] |
Wed, 13 June 2007 08:19  |
jimbojim
Messages: 2
Registered: June 2007
|
Junior Member |
|
|
Oracle 10G
Hello,
I have a database link set up using Heterogeneous Services ODBC.
here are the initodbc.ora details
HS_FDS_CONNECT_INFO = "DSN=ser;DB=myDB;UID=123;PWD=xxxx;HOST=mySRV;PORT=600"
HS_FDS_TRACE_LEVEL = OFF
my tns entry is:
ser =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521))
(CONNECT_DATA=(SID=myser))
(HS=OK)
)
This works fine and I can connect and query off of the remote non oracle db fine. However is there anyway to set the default isolation level to read uncommitted?? Im getting a record lock error occasionally so is it possible to perform a read uncommitted or 'dirty read' on a remote non oracle database via a database link using Heterogeneous Services ODBC.
I know oracle does not support this type of transaction level but is it poosible when reading from a remote non oracle DB??
thanks and appreciate any help!!
Jimbo
|
|
|
|
|
|
|
|
|
|
| Re: HS ODBC set isolation level when reading from ext non oracle db [message #281968 is a reply to message #244592] |
Tue, 20 November 2007 03:27  |
jimbojim
Messages: 2
Registered: June 2007
|
Junior Member |
|
|
There is no way to set or fool oracle into selecting with a uncommitted read even when selecting data from an external database over a DB_LINK
What we did to get around this was to by-pass the odbc driver from oracle to progress all together as any locked columns on the progress side bombed out for us when selecting over the DB_LINK even with us set transaction read only.
We instead used SQLServer as the buffer between ORACLE and Progress. With SQLServer you can set the isolation level to read uncommitted. so we created SQLServer views of progress tables via a SQLServer Linked server and then we select from those views from a DB_Link from oracle to SQLServer.
This seems to be working fine
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
