Advertisement

05.15.2008 at 08:53AM PDT, ID: 23405665 | Points: 500
[x]
Attachment Details

Microsoft SQL Server 2005 Linked Server to ABRA - Bookmark error

Asked by mdepasquale in SQL Server 2005, FoxPro Database, Windows OLE Programming

Tags: Microsoft, SQL Server, 2005

I've linked Microsoft SQL Server 2005 to Sage ABRA which uses FoxPro as it's database.  When I try and run an update on the FoxPro table, I get the following error -

OLE DB provider "VFPOLEDB" for linked server "ABRA" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 7333, Level 16, State 2, Procedure spETCABRAWorkCodeUpdate, Line 17
Cannot fetch a row using a bookmark from OLE DB provider "VFPOLEDB" for linked server "ABRA".

ABRA is the linked server name.Start Free Trial
 
Keywords: Microsoft SQL Server 2005 Linked …
Title
1 bookmark manager
2 OLE DB provider 'SQLOLEDB' retur…
3 Using VBA to delete entries next to Bo…
4 bookmark page
5 code for social bookmarking
6 Bookmarks
 
Loading Advertisement...
 
[+][-]05.15.2008 at 10:49AM PDT, ID: 21576364

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 10:56AM PDT, ID: 21576432

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 11:05AM PDT, ID: 21576512

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 11:26AM PDT, ID: 21576683

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628