Re: 0x800a0cb3 when Update record

On Wed, 15 Oct 2008 10:54:45 -0400, Bob Barrows [MVP] wrote:

Anders Eriksson wrote:
Hello all,

By coincident I changed the cursor type from adUseServer to
asUseClient and then the update worked!

But AFIK transactions only work when using adUseServer, or?

If someone can explain why I get a ReadOnly recordset when using
adUseServer, but not on asUseClient I would be very grateful!


For one thing, a text file does not have a server to manage cursors ...

I don't get your answer?

I'm using a Microsoft 2000 SQL Server (MSDE for testing, the real thing
otherwise)

My connection string is:

Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User
ID=test1;Initial Catalog=skyltdata;Data Source=AME1\MESQL;Extended
Properties="ByteaAsLongVarBinary=1;"

Where have I defined that I'm using a text file?

// Anders
--
English is not my first, or second, language
so anything strange, or insulting, is due to
the translation.
Please correct me so I may improve my English!
.

Relevant Pages

  • Re: 0x800a0cb3 when Update record
    ... By coincident I changed the cursor type from adUseServer to ... But AFIK transactions only work when using adUseServer, ... but not on asUseClient I would be very grateful! ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: 0x800a0cb3 when Update record
    ... But AFIK transactions only work when using adUseServer, ... but not on asUseClient I would be very grateful! ... Please correct me so I may improve my English! ...
    (microsoft.public.data.ado)
Loading