YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

RDBMS PI Interface Options · View
Previous Topic · Next Topic
rtkracht
#1 Posted : Wednesday, April 28, 2010 9:38:25 PM
Rank: Newbie
Groups: Member

Joined: 4/28/2010
Posts: 2
Location: Houston, TX
I've been using to the PI RDBMS Interface to write data to MS SQLServer with pretty good success. Unfortunately it seems to lock the tables for viewing unless you use the 'with(NOLOCK) ' option on the select. I've tried a few things suggested by OSI Tech support but without results. Has anyone had similar experiences and found a solution?
thx Rusty
Back to top
 Report Abusive | Report SPAM
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
Back to top  
RJK Solutions
#2 Posted : Wednesday, May 12, 2010 11:23:52 AM
Rank: Administration

Groups: Administration

Joined: 6/20/2008
Posts: 612
Location: Cheshire, United Kingdom.
Hi Rusty,

Where are you placing '(NOLOCK)' in your query? At the end or after each table? It looks like at the end, try placing it after each table in a query....e.g.

Select * from tablename t(NOLOCK) where ....

Another option might be to set the IsolationLevel of the connection.

Principal Consultant
Real-Time Data Management @ Wipro Technologies
Back to top
WWW  Report Abusive | Report SPAM
rtkracht
#3 Posted : Wednesday, May 12, 2010 3:12:00 PM
Rank: Newbie
Groups: Member

Joined: 4/28/2010
Posts: 2
Location: Houston, TX
RJK Solutions wrote:
Hi Rusty,

Another option might be to set the IsolationLevel of the connection.



I'm not familiar with 'IsolationLevel'. Tell me more please.

Rusty
Back to top
 Report Abusive | Report SPAM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF | YAF © 2003-2008, Yet Another Forum.NET