VB 6 transactions PULLING HAIR OUT!
Hi
we are developing an application that uses Access links tables with an SQL SERVER 2000 DB
if in a transaction (beginTrans)
and i select then update a table and then select again it fails with an odbc error if i skip over the BeginTrans it is fine
any ideas
Rgds
Roughan
[309 byte] By [
roughan] at [2007-11-20 11:55:06]
# 1 Re: VB 6 transactions PULLING HAIR OUT!
do you are doing CommitTrans?
db.beginTrans
db.execute ".................."
db.CommitTrans
what error message is shown?
# 2 Re: VB 6 transactions PULLING HAIR OUT!
Hi no i have not done a committrans yet
the problem is if i select ,update and select again from the same Table
within a transaction
i Get an ODBC error but its nothing specific
