VB4.0 and SQL SERVER using ADO for access to database.

[Daniel Silva Carnevalli]

Hi,

I have one declaration in my program that following:


dConexao.Execute "Begin Transaction", lRegistros, 1

dConexao.Execute sSql$, lRegistros, 1

dConexao.Execute "Commit Transaction", lRegistros, 1


I am using VB4.0 to use Database (MSSQL) with ADO.

When I execute the program, I receive that following message:


Run-time error '-2147467259 (80004005)':

[Microsoft][ODBC SQL Server Driver][SQL Server]the commit

transaction request has no corresponding BEGIN TRANSACTION.


Please help me. Thanks in advance.

Looking forward to hearing from you.

Daniel.