Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL Error
Message
 
 
To
18/10/2005 16:05:09
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01060028
Message ID:
01060053
Views:
19
This message has been marked as the solution to the initial question of the thread.
Oscar,

Is it possible that a trigger has been added to the database?

>I have a VFP app which has been running for years at a customer site, connected to SQL server.
>
>Suddenly insert operations against a table began to fail with the following message (in spanish as it appears)
>No se pudo actualizar este registro debido a ..connectivity error...
>..[Microsoft][ODBC SQL Server driver][SQL Server] No se puede insertar fechas solapadas.. Sql estate 37000 Error numero 50000.
>
>I have not been able to find references to this error, nor to the English version which I suppose to be something like "Unable to insert overlapping dates"
>
>After this one comes a MSDTC error (transaction aborted)
>
>The failing insertion is done in a table which is transactionally replicated in another database, however the very first test I did was to disable replication. No changes at all, error persists. Application cannot be used.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform