odbcdataadapter problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an issue with odbc and dataadapter creation?
I have an access database with a table and a primary key. I've created an
odbc machine data source. When i attempt to create an odbcdataadapter (using
vs.net) I get an error when update and delete commands are generated. The
error says that vs.net could not determine the unique column for update and
delete.

When I create a oleDbDataAdapter i don't have a problem all statements are
created. What's up? anyone have anyideas what's happening?
thanks
kes
 
The OleDb interface to JET is more feature-rich and should be used in
virtually all cases. The Odbc drivers for JET are mostly for use with
Office.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
thanks
iou1
kes

William (Bill) Vaughn said:
The OleDb interface to JET is more feature-rich and should be used in
virtually all cases. The Odbc drivers for JET are mostly for use with
Office.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Click to expand...
 
Back
Top