General information
Title:
Cannot create OLEDB dataadapter for VFP
HI.
I am trying to create a Data Adapter in a form for VFP using OleDB
The table is working fine in VFP and I can add records through VFP with a Ctrl N.
Structure is fairly basic with a few fields, and one Auto Incrementing Field which also has a Primary Key attached, with the Index the same name as the field.
In .net windows forms, when I try to use the wizard to create a Data Adapter,
It creates the connection OK (Test connection comes back ok)
In the Choose a query type, i chose --> use Sql Statements
I Select * in options and in advanced options,
Generate,Insert,Update.delete is ticked
Use Optimistic Concurrency is ticked
Refrsh the dataset is greyed out and I cant tick
Then in View Wizard results ,top 3 are ticked but both
Generate Update Command and
geberate delete Command say there wer errors configuring the data Adapter anf have yellow icons beside them
Any ideas on whats happening here ?
regards,
Gerard
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only