sql server odbc: Anyone know how to do a dirty read through a linked server? I've got a
linked server to a very busy Informix DB using Informix 3.38 drivers.
John TL Lee

[quoted text, click to view]

John,

What you need is an ODBC Driver that gives you the ability to set
Isolation Levels without writing any ODBC API code (since this would
require you having access to the SQL Server Linked server sources
etc.).

If you use OpenLink Software's ODBC Drivers (Multi-Tier Edition) for
Informix you will be able to resolve this problem by setting an
OpenLink Session Rule that sets the Dirty Read Isolation for any ODBC
connections coming from SQL Server.

This is one of the fundamental differentiators between our ODBC
Drivers and others.

You can download a free evaluation copy of these Drivers from:
http://oplweb2.openlinksw.com:8080/download/

Regards,
Kingsley Idehen

Hi John,

In SQL Server 2000, you may use "SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED" to implement dirty read. For more information, please refer to
topic "SET TRANSACTION ISOLATION LEVEL" in SQL Books Online. However, the
issue seems to be related to informix, you may want to consult Informix
support professionals for the solutions.

Best Regards,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "John TL Lee" <John_t_lee@hp.com>
| Newsgroups: microsoft.public.sqlserver.odbc
| Subject: Linked Server
| Lines: 5
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <4uy_a.2226$WB4.1820@news.cpqcorp.net>
| Date: Wed, 13 Aug 2003 21:56:16 GMT
| NNTP-Posting-Host: 15.28.188.92
| X-Complaints-To: abuse@HP.com
| X-Trace: news.cpqcorp.net 1060811776 15.28.188.92 (Wed, 13 Aug 2003
14:56:16 PDT)
| NNTP-Posting-Date: Wed, 13 Aug 2003 14:56:16 PDT
| Organization: Hewlett-Packard Company
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!nntp-relay.ihug.net!ihug.co.nz!news.compaq.com!news.cpqcorp.net!53ab275
0!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.odbc:39462
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Anyone know how to do a dirty read through a linked server? I've got a
| linked server to a very busy Informix DB using Informix 3.38 drivers.
| John TL Lee
|
|
|

[quoted text, click to view]

You can call an Informix stored procedure via openquery.
Have the stored procedure set isolation level and return a
record set using foreach/with resume. Then call the
stored procedure:

select * from openquery(ifx_svr, 'execute procedure
procname(in1, in2)')

Email me off-line if you need an example.