Posted by Maciej07 on 06/25/07 08:52

Hello,

We are using SQL server 2000 on W2k Server and MS Access 2000 ADP
(like front-end). Now we try to change operating system for SQL Server
2000 from W2k to W2k3 and we found problem with date format - we
receive error: "Cannot convert date type varchar to datetime".

Datetime used in application are sent to SQL Server 2000 in format
YYYY-MM-DD as varchar. (in Query Analyzer all view/query works fine
but when application sends it as record source of any forms or stored
procedures it causes error). Moreover if we send date in format
YYYYMMDD it works OK, the same in case when we change FORMATDATE
before each SQL connection made by application (SET DATEFORMAT YMD)

What has happened after changing operating system?

thx for help

• Next in forum: Parallel build and subsequent re-name of a cube
• Prev in forum: Re: DB hostname, username, password etc
• Thread view: SQL 2000 date format problem after migration W2k to W2k3

[Reply to this message]