General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sudden SQL Server Error on Date fields
Environment versions
Network:
Windows 2008 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only