Can u pls help me solve this problem
iam using vb6.0 and sql 2000. when i insert the currnt date (as Now()) in the dbase with a colunm datatype date/time, it inserts the date 01/01/1900.
In MSAccess it works by putting a # b4 and after the date e.g. #25/06/2010#
but it does not work with sql2000.
OR SQL2000 DOES NOT SUPPORT VB6 ?? OR IS IT SOME MISSING DRIVERS??