Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error with date field in SQL link server
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error with date field in SQL link server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01470562
Message ID:
01470562
Views:
94
Hi,

We are getting below error while running a query to show the date type data in SQL Server 2008.

Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Sample Query:
SELECT code, name, age, dob, doj
FROM [open_rowset]...[emp_data]

NOTE: dob & doj are date type fields.


Thanks In Advance
Ravi Mehrotra
Next
Reply
Map
View

Click here to load this message in the networking platform