Setting Read Uncommitted in ODBC connection to Progress

Yahoo Archive
1
Thank you, Ned and Manasa. I think I'm all set now.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Friday, January 22, 2010 12:36 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Setting Read Uncommitted in ODBC connection to Progress



Also, these are 2 helpful references for Progress ODBC in regards to
Crystal, as well as DataDirect ODBC in general, thay are 5 or so years old,
but the general methods haven't changed much.

http://www.nedderweb.com/download/OE10ODBC4CRYSTAL.PDF (64 pages)and
http://www.nedderweb.com/download/odbcref.pdf (703 Pages)

The second one covers a ton of different stuff, but can be a pretty good
reference document.

----- Original Message -----
From: "Thomas Rose" <t.rose@...<mailto:t.rose%40electricmirror.com>>
To: <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Friday, January 22, 2010 2:15 PM
Subject: [Vantage] Setting Read Uncommitted in ODBC connection to Progress

> Okay, so I understand I need to set the isolation level to READ
> UNCOMMITTED when I do an ODBC connection to the Progress database. My
> question is, how exactly do I set that isolation level? Is it part of the
> connection string, and, if so what is the syntax? For example, here is a
> connection string I use. How should I modify it to ensure I access the DB
> as read uncommitted?
>
> DSN=Progress10B;UID=SYSPROGRESS;PWD=sysprogress;HOST=db1;PORT=8350;DB=mfgsys
>
> If it is not part of the connection string, is it part of the DSN file,
> and how would I go about modifying that?
>
> Or does it go somewhere else, and how would I set that up?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>



[Non-text portions of this message have been removed]
2
Okay, so I understand I need to set the isolation level to READ UNCOMMITTED when I do an ODBC connection to the Progress database. My question is, how exactly do I set that isolation level? Is it part of the connection string, and, if so what is the syntax? For example, here is a connection string I use. How should I modify it to ensure I access the DB as read uncommitted?

DSN=Progress10B;UID=SYSPROGRESS;PWD=sysprogress;HOST=db1;PORT=8350;DB=mfgsys

If it is not part of the connection string, is it part of the DSN file, and how would I go about modifying that?

Or does it go somewhere else, and how would I set that up?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


[Non-text portions of this message have been removed]
3
WHERE are you setting this connection string? I only ask because I set
it up differently and it works for me.



I go to control panel (on the client computer) --> Admin Tools --> Data
Sources (ODBC) and I set it up there. Here I Add a new System DSN and
through that configuration you would set up the Read Uncommitted under
the Advanced Tab.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Friday, January 22, 2010 1:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Setting Read Uncommitted in ODBC connection to
Progress





Okay, so I understand I need to set the isolation level to READ
UNCOMMITTED when I do an ODBC connection to the Progress database. My
question is, how exactly do I set that isolation level? Is it part of
the connection string, and, if so what is the syntax? For example, here
is a connection string I use. How should I modify it to ensure I access
the DB as read uncommitted?

DSN=Progress10B;UID=SYSPROGRESS;PWD=sysprogress;HOST=db1;PORT=8350;DB=mf
gsys

If it is not part of the connection string, is it part of the DSN file,
and how would I go about modifying that?

Or does it go somewhere else, and how would I set that up?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com> >

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
If you want to set it up in the DSN, it should be setup like this:

http://www.nedderweb.com/download/ProgressODBC.jpg

and I THINK this is what your connection string should look like.

DSN=Progress10B;UID=SYSPROGRESS;PWD=sysprogress;HOST=db1;PORT=8350;DB=mfgsys;DIL=0

DIL being short for Default Isolation level, with Read_Uncommitted as 0

1 would be READ_COMMITTED, 2 REPEATABLE_READ, 3 SERIALIZABLE, 4 NONE

If the number doesn't work then you can also try DIL=READ_UNCOMMITTED



----- Original Message -----
From: "Thomas Rose" <t.rose@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 22, 2010 2:15 PM
Subject: [Vantage] Setting Read Uncommitted in ODBC connection to Progress


> Okay, so I understand I need to set the isolation level to READ
> UNCOMMITTED when I do an ODBC connection to the Progress database. My
> question is, how exactly do I set that isolation level? Is it part of the
> connection string, and, if so what is the syntax? For example, here is a
> connection string I use. How should I modify it to ensure I access the DB
> as read uncommitted?
>
> DSN=Progress10B;UID=SYSPROGRESS;PWD=sysprogress;HOST=db1;PORT=8350;DB=mfgsys
>
> If it is not part of the connection string, is it part of the DSN file,
> and how would I go about modifying that?
>
> Or does it go somewhere else, and how would I set that up?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
5
Also, these are 2 helpful references for Progress ODBC in regards to
Crystal, as well as DataDirect ODBC in general, thay are 5 or so years old,
but the general methods haven't changed much.

http://www.nedderweb.com/download/OE10ODBC4CRYSTAL.PDF (64 pages)and
http://www.nedderweb.com/download/odbcref.pdf (703 Pages)

The second one covers a ton of different stuff, but can be a pretty good
reference document.

----- Original Message -----
From: "Thomas Rose" <t.rose@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 22, 2010 2:15 PM
Subject: [Vantage] Setting Read Uncommitted in ODBC connection to Progress


> Okay, so I understand I need to set the isolation level to READ
> UNCOMMITTED when I do an ODBC connection to the Progress database. My
> question is, how exactly do I set that isolation level? Is it part of the
> connection string, and, if so what is the syntax? For example, here is a
> connection string I use. How should I modify it to ensure I access the DB
> as read uncommitted?
>
> DSN=Progress10B;UID=SYSPROGRESS;PWD=sysprogress;HOST=db1;PORT=8350;DB=mfgsys
>
> If it is not part of the connection string, is it part of the DSN file,
> and how would I go about modifying that?
>
> Or does it go somewhere else, and how would I set that up?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>