Re: Cannot insert or update columns from multiple tables (post #2) Need help please

1. I got exactly the same error message even if I remove "With
View_Metadata".
2. I cannot use a client-side cursor because the original tables has more
than 900 000 rows.
3. I cannot use a TADOCommand because I don't want to execute a specific
query, I want to Edit a dataset, allow user to change fields, and then post
the record.

I still don't understand why is it working with an ODBC driver and not with
an OLE DB driver. Microsoft advise me that is it a client app issue (not
SQL Server).

I really need to solve this issue, any help would be appreciate.

Christian Dubois


"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:447c53b7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
This is from BOL:

VIEW_METADATA

Specifies that SQL Server will return to the DBLIB, ODBC, and OLE DB APIs
the metadata information about the view, instead of the base table or
tables, when browse-mode metadata is being requested for a query that
references the view. Browse-mode metadata is additional metadata returned
by SQL Server to the client-side DB-LIB, ODBC, and OLE DB APIs, which
allow the client-side APIs to implement updatable client-side cursors.
Browse-mode meta data includes information about the base table that the
columns in the result set belong to.

As you see it states that it will work for the client-side cursors only,
but not for the server-side one.

If you really just want to update some record/records through a View then
you could switch to TADOCommand with appropriate commandtext assigned to
appropriate update statement. Can you explain what you are trying to
accomplish and why you can't use client side cursors?




.

Relevant Pages

  • Re: Best practice to transfer data from Excel file to SQL Server 2000
    ... What I am working on is a web-based client-side application. ... don't have the permission to use the Import/Export Utility in SQL Server ... >> I am trying write a web application using ASP.Net to load an Excel file ... >> client site and save all the data in the file to a table in SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Formatting Numeric Value in Computed Column
    ... If the value is below 1, I don't want the preceding zero, e.g. .123. ... this is typically thing you should handle client-side. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: How do I use a <asp:button> to close a window
    ... > I know how to connect to SQL server and update tables but I don't know how ... > to close browser window after that. ... closing window is on client side. ... client-side JavaScript;). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Infinite Length String
    ... SQL Server doesn't support datatypes of unlimited length. ... to 8000 bytes you can use a VARCHAR. ... Any more than that you'll have to do it client-side. ...
    (microsoft.public.sqlserver.programming)