Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    50

    Unhappy Unanswered: attempted update during read-only transaction

    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

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    what type of DB is it?
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    May 2003
    Posts
    50

    :( forgoten sorry:(

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •