ERROR with database after reinstallation of windows

[Puma]

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.

[adamnp]

how did you go about backing up the sql?

 

-Adam

[JasonF]

If you are referring the the System Tools >> MySQL Backup, it will not backup Microsoft Data Access and will produce a blank file.

[Puma]

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

[ECF]

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?

[Puma]

Ms Acces,

 

Problem fix by staff (right permissions)

 

THX.

[adamnp]

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.