Puma Posted June 26, 2008 Share Posted June 26, 2008 Hello, 3 days ago that i have reinstalled windows server 2003 on my same dedicated server ... I wanted reinstalled TCAdmin, but with in create new database, or restore database saved with the software BACK UP ET RESTORE of TCAdmin, i have the same error: example when i am in datacenter section: An error occurred while saving this datacenter: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL Command: UPDATE TC_DATACENTERS SET DISPLAY_NAME = 'OVH', ADDRESS1 = '', ADDRESS2 = '', ADDRESS3 = '', CITY = 'Roubaix', STATE = '', COUNTRY = 'FR', ALLOW_SIGNUPS = 1, SIGNUP_DISPLAY_NAME = 'Default' WHERE DATACENTER_ID = 'TC0633808447606' Same everywhere when i press save's button. I have, of course, reinstalled all requierement that TCA need to run correctly. Thanks you. Link to comment Share on other sites More sharing options...
adamnp Posted June 26, 2008 Share Posted June 26, 2008 how did you go about backing up the sql? -Adam Link to comment Share on other sites More sharing options...
JasonF Posted June 26, 2008 Share Posted June 26, 2008 If you are referring the the System Tools >> MySQL Backup, it will not backup Microsoft Data Access and will produce a blank file. Link to comment Share on other sites More sharing options...
Puma Posted June 26, 2008 Author Share Posted June 26, 2008 No, im referring to ->start->tcadmin control panel ->backup/restore Here, i have save files and database of the old server, and yesterday, i have try to restore with the same soft Link to comment Share on other sites More sharing options...
ECF Posted June 26, 2008 Share Posted June 26, 2008 It is using the MS Access driver as the error shows. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Do you have a Mysql database or an Access database? Link to comment Share on other sites More sharing options...
Puma Posted June 26, 2008 Author Share Posted June 26, 2008 Ms Acces, Problem fix by staff (right permissions) THX. Link to comment Share on other sites More sharing options...
adamnp Posted June 26, 2008 Share Posted June 26, 2008 If you are referring the the System Tools >> MySQL Backup, it will not backup Microsoft Data Access and will produce a blank file. You had the same thoughts I had Glad that ended up not being the case for him! That would have sucked. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.