April 29, 2008 at 1:23 am
Hi,
Due to our older equipments we have to access tables in our SQL-Server databases using
an ODBC connection. This worked fine on a MS-SQL-7 server. After we have moved the databases on a machine wich runs MS-SQL2000 we cannot neither write nor update or append any records in the tables containd in the database. All logged users have read and write permisions granted on the database. All aplications that DO NOT use ODBC connections (ADO in our case) run normally with the same user logins.
Can anybody help me with this issue. It seems that I reached the end of my technical expertise 🙂
More details to our situation:
- Server OS: MS- Windows Server 2003 Standard
- SQL-Server : SQL-Sever 2000 with service Pack 3a
Many thanks in advance.
Emil P.
April 30, 2008 at 10:52 am
Do these tables have primary keys defined in SQL Server? I've seen this where ODBC will default to read-only cursors for tables w/o primary keys.
Steve G.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply