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:
01060033
Views:
20
Oscar,
just a WAG (because I didn't understand error message in spansh at all :o))
Can you execute the same insert statement in query analizer w/o errors? Are you using MSDE and how big is DB? Is it over 2GB?

>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...!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform