Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

multiuser database updates using sql server and VB6

I have created a database in sql server 7, and writing a program in vb6 as the frontend. I am using a dataenvironment and sqloledb driver to connect to the database.

When testing the multiuser capability, and different users update the database, they are not seeing the updates of each other. I am using a server side and I have tried setting the database cursor to Dynamic, but it reverts to static. Please help??

Thanks.
0
ryanad063001
Asked:
ryanad063001
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
<but when it reverts to static. >

Because your cursor is client-sided.
0
 
DanRollinsCommented:
Hi ryanad@devx,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

    Accept emoreau's comment(s) as an answer.

ryanad@devx, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will follow up.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
Computer101Commented:
Comment from expert accepted as answer

Computer101
E-E Moderator
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now