Transactions in VB6 using MSDE 2000

Hi All

I am upgrading a VB6 program from Access 2K to MSDE 2000 RelA

When the program used Access I had set up several ADO transactions

Since upgrading to MSDE I am having strange things happen

e.g
************************
cn.BeginTrans
intrans = True
InvoicesSaved = False
cancel_clicked = False

'get latest invoice number
sql = "select * from [prefers]"
rs.Open sql, cn, adOpenKeyset, adLockReadOnly
If rs.RecordCount <= 0 Or IsNull(rs![last_inv].Value) Then
invnum = 1
Else
invnum = rs![last_inv].Value
End If
rs.Close

'rs used to get 1 of each custcode in daily file
sql = "select distinct [cust_code] from [Daily]"
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

'minimise records returned as only for inserting new data
sql = "Select * from [idetail] where [prod_code] = ''" I get
error here that another connection can't be created as
transaction in progress
rsinvdetail.Open sql, cn, adOpenKeyset, adLockOptimistic
*********************************************
After doing a serious of Database chores under a transaction and after
committing the changes, 2 datacombos begin to behave strangely. The list of
items on 1 disappears and the other one locks up when trying to select an
item

Commenting out the cn.begintrans solves these problems

What is different in MSDE regarding transactions from ADO


Regards
Steve


.

Relevant Pages

  • ADO transaction problems since upgrading from Access2K to MSDE 2K RelA in VB6
    ... When the program used Access I had set up several ADO transactions ... Since upgrading to MSDE I am having strange things happen ... What is different in MSDE regarding transactions from ADO ...
    (microsoft.public.sqlserver.msde)
  • Re: Transactions in Access
    ... But ADO transactions are at Connection-level. ... Microsoft Access MVP ... > The SQLTransaction class are for the .NET framework and ADO.NET. ... > ADO transactions are supported under Access if you are using ADO objects. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Transactions in Access
    ... The SQLTransaction class are for the .NET framework and ADO.NET. ... ADO transactions are supported under Access if you are using ADO objects. ... transactions with the transactions created by Access for the bound form is a ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Transactional Replication breaks when adding articles
    ... Syncing the transactions before the tables is strange, ... expecting a nosync initialization of the tables, which is what I think you ...
    (microsoft.public.sqlserver.replication)
  • Re: Users on MSDE and XP?
    ... I use W2K pro that has a limit of 8 users, i think is the same for WXP pro. ... The MSDE users are not seen by Windows as a users, ... all transactions if the number of concurrent transactions, not users, is ... > I've read that MSDE supports up to 8 concurrent users, ...
    (microsoft.public.sqlserver.msde)