Current Recordset does not support updating. This may be a limitation of the pro

I keep getting this error when I try to update

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

It worked fine in Access, but when I switched to SQL Server it stopped working.

Can someone help! Please!

thx

JustinHave you declared a primary key in SQL Server for the table(s) in your rowset?

-PatP|||Originally posted by Pat Phelan
Have you declared a primary key in SQL Server for the table(s) in your rowset?

-PatP

yes i have|||Is the column that SQL Server recognizes as the primary key included in your keyset? Can you post the DDL (the CREATE TABLE statement) and the DML (the SELECT statement) so we have some more to go on?

-PatP|||Originally posted by Pat Phelan
Is the column that SQL Server recognizes as the primary key included in your keyset? Can you post the DDL (the CREATE TABLE statement) and the DML (the SELECT statement) so we have some more to go on?

-PatP

Actually I found out what the problem was.

Access will allow 'ORDER BY' in the SQL statement, but SQL Server won't.

Thanks for your help though!

Justin|||Originally posted by justinbezanson
Actually I found out what the problem was.

Access will allow 'ORDER BY' in the SQL statement, but SQL Server won't.

Thanks for your help though!

Justin

What do you mean by "SQL Server won't"?
[Order By] is a commonly used in SQL Server. Somthing else must be the cause of the problem and I doubt that it is [Order By].|||Originally posted by GDMI
What do you mean by "SQL Server won't"?
[Order By] is a commonly used in SQL Server. Somthing else must be the cause of the problem and I doubt that it is [Order By]. I had some trouble swallowing that one too, but as long as Justin is happy with his answer, I'm Ok with it. I use ORDER BY all of the time, and have never had any problem with it, even in Recordsets.

-PatP

cubes error

Hi,

I want to know, if i can use (work) with the Analysis service tutorial of adventurewoks database in MS XP Pro

i use the SQL server 2005 enterprice edition .

When i deploy my analysis service tutorial, i can't connect to my server?(lesson reviewing cubes and demension, in SQL book online)

I checked my firewall,Protocols, restarted my SQL browser and SQL server,checked my windows authentication and i can't connect to my server.

Help help help.

Not sure if you can install SQL Server Enterprise edition on the XP. But I think you can install Developer edition there.

Try and open Adventure works sample project and try deploying it to the Analysis Server. If you were able to successfully deploy the project, you should be able to browse it as well.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.