Hi All, I have strange error message when I try to import an Object into the Navision running on SQL 2000. Navision Attain 3.10B. I can import an earlier .fob of the same object, but cannot import the .fob containing my changes. All the development was made using Customer’s License, I can import and export the same object in my local copy (using NAvision Database). Error is “3207”,“42000”,{SQL ODBC error} user does not have permission to perform the operation on this table $ Modification are addition of a field. Thnx, Best regards, Prashanth NCFC, NCMC, NCSD prashycool@yahoo.com
quote:
Originally posted by prashycool: Error is “3207”,“42000”,{SQL ODBC error} user does not have permission to perform the operation on this table $ Modification are addition of a field.
This probably means the user account you login with does not have sufficient rights on the SQL Server side. In order to change the structure of a table you have to be the owner of the DB or a system administrator (in SQL) or a database creator. Regards Thomas
Hi thomas, I login as a super user and administrator to the database. Best regards, Prashanth NCFC, NCMC, NCSD prashycool@yahoo.com
Hi Prashanth, I don’t understand what you mean by Administrator to the database? Login as ‘sa’(Sys. Admin for SQL) and Check if you have been given ‘db_owner’ Access if not included, give the same. Alternatively you need to have ‘Database Creator’ role from Security–>Server Roles–>Database Creators. This should solve your problem, else try deleting your User ID and create again with db_owner access. Regards
Check the field number you’re tryng to add… ot should be between 50.000 and 99.999 Regards, Alfonso Pertierra (Spain)apertierra@teleline.es