people i realy dont know why this transaction is read only
i realy dont know what option i must to setup

i'am using www.w3schools.com ado manual,
but reading about connection.execute method i dont find any notes about setting up transactions

here is my simple script

set db = server.createobject("adodb.connection")
db.open "test_1"

sql = "insert into table_1 (col_1) values('nn')"

db.execute sql

db.close
set db = nothing

and executing this script i get error
attempted update during read-only transaction

i think maybe my transaction is read only, but where and what i must to change ????


thanks

what type of DB is it?

my db is Interbase analog - Firebird >1.5

and oDBC drivers i using are jdbcc and odbc for firebird

i'am stil have this problem