need help with a foxpro linked server problem
i have some foxpro tables that are part of an app.
i have created a mssql linkedserver and can select records from a .aspx page
my problem is how to update the records from that same webpage.
the web page has a ddlist to select a acct
a gridveiw display a partial record
then a formview to display and edit a record selected in the gridview
i can select records ... then start an update in the form view ... just can't save the updated record
if you want to see the page look here:
http:// airportcoach.dyndns.biz/users/res_data.aspx
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; OfficeLiveConne ctor.1.4; OfficeLivePatch .1.3)
Timestamp: Wed, 9 Dec 2009 03:30:39 UTC
Message: Sys.WebForms.Pa geRequestManage rServerErrorExc eption: Cannot fetch a row using a bookmark from OLE DB provider "VFPOLEDB" for linked server "Reservatio ns".
OLE DB provider "VFPOLEDB" for linked server "Reservatio ns" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Line: 4723
Char: 21
Code: 0
i have some foxpro tables that are part of an app.
i have created a mssql linkedserver and can select records from a .aspx page
my problem is how to update the records from that same webpage.
the web page has a ddlist to select a acct
a gridveiw display a partial record
then a formview to display and edit a record selected in the gridview
i can select records ... then start an update in the form view ... just can't save the updated record
if you want to see the page look here:
http:// airportcoach.dyndns.biz/users/res_data.aspx
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; OfficeLiveConne ctor.1.4; OfficeLivePatch .1.3)
Timestamp: Wed, 9 Dec 2009 03:30:39 UTC
Message: Sys.WebForms.Pa geRequestManage rServerErrorExc eption: Cannot fetch a row using a bookmark from OLE DB provider "VFPOLEDB" for linked server "Reservatio ns".
OLE DB provider "VFPOLEDB" for linked server "Reservatio ns" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Line: 4723
Char: 21
Code: 0