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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC SQL Server error
- Thread starter sepia
- Start date
it seems the SQL statment u have to retrieve data from the DB invloves a Date field in the where cluase.
.eg where mydate = "10/01/2002"
the value "10/01/2002" in your case doesnt represent a validate date..
hence you get an error.. make sure the date value "10/01/2002" is a validate date..
cheers
CJ
.eg where mydate = "10/01/2002"
the value "10/01/2002" in your case doesnt represent a validate date..
hence you get an error.. make sure the date value "10/01/2002" is a validate date..
cheers
CJ
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question