Versions des environnements
Network:
Windows 2008 Server
>I just migrated from an SBS 2003 Network with SQL2000 to SBS 2011 with SQL 2008R2. I installed SQL 2008 R2 and did a restore from a SQL 2000 backup file. All my data is in SQL 2008 R2 by my remote views in VFP90 give me an update conflict when change something. I issue tablerevert and the requery and the change is actually there.
>
>I need to get this fixed as my internal app is now not functioning and I'm no SQL Admin.
>
>Thanks for any help.
Some ideas to try:
1) make sure you are using the right driver (in this case, sql server native client 10.5, I think).
2) set READ COMMITTED SNAPSHOT on (see MSDN for the how)
3) in the OTHER section of the connection string, set OTHER=Mars_Connection=yes;
hth,
Hank
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement