Solved

Odbc Error

Posted on 1998-12-03
1
192 Views
Last Modified: 2010-03-19
I get this error when trying to access SQL through my VB program.
"[Microsoft][ODBC SQL Server Driver]Cursor concurrency changed"
Help?
0
Comment
Question by:Yogi012398
1 Comment
 
LVL 7

Accepted Solution

by:
tchalkov earned 50 total points
ID: 1092075
This error means that you are trying to update or insert in a dynaset on a table which does not have a primary key or unique index defined. Try defining a primary key or unique index on one or more of the table fields.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sort by Month and Year - SQL 3 23
Group by and order by clause 28 36
sql query Help 12 34
Join vs where 2 0
Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now