ASP web queries locking tables Vantage 6.1

Yahoo Archive
1
Here is the code I use in a Vb DLL for an Excel macro. I am using DAO
3.6 as a reference.

Dim strConnect As String

strConnect = "ODBC;UID=sysprogress;PWD=sysprogress"
Set dbProgress = OpenDatabase("Mfgsys61", False, True, strConnect)

The TRUE part ensures that I am in Read-Only Mode. Then, to get the
records from the Database, I use this code:

Private rsExtractedData As Recordset
Set rsExtractedData = dbProgress.OpenRecordset(strSQL,
dbOpenSnapshot, dbReadOnly)

A snapshot is a read-only recordset. This ensures that I am getting the
records in a read-only fashion.


Andrew Reed

Office Automation Specialist
Crestview Aerospace Corporation



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of rybermail
Sent: Tuesday, April 25, 2006 1:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ASP web queries locking tables Vantage 6.1


--- In vantage@yahoogroups.com, "Robert MacDonald" <rmacdonald@...>
wrote:
>
> Hi Group,
>
> We have web reports accessing Vantage 6.1, and they appear to be
temporarily
> locking access to tables.
>
> These are basic ASP web pages using the following statement to
access the
> database;
>
> DbaseConn.Open "dsn=Mfgsys61;uid=odbcuser;pwd=odbcuser"
>
>
>
> Is there a way to stop the queries from locking the tables?
>
> Thanks,
>
> Robert MacDonald
>
> Information Technology Manager
>
> Ground Effects Ltd.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Robert,
Make sure you have the default isolation level set correctly in the
advanced tab of the DSN you are using, it should be set to READ
COMMITED, this tells the driver to only look at records that are not
open / being edited by another user. You might also try adding it to
the connection string. It would look something like ";DIL=READ
COMMITED" added to the end. Not sure if the second option would work
though.





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/links



________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


________________________________




[Non-text portions of this message have been removed]
2
Hi Group,

We have web reports accessing Vantage 6.1, and they appear to be temporarily
locking access to tables.

These are basic ASP web pages using the following statement to access the
database;

DbaseConn.Open "dsn=Mfgsys61;uid=odbcuser;pwd=odbcuser"



Is there a way to stop the queries from locking the tables?

Thanks,

Robert MacDonald

Information Technology Manager

Ground Effects Ltd.





[Non-text portions of this message have been removed]
3
--- In vantage@yahoogroups.com, "Robert MacDonald" <rmacdonald@...>
wrote:
>
> Hi Group,
>
> We have web reports accessing Vantage 6.1, and they appear to be
temporarily
> locking access to tables.
>
> These are basic ASP web pages using the following statement to
access the
> database;
>
> DbaseConn.Open "dsn=Mfgsys61;uid=odbcuser;pwd=odbcuser"
>
>
>
> Is there a way to stop the queries from locking the tables?
>
> Thanks,
>
> Robert MacDonald
>
> Information Technology Manager
>
> Ground Effects Ltd.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Robert,
Make sure you have the default isolation level set correctly in the
advanced tab of the DSN you are using, it should be set to READ
COMMITED, this tells the driver to only look at records that are not
open / being edited by another user. You might also try adding it to
the connection string. It would look something like ";DIL=READ
COMMITED" added to the end. Not sure if the second option would work
though.