Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL Error
Message
From
18/10/2005 16:05:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Strange SQL Error
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01060028
Message ID:
01060028
Views:
58
Hello
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.

Any help will be appreciated...!
Next
Reply
Map
View

Click here to load this message in the networking platform