Linked Server and cursor library

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: MeatPopsicle (anonymous_at_discussions.microsoft.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 09:37:41 -0700

When using a linked server to access a remote server
table which has a bracket name containing a period the
access fails with:

"The cursor does not include the table being modified or
the table is not updatable through the cursor."

After the period is removed the remote access succeeds.

Should the table name not be correct if it is bracketed
but containing a period?

This was not a big issue since I was not dependent on
there being a period in the name, but it did require a
little time to program a workaround.

I wasn't sure where to notify MS with this information so
that a fix could be included in a future SP for SQL
server.

Relevant Pages

  • Re: VB connection to SQL server
    ... > the client machine begins to lose its relevance and accuracy as soon as it ... > aware that the data is probably out of date, a client sided cursor might ... > design minimises the possibility that records will have changed in the ... >> The Database server is in the office, and people use the Vb program from ...
    (microsoft.public.vb.database)
  • Re: Huge memory comsumption of ADODB Connection object
    ... unless the cursor is returning data to the client* I don't see ... I suppose this could cause some extra memory ... Is there a similar behavior in Sybase? ... Server was originally based on that rdbms, so there very well may be. ...
    (microsoft.public.data.ado)
  • Re: copy folder to remote server
    ... copy folder to remote server ... copy folder to remote server ... Your search - madunix - did not match any documents. ...
    (RedHat)
  • Re: VB connection to SQL server
    ... "Chris Barber" wrote in message ... > recordsets (client side cursor) to allow you to persist the recordsets to ... aware that the data is probably out of date, a client sided cursor might fit ... That is because the SELECT statement is executed on the server and the data ...
    (microsoft.public.vb.database)
  • Re: Accessing A Large MS SQL Table Over ADO Components
    ... Client-side cursor fetches all rows, ... Because I had some performance loss when I set it up to Server ... Server-side cursor does not fetch all rows to client, so if server is on the ... > If we want to display the data on a readonly grid wich component is the ...
    (borland.public.delphi.database.ado)