Hi All,
I have 2 problems... I upsize my Access database to SQL Server 2000, After struggling with the new data type and all other issue(users permission) etc, I finally manage to set up the SQL Server database. My problem is that if I have a error in my sql statement example a incorect field name, well my asp page will run without any errors... The data in the table was not added though. But I do not have any error like I would normally receive with Access (cannot find the ordinal.. etc) . This is one problem.
The second is I insert a date field and when I go and check inside the table the date that was inserted is 1900-01-01 However the date that I am inserting is Date function..
Any help would be greatly appreciated
Thanks
I have 2 problems... I upsize my Access database to SQL Server 2000, After struggling with the new data type and all other issue(users permission) etc, I finally manage to set up the SQL Server database. My problem is that if I have a error in my sql statement example a incorect field name, well my asp page will run without any errors... The data in the table was not added though. But I do not have any error like I would normally receive with Access (cannot find the ordinal.. etc) . This is one problem.
The second is I insert a date field and when I go and check inside the table the date that was inserted is 1900-01-01 However the date that I am inserting is Date function..
Any help would be greatly appreciated
Thanks
