MFC/SQL Server 8 + ODBC problems

hi.  feeling ive not understood fundamental im having issues using crecordset / odbc mfc access data in sql server 8 database.

i open database without problems using dsn sql native client.  opens fine , updateable.  record set out using dynaset flag.  problem occurs.  if use dynaset record not updateable.  if use cursorlib database, doesnt support dynaset anyway.

now, question - should using dynaset anyway?  trying develop multi-user database application.  problem im looking @ have customer records screen.  if 2 users both @ record, both try update record, how stop happening.  best way lock record 1 starts edit it.

i thought using locked field user locking record, run problem of system crashing , leaving record locked perminantly.

ive looked time , time again in books , online cant find answer problem?  dynaset seemed better snapshot can details on updates other users.

 

any information great.

 

thanks

 

adrian

adrian,

 

let’s figure out first why dynaset not updatable. need clarify few things:

1.      does table tblclients have primary key?

2.      if have single client opens dynaset table, dynaset updatable or not?

3.      do pass options crecordset.open()?

4.      do override dofieldexchange() or dobulkfieldexchange()?

if can send me code opens connection, recordset, , tries update, helpful.

 

thanks,

zlatko

SQL Server  >  SQL Server Data Access