Programming on SQL Server 7 with VB(using ADO)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Programming on SQL Server 7 with VB(using ADO)

  1. #1
    Addisu Mulat Guest

    Programming on SQL Server 7 with VB(using ADO)


    I have just started programming on SQL Server 7 with VB(using ADO). What
    I have encountered is strange for me, its like this, I have programmed the
    database (for multiuser environment) by making the lock type of the recordset
    adLockPessimistic, I wanted the user to view changes if he wanted to by explicitly
    refreshing the data himself but what happened is the changes made by user
    user1 on one terminal is viewed by another user user2 on another terminal
    without user2 explicitly refreshing the data. This happens for tables with
    primary key but not for the other ones. How does this happen and how do I
    solve the problem?

    I look forward to your response.

    thank you,
    Addisu


    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Programming on SQL Server 7 with VB(using ADO)

    Realistically, any table should have a primary key!

    That said, I'm still a little confused by the scenario you're providing. Can
    you expand on it a bit?


    --
    Rob Vieira MCSD, MCT, MCDBA
    www.ProfessionalSQL.com

    "Addisu Mulat" <addisumulat@hotmail.com> wrote in message
    news:3a6e7ea4$1@news.devx.com...
    >
    > I have just started programming on SQL Server 7 with VB(using ADO).

    What
    > I have encountered is strange for me, its like this, I have programmed the
    > database (for multiuser environment) by making the lock type of the

    recordset
    > adLockPessimistic, I wanted the user to view changes if he wanted to by

    explicitly
    > refreshing the data himself but what happened is the changes made by user
    > user1 on one terminal is viewed by another user user2 on another terminal
    > without user2 explicitly refreshing the data. This happens for tables with
    > primary key but not for the other ones. How does this happen and how do I
    > solve the problem?
    >
    > I look forward to your response.
    >
    > thank you,
    > Addisu
    >
    >



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center