Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sudden SQL Server Error on Date fields
Message
From
05/09/2013 11:03:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sudden SQL Server Error on Date fields
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01582295
Message ID:
01582295
Views:
56
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
Map
View

Click here to load this message in the networking platform