ADO Error

[sbind77]

Hi

i m getting this error
when i try to insert a record to a table

My code is very simple
con.BeginTrans
con.Execute(mdebstr)
con.Execute(mschstr)
if err.number=0 then
con.CommitTrans
else
con.RolbackTrans
end if


Err.number - 2147467259

err.description - Cannot create new connection because in manual transaction mode

Pl help me to come out of this problem
Thank You
sbind77

 

[Creeder]

If possible could you post the string that is send in the execute statement?

 

[ToddWW]

I was kind of hoping you would send over the entire page. Since the error is actually being thrown on the con.Open method which we can't see here.

ToddWW