Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to SQL Server - Ole db error 1435
Message
From
13/08/2007 13:09:30
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01247859
Message ID:
01247865
Views:
22
Not at the moment. What is really strange, is this only happens when we connect to a server, not our local copy of SQL Server 2005.


>Can you try to put this logic into SP and run SP instead?
>
>>Hi all,
>>
>>Not sure if this should be here or in VFP area, because I have a connection from VFP to SQL Server through OLE db. It is open when the application starts up. I build 5 temp tables with information passed from calling program. then run a select statement into a cursorfill that looks at the temp tables and some of the regular tables. This cursorfill gives the error 1435 - Microsoft OLE DB Provider for SQL Server: Row handle referred to a deleted row or a row marked for deletion.
>>
>> the temp tables all built with at least 1 record in each, some have more.
>>
>> If I run just the different select statements on the SQL Server 2005 Management Studio Express, I get records found. but running thru the application, I get the error.
>>
>>We are not sure that this error message is correct, because we do not have any deleted records in the temp tables.
>>
>>TIA
>>Beth
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform