Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OBDS and SQL Server

Status
Not open for further replies.
csvideo

csvideo

Programmer
Oct 19, 2001
74
BB
I created a DSN for a SQL Server database. I use the DSN as the source for a remote view in VFP, however when the remote view is browsed the date field that is empty in the SQL Datsbase shows with the date 1900.01.01 in the remote view, WHY?
 
Sort by date Sort by votes
Because there is really no such thing as a empty date in sql server, so ODBC is doing the best it can. If you want empty dates in sql server set them to null.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
SQL Server data processing with VFP 8 1
Replies
8
Views
900
bharons
bharons
bharons
  • Locked
  • Question
Update Data SQL server Using Create Cursor VFP
Replies
13
Views
1K
bharons
bharons
Steve Yu
  • Locked
  • Question
Westwind Web Connection server on LAN: can SPT (MS SQL) work ? 4
2 3
Replies
44
Views
3K
Steve Yu
Steve Yu
CBellucci
  • Locked
  • Question
Retrieving Images (varbinary(max)) from MS SQL Server 1
Replies
3
Views
1K
Chris Miller
Chris Miller
GTGeek88
  • Locked
  • Question
SQL query syntax
Replies
7
Views
494
GTGeek88
GTGeek88

Part and Inventory Search

Sponsor

Back
Top