Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sudden SQL Server Error on Date fields
Message
De
05/09/2013 11:03:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Sudden SQL Server Error on Date fields
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01582295
Message ID:
01582295
Vues:
55
I have a current application using VFP 9SP2 and SQL Server 2008 Express. Suddenly I'm having issues with a few machines running the application but not all.
I'm using remote views and the two terminal servers are returning a data type of character for one particular date field. The strange thing is if I run it from a desktop or the Domain Controller I have no issues. I'm assuming this is a client issue on the terminal server boxes. I've checked the version on all and they seem to be the same. Below is the error message I'm receiving.

Type conversion required by the Data Type Property for field 'dDate' is invalid.

Any help would be greatly appreciated.

TIA
Jeff
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform